MySQL Legacy MCP MCP Server

io.github.Rufflet/mysql-legacy-mcp

Repository Registry

What is the MySQL Legacy MCP MCP server?

Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.

How to install MySQL Legacy MCP

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

MYSQL_LEGACY_HOST
required
Database host or local tunnel endpoint
MYSQL_LEGACY_USER
required
Dedicated database reader account
MYSQL_LEGACY_PASSWORD
required
secret
Nonempty database account password
MYSQL_LEGACY_PORT
TCP port, 1–65535
MYSQL_LEGACY_DATABASE
Optional default database
MYSQL_LEGACY_HIDE_SYSTEM_DATABASES
Hide mysql and information_schema from listings
MYSQL_LEGACY_QUERY_TIMEOUT
Driver query timeout, 100–60000 milliseconds
MYSQL_LEGACY_MAX_ROWS
SELECT response row limit, 1–1000
MYSQL_LEGACY_MAX_RESULT_BYTES
SELECT row-data JSON byte limit, 1024–1048576
MYSQL_LEGACY_CONNECT_TIMEOUT
Connection-establishment timeout, 100–60000 milliseconds
MYSQL_LEGACY_POOL_SIZE
Pooled connection limit, 1–50
MYSQL_LEGACY_ALLOW_INSERT
Enable the mysql_legacy_insert tool
MYSQL_LEGACY_ALLOW_UPDATE
Enable the mysql_legacy_update tool (WHERE clause always required)
MYSQL_LEGACY_ALLOW_DELETE
Enable the mysql_legacy_delete tool (WHERE clause always required)
MYSQL_LEGACY_ALLOW_DDL
Enable the mysql_legacy_ddl tool (table-level statements only)
MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
Disable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<YOUR_MYSQL_LEGACY_HOST>",
        "MYSQL_LEGACY_USER": "<YOUR_MYSQL_LEGACY_USER>",
        "MYSQL_LEGACY_PASSWORD": "<YOUR_MYSQL_LEGACY_PASSWORD>",
        "MYSQL_LEGACY_PORT": "<YOUR_MYSQL_LEGACY_PORT>",
        "MYSQL_LEGACY_DATABASE": "<YOUR_MYSQL_LEGACY_DATABASE>",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "<YOUR_MYSQL_LEGACY_HIDE_SYSTEM_DATABASES>",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "<YOUR_MYSQL_LEGACY_QUERY_TIMEOUT>",
        "MYSQL_LEGACY_MAX_ROWS": "<YOUR_MYSQL_LEGACY_MAX_ROWS>",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "<YOUR_MYSQL_LEGACY_MAX_RESULT_BYTES>",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "<YOUR_MYSQL_LEGACY_CONNECT_TIMEOUT>",
        "MYSQL_LEGACY_POOL_SIZE": "<YOUR_MYSQL_LEGACY_POOL_SIZE>",
        "MYSQL_LEGACY_ALLOW_INSERT": "<YOUR_MYSQL_LEGACY_ALLOW_INSERT>",
        "MYSQL_LEGACY_ALLOW_UPDATE": "<YOUR_MYSQL_LEGACY_ALLOW_UPDATE>",
        "MYSQL_LEGACY_ALLOW_DELETE": "<YOUR_MYSQL_LEGACY_ALLOW_DELETE>",
        "MYSQL_LEGACY_ALLOW_DDL": "<YOUR_MYSQL_LEGACY_ALLOW_DDL>",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "<YOUR_MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS>"
      }
    }
  }
}