What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the MySQL MCP MCP server?
MCP server for one MySQL database: schema, read-only queries and guarded writes.
How to install MySQL MCP
Copy-paste configuration for popular MCP clients.
MYSQL_HOSTDatabase host.
MYSQL_PORTDatabase port.
MYSQL_USERrequiredMySQL user. Use one with the least privileges the task needs, never root.
MYSQL_PASSsecretPassword for that user. Treat it as a secret; MYSQL_PASS_FILE reads it from a file instead.
MYSQL_DBrequiredThe one database this server is bound to. No tool can leave it.
MYSQL_SSLRequire a TLS connection to the server.
MYSQL_SSL_CAPath to the CA bundle verifying the server certificate; implies MYSQL_SSL.
ALLOW_INSERT_OPERATIONAllow INSERT statements through the execute tool.
ALLOW_UPDATE_OPERATIONAllow UPDATE statements through the execute tool.
ALLOW_DELETE_OPERATIONAllow DELETE statements through the execute tool.
MYSQL_MAX_ROWSRow cap for one read; the result is marked truncated when it is hit.
MYSQL_TIMEOUT_MSStatement timeout in milliseconds; the connection is dropped on expiry.
{
"mcpServers": {
"mcp-mysql-client": {
"command": "npx",
"args": [
"-y",
"mcp-mysql-client"
],
"env": {
"MYSQL_HOST": "<YOUR_MYSQL_HOST>",
"MYSQL_PORT": "<YOUR_MYSQL_PORT>",
"MYSQL_USER": "<YOUR_MYSQL_USER>",
"MYSQL_PASS": "<YOUR_MYSQL_PASS>",
"MYSQL_DB": "<YOUR_MYSQL_DB>",
"MYSQL_SSL": "<YOUR_MYSQL_SSL>",
"MYSQL_SSL_CA": "<YOUR_MYSQL_SSL_CA>",
"ALLOW_INSERT_OPERATION": "<YOUR_ALLOW_INSERT_OPERATION>",
"ALLOW_UPDATE_OPERATION": "<YOUR_ALLOW_UPDATE_OPERATION>",
"ALLOW_DELETE_OPERATION": "<YOUR_ALLOW_DELETE_OPERATION>",
"MYSQL_MAX_ROWS": "<YOUR_MYSQL_MAX_ROWS>",
"MYSQL_TIMEOUT_MS": "<YOUR_MYSQL_TIMEOUT_MS>"
}
}
}
}Related MCP servers

Yandex Direct
MCP server for Yandex Direct API v5: manage PPC campaigns, ads, keywords, and statistics.

A1 Yandex KIT MCP
A1 Yandex KIT MCP server for the Yandex KIT e-commerce API: products, orders, discounts, webhooks.

Earth-2 Elevation MCP
Local stdio MCP server for Open-Elevation single, batch, and profile lookups.
Public, zero-auth, read-only access to Gkmex used-crane inventory.
View repository →
SMS en Masse
Envoyez des SMS et gérez vos campagnes directement depuis vos agents IA.
Create and send cinematic digital gifts for birthdays and anniversaries via Claude.
View repository →
