Skip the install. Get this working in under 2 minutes.
Start a free trial on cloud.anythingmcp.com, add the MySQL / MariaDB in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.
Summary
Query a MySQL or MariaDB database directly: list tables, describe columns and run read-only SQL. Installs read-only; credentials are held encrypted rather than in the connection string.
Try asking
Example prompts for MySQL / MariaDB
Click any prompt to copy it. Paste into Claude, ChatGPT, Cursor, Gemini, Copilot or OpenClaw to run it against this connector.
Claude is AI and can make mistakes. Please double-check responses.
💡 No install? Use cloud.anythingmcp.com directly. Sign in, click Connectors → MySQL / MariaDB, paste your credentials, mint an MCP API key — done. No Docker, no
git clone, no local server.
MySQL / MariaDB + Gemini
Query a MySQL or MariaDB database directly: list tables, describe columns and run read-only SQL. Installs read-only; credentials are held encrypted rather than in the connection string.
Prerequisites
See the full setup instructions baked into the connector (visible in the in-app store when you select the connector). The required environment variables for this connector are:
MYSQL_HOST, MYSQL_PORT, MYSQL_DATABASE, MYSQL_USER, MYSQL_PASSWORD
Step 1 — Get credentials
Setup
- Create a dedicated user and grant it only SELECT:
NarrowCREATE USER 'amcp_reader'@'%' IDENTIFIED BY 'change-me'; GRANT SELECT ON sales.* TO 'amcp_reader'@'%'; FLUSH PRIVILEGES;'%'to the AnythingMCP host if you can — MySQL's host part of the account name is a real access control and worth using. - Set
MYSQL_HOST,MYSQL_PORT(3306),MYSQL_DATABASE,MYSQL_USERandMYSQL_PASSWORD.
MariaDB works unchanged. The engine also accepts a mariadb:// DSN and normalises it, because the mysql2 driver only understands mysql://. Either scheme reaches a MariaDB server.
…(continued in the in-app connector instructions)
Step 2 — Install the adapter
curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d
Step 3 — Add the connector in Gemini
Your server URL: in AnythingMCP, open MCP Servers → the server this connector is on, and copy its URL (
https://cloud.anythingmcp.com/mcp/…). Use it wherever this guide showsYOUR_SERVER_ID.
Gemini CLI reads MCP servers from ~/.gemini/settings.json (or %APPDATA%\gemini\settings.json on Windows). Add:
{
"mcpServers": {
"anythingmcp": {
"httpUrl": "https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID",
"headers": { "X-API-Key": "YOUR_MCP_API_KEY" }
}
}
}
- Get your MCP API key from AnythingMCP → MCP Servers → your server → API keys.
- Save the file and restart
gemini. - Run
/mcpinside the Gemini CLI —MySQL / MariaDBshould be listed as available. - Vertex AI Studio: pass
https://cloud.anythingmcp.com/mcp/YOUR_SERVER_IDto thetoolsarray of your request with the sameX-API-Keyheader.
Available tools
| Tool | What it does |
|---|---|
mysql_list_tables | List the tables and views in the database with their schema and, where the server tracks it, an approximate row count |
mysql_describe_table | Describe one table: every column with its data type, nullability and default |
mysql_find_columns | Find columns across every table whose name matches a pattern — the fast way to locate where customer e-mail addresses, IBANs or order number |
mysql_query | Run a read-only SQL statement against MySQL / MariaDB and return up to 1000 rows |
mysql_query_examples | Show worked example queries for MySQL / MariaDB: how to list schemas, find large tables, inspect indexes and check what is running right now |
FAQ
Does Gemini 1.5 Pro or 2.x support MCP? Yes — Gemini CLI ≥ 0.4 and Vertex AI tools API both accept MCP httpUrl connectors with custom headers.
Next steps
Was this guide helpful?
