PluginBench
MCP Server
Active
MIT

MySQL Legacy MCP MCP Server

io.github.Rufflet/mysql-legacy-mcp

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 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
JSON config
{
  "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>"
      }
    }
  }
}

Related MCP servers

Read and write WiseGrid sheets, rows, columns and reports from any AI agent.

0
Python
MIT
View repository →

MCP server for Ryvo Gateway x402, Helius Wallet, and Tokens API market data.

View repository →
LOlongpath logo

longpath

Active

Read-only P6 / MS Project schedule analysis: CPM, float, DCMA 14-point, logic checks, S-curves.

0
Python
MIT
View repository →
SQsqlglass logo

sqlglass

Active

SQL Server / Azure SQL for agents: real schema, lint, read-only runs, plans, write previews.

0
Python
MIT
View repository →

Policy-enforcing MCP proxy with portable evidence output.

7
Rust
MIT
View repository →

Indexes your project's markdown docs and serves them to any agent via local hybrid search.

5
TypeScript
MIT
View repository →