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 + Claude
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 Claude
Recommended path — works on claude.ai web without editing any config file.
- Open claude.ai/customize/connectors.
- Click "Add custom connector".
- Fill in:
- Name:
MySQL / MariaDB - URL:
https://cloud.anythingmcp.com/mcp - Authentication: Bearer token → paste your MCP API key (from AnythingMCP → Profile → MCP API Keys → New Key)
- Name:
- Click Connect to authorize.
All tools below appear in your chat — start typing prompts.
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 it work with Claude Code as well as Claude Desktop? Yes — point both at https://cloud.anythingmcp.com/mcp.
Next steps
Was this guide helpful?
