PluginBench
MCP Server
Maintained
MIT

MySQL MCP MCP Server

io.github.gistrec/mcp-mysql-client

RepositoryRegistry
How to choose

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.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • MYSQL_HOST

    Database host.

  • MYSQL_PORT

    Database port.

  • MYSQL_USER
    required

    MySQL user. Use one with the least privileges the task needs, never root.

  • MYSQL_PASS
    secret

    Password for that user. Treat it as a secret; MYSQL_PASS_FILE reads it from a file instead.

  • MYSQL_DB
    required

    The one database this server is bound to. No tool can leave it.

  • MYSQL_SSL

    Require a TLS connection to the server.

  • MYSQL_SSL_CA

    Path to the CA bundle verifying the server certificate; implies MYSQL_SSL.

  • ALLOW_INSERT_OPERATION

    Allow INSERT statements through the execute tool.

  • ALLOW_UPDATE_OPERATION

    Allow UPDATE statements through the execute tool.

  • ALLOW_DELETE_OPERATION

    Allow DELETE statements through the execute tool.

  • MYSQL_MAX_ROWS

    Row cap for one read; the result is marked truncated when it is hit.

  • MYSQL_TIMEOUT_MS

    Statement timeout in milliseconds; the connection is dropped on expiry.

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "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

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

1
TypeScript
MIT
View repository →

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

0
JavaScript
MIT
View repository →

Local stdio MCP server for Open-Elevation single, batch, and profile lookups.

0
JavaScript
MIT
View repository →

Public, zero-auth, read-only access to Gkmex used-crane inventory.

View repository →
SMSMS en Masse logo

SMS en Masse

Maintained

Envoyez des SMS et gérez vos campagnes directement depuis vos agents IA.

0
View repository →

Create and send cinematic digital gifts for birthdays and anniversaries via Claude.

View repository →