MySQL MCP MCP Server

io.github.gistrec/mcp-mysql-client

Repository Registry

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

{
  "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

Active

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

TypeScript

MIT

View repository →

A1 Yandex KIT MCP

Active

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

JavaScript

MIT

View repository →

SMS en Masse

Maintained

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

View repository →

io.github.git-akki/sendpookie

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

View repository →

duke-book

Manage Duke Bookmark notes, categories, and plan-enabled knowledge search over MCP.

View repository →

io.github.gitajhd/amanchain

Active

AmanChain: quantum-resistant x402 payments. Remote MCP, 50 paid services. USDC on Base or AMAN.

JavaScript

MIT

View repository →