NestDaddy
All servers NestDaddy MCP Blog Sign inTry it free
Databases

MySQL Legacy MCP

io.github.Rufflet/mysql-legacy-mcp · v0.2.1

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

Website Source code Set it up

Connect Runs on your machine

Terminal
claude mcp add mysql-legacy-mcp -e MYSQL_LEGACY_HOST=<MYSQL_LEGACY_HOST> -e MYSQL_LEGACY_USER=<MYSQL_LEGACY_USER> -e MYSQL_LEGACY_PASSWORD=<MYSQL_LEGACY_PASSWORD> -e MYSQL_LEGACY_PORT=<MYSQL_LEGACY_PORT> -e MYSQL_LEGACY_DATABASE=<MYSQL_LEGACY_DATABASE> -e MYSQL_LEGACY_HIDE_SYSTEM_DATABASES=<MYSQL_LEGACY_HIDE_SYSTEM_DATABASES> -e MYSQL_LEGACY_QUERY_TIMEOUT=<MYSQL_LEGACY_QUERY_TIMEOUT> -e MYSQL_LEGACY_MAX_ROWS=<MYSQL_LEGACY_MAX_ROWS> -e MYSQL_LEGACY_MAX_RESULT_BYTES=<MYSQL_LEGACY_MAX_RESULT_BYTES> -e MYSQL_LEGACY_CONNECT_TIMEOUT=<MYSQL_LEGACY_CONNECT_TIMEOUT> -e MYSQL_LEGACY_POOL_SIZE=<MYSQL_LEGACY_POOL_SIZE> -e MYSQL_LEGACY_ALLOW_INSERT=<MYSQL_LEGACY_ALLOW_INSERT> -e MYSQL_LEGACY_ALLOW_UPDATE=<MYSQL_LEGACY_ALLOW_UPDATE> -e MYSQL_LEGACY_ALLOW_DELETE=<MYSQL_LEGACY_ALLOW_DELETE> -e MYSQL_LEGACY_ALLOW_DDL=<MYSQL_LEGACY_ALLOW_DDL> -e MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS=<MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS> -- npx -y [email protected]
claude_desktop_config.json
{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
        "MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>",
        "MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>",
        "MYSQL_LEGACY_PORT": "<MYSQL_LEGACY_PORT>",
        "MYSQL_LEGACY_DATABASE": "<MYSQL_LEGACY_DATABASE>",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "<MYSQL_LEGACY_HIDE_SYSTEM_DATABASES>",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "<MYSQL_LEGACY_QUERY_TIMEOUT>",
        "MYSQL_LEGACY_MAX_ROWS": "<MYSQL_LEGACY_MAX_ROWS>",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "<MYSQL_LEGACY_MAX_RESULT_BYTES>",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "<MYSQL_LEGACY_CONNECT_TIMEOUT>",
        "MYSQL_LEGACY_POOL_SIZE": "<MYSQL_LEGACY_POOL_SIZE>",
        "MYSQL_LEGACY_ALLOW_INSERT": "<MYSQL_LEGACY_ALLOW_INSERT>",
        "MYSQL_LEGACY_ALLOW_UPDATE": "<MYSQL_LEGACY_ALLOW_UPDATE>",
        "MYSQL_LEGACY_ALLOW_DELETE": "<MYSQL_LEGACY_ALLOW_DELETE>",
        "MYSQL_LEGACY_ALLOW_DDL": "<MYSQL_LEGACY_ALLOW_DDL>",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "<MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
        "MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>",
        "MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>",
        "MYSQL_LEGACY_PORT": "<MYSQL_LEGACY_PORT>",
        "MYSQL_LEGACY_DATABASE": "<MYSQL_LEGACY_DATABASE>",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "<MYSQL_LEGACY_HIDE_SYSTEM_DATABASES>",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "<MYSQL_LEGACY_QUERY_TIMEOUT>",
        "MYSQL_LEGACY_MAX_ROWS": "<MYSQL_LEGACY_MAX_ROWS>",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "<MYSQL_LEGACY_MAX_RESULT_BYTES>",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "<MYSQL_LEGACY_CONNECT_TIMEOUT>",
        "MYSQL_LEGACY_POOL_SIZE": "<MYSQL_LEGACY_POOL_SIZE>",
        "MYSQL_LEGACY_ALLOW_INSERT": "<MYSQL_LEGACY_ALLOW_INSERT>",
        "MYSQL_LEGACY_ALLOW_UPDATE": "<MYSQL_LEGACY_ALLOW_UPDATE>",
        "MYSQL_LEGACY_ALLOW_DELETE": "<MYSQL_LEGACY_ALLOW_DELETE>",
        "MYSQL_LEGACY_ALLOW_DDL": "<MYSQL_LEGACY_ALLOW_DDL>",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "<MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mysql-legacy-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
        "MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>",
        "MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>",
        "MYSQL_LEGACY_PORT": "<MYSQL_LEGACY_PORT>",
        "MYSQL_LEGACY_DATABASE": "<MYSQL_LEGACY_DATABASE>",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "<MYSQL_LEGACY_HIDE_SYSTEM_DATABASES>",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "<MYSQL_LEGACY_QUERY_TIMEOUT>",
        "MYSQL_LEGACY_MAX_ROWS": "<MYSQL_LEGACY_MAX_ROWS>",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "<MYSQL_LEGACY_MAX_RESULT_BYTES>",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "<MYSQL_LEGACY_CONNECT_TIMEOUT>",
        "MYSQL_LEGACY_POOL_SIZE": "<MYSQL_LEGACY_POOL_SIZE>",
        "MYSQL_LEGACY_ALLOW_INSERT": "<MYSQL_LEGACY_ALLOW_INSERT>",
        "MYSQL_LEGACY_ALLOW_UPDATE": "<MYSQL_LEGACY_ALLOW_UPDATE>",
        "MYSQL_LEGACY_ALLOW_DELETE": "<MYSQL_LEGACY_ALLOW_DELETE>",
        "MYSQL_LEGACY_ALLOW_DDL": "<MYSQL_LEGACY_ALLOW_DDL>",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "<MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

NameDescription
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
Optional		TCP port, 1–65535
MYSQL_LEGACY_DATABASE
Optional		Optional default database
MYSQL_LEGACY_HIDE_SYSTEM_DATABASES
Optional		Hide mysql and information_schema from listings
MYSQL_LEGACY_QUERY_TIMEOUT
Optional		Driver query timeout, 100–60000 milliseconds
MYSQL_LEGACY_MAX_ROWS
Optional		SELECT response row limit, 1–1000
MYSQL_LEGACY_MAX_RESULT_BYTES
Optional		SELECT row-data JSON byte limit, 1024–1048576
MYSQL_LEGACY_CONNECT_TIMEOUT
Optional		Connection-establishment timeout, 100–60000 milliseconds
MYSQL_LEGACY_POOL_SIZE
Optional		Pooled connection limit, 1–50
MYSQL_LEGACY_ALLOW_INSERT
Optional		Enable the mysql_legacy_insert tool
MYSQL_LEGACY_ALLOW_UPDATE
Optional		Enable the mysql_legacy_update tool (WHERE clause always required)
MYSQL_LEGACY_ALLOW_DELETE
Optional		Enable the mysql_legacy_delete tool (WHERE clause always required)
MYSQL_LEGACY_ALLOW_DDL
Optional		Enable the mysql_legacy_ddl tool (table-level statements only)
MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
Optional		Disable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+

Details

Package[email protected] (NPM, stdio)
First published14 Sep 2026
Last updated14 Sep 2026
Registry nameio.github.Rufflet/mysql-legacy-mcp

More databases servers See all

  • VibeScale

    Pre-launch checks for AI-built apps: leaked keys, Supabase RLS gaps, browser-exposed env vars.

  • Imf Mcp Server

    Query IMF SDMX 3.0 macroeconomic dataflows — WEO, BOP, CPI, exchange rates, 190 countries.

  • Apex DB

    Vehicle specifications, emissions, and powertrain data with source provenance.

  • TrialBase DB

    Clinical trials across multiple registries with identifiers and source links.

  • PatchLabs

    Security checks for AI-built apps (Lovable, Supabase, Bolt): RLS, headers, monitoring, fixes.

  • Tidy Byte Tools API

    Remote MCP for JSON repair, hashing, formatting, IDs, dates, units, and other small tools.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.