MySQL Legacy MCP

io.github.Rufflet/mysql-legacy-mcp

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

View repository →Homepage →

Connect this server

Add this to your MCP client config — claude_desktop_config.json (Claude Desktop) or .cursor/mcp.json (Cursor).Suits: Claude Desktop · Cursor.

{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp@0.2.1"
      ],
      "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": "3306",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "true",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "10000",
        "MYSQL_LEGACY_MAX_ROWS": "200",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "262144",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "10000",
        "MYSQL_LEGACY_POOL_SIZE": "5",
        "MYSQL_LEGACY_ALLOW_INSERT": "false",
        "MYSQL_LEGACY_ALLOW_UPDATE": "false",
        "MYSQL_LEGACY_ALLOW_DELETE": "false",
        "MYSQL_LEGACY_ALLOW_DDL": "false",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "false"
      }
    }
  }
}
Environment variables
  • MYSQL_LEGACY_HOSTrequiredDatabase host or local tunnel endpoint
  • MYSQL_LEGACY_USERrequiredDedicated database reader account
  • MYSQL_LEGACY_PASSWORDrequiredsecretNonempty database account password
  • MYSQL_LEGACY_PORTTCP port, 1–65535
  • MYSQL_LEGACY_HIDE_SYSTEM_DATABASESHide mysql and information_schema from listings
  • MYSQL_LEGACY_QUERY_TIMEOUTDriver query timeout, 100–60000 milliseconds
  • MYSQL_LEGACY_MAX_ROWSSELECT response row limit, 1–1000
  • MYSQL_LEGACY_MAX_RESULT_BYTESSELECT row-data JSON byte limit, 1024–1048576
  • MYSQL_LEGACY_CONNECT_TIMEOUTConnection-establishment timeout, 100–60000 milliseconds
  • MYSQL_LEGACY_POOL_SIZEPooled connection limit, 1–50
  • MYSQL_LEGACY_ALLOW_INSERTEnable the mysql_legacy_insert tool
  • MYSQL_LEGACY_ALLOW_UPDATEEnable the mysql_legacy_update tool (WHERE clause always required)
  • MYSQL_LEGACY_ALLOW_DELETEEnable the mysql_legacy_delete tool (WHERE clause always required)
  • MYSQL_LEGACY_ALLOW_DDLEnable the mysql_legacy_ddl tool (table-level statements only)
  • MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONSDisable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+

A starting point — check the repository for exact arguments and setup. Restart your client after editing the config.

Category
Developer Tools
Version
0.2.1
Registry
active
Published
9/14/2026

More Developer Tools servers

Browse all Developer Tools →

Verdi Bridge

RuihongY

Inspect waveforms and navigate RTL in live Synopsys Verdi. Requires a licensed Verdi installation.

Developer ToolsAdded 3 weeks ago

Ripio (community, read-only)

ruizemanuel

Unofficial, read-only MCP server for your Ripio account: balances, activity, prices and deposits.

Developer ToolsAdded 1 month ago

io.github.Rul1an/assay

Rul1an

The firewall for MCP tool calls. Block, audit, replay with evidence bundles.

Developer ToolsAdded 7 months ago

io.github.RuloGB/compendio-mcp

RuloGB

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

Developer ToolsAdded 1 month ago

AgentPay

Rumblingb

Agent payments, API key vaulting, and governed mandates. Agents spend within user-defined limits.

Developer ToolsAdded 5 months ago

io.github.Rumblingb/agentpay-gateway-mcp

Rumblingb

Centralized API gateway routing to MCP servers with per-call billing

Developer ToolsAdded 5 months ago

Add the badge to your site

Show visitors that MySQL Legacy MCP is listed here — it’s also the link we check for a free listing.

MySQL Legacy MCP — listed on Serverdex

HTML — for your website

<a href="https://serverdex.io/server/io-github-rufflet-mysql-legacy-mcp?utm_source=badge"><img src="https://serverdex.io/brand/badge.svg" alt="MySQL Legacy MCP — listed on Serverdex" width="123" height="40" loading="lazy"></a>

Recommended. A dofollow link from your own domain is the one that counts for search engines, and it's the link we check for a free listing.

Markdown — for your README

[![MySQL Legacy MCP — listed on Serverdex](https://serverdex.io/brand/badge.svg)](https://serverdex.io/server/io-github-rufflet-mysql-legacy-mcp?utm_source=badge)

Nice for visibility, but GitHub marks README links nofollow, so it doesn't pass authority. Use the HTML badge on your site as well.