MySQL Legacy MCP Server

by ruffletio.github.Rufflet/mysql-legacy-mcpv0.2.1

MCP queries and schema inspection for legacy MySQL 5.0–5.6, with opt-in INSERT/UPDATE/DELETE/DDL; verified live against each version.

0Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active18d ago

Install MySQL Legacy MCP server

claude mcp add mysql-legacy -e MYSQL_LEGACY_HOST='<mysql-legacy-host>' -e MYSQL_LEGACY_USER='<mysql-legacy-user>' -e MYSQL_LEGACY_PASSWORD='<mysql-legacy-password>' -- npx -y mysql-legacy-mcp

{
  "mcpServers": {
    "mysql-legacy": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<mysql-legacy-host>",
        "MYSQL_LEGACY_USER": "<mysql-legacy-user>",
        "MYSQL_LEGACY_PASSWORD": "<mysql-legacy-password>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "mysql-legacy": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<mysql-legacy-host>",
        "MYSQL_LEGACY_USER": "<mysql-legacy-user>",
        "MYSQL_LEGACY_PASSWORD": "<mysql-legacy-password>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "mysql-legacy": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<mysql-legacy-host>",
        "MYSQL_LEGACY_USER": "<mysql-legacy-user>",
        "MYSQL_LEGACY_PASSWORD": "<mysql-legacy-password>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "mysql-legacy": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<mysql-legacy-host>",
        "MYSQL_LEGACY_USER": "<mysql-legacy-user>",
        "MYSQL_LEGACY_PASSWORD": "<mysql-legacy-password>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
MYSQL_LEGACY_HOST	yes	—	Database host or local tunnel endpoint
MYSQL_LEGACY_USER	yes	—	Dedicated database reader account
MYSQL_LEGACY_PASSWORD	yes	yes	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+

Freshness

Active — last maintenance signal 18d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-09-22 · 18d ago · GitHub
Latest release
2026-09-14 · 26d ago · GitHub · v0.2.1
Package published
no data · npm/PyPI
Registry entry updated
2026-09-14 · 26d ago · official registry · v0.2.1

FAQ

›How do I install the MySQL Legacy MCP server in Claude Code?

Run: claude mcp add mysql-legacy -e MYSQL_LEGACY_HOST='<mysql-legacy-host>' -e MYSQL_LEGACY_USER='<mysql-legacy-user>' -e MYSQL_LEGACY_PASSWORD='<mysql-legacy-password>' -- npx -y mysql-legacy-mcp. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does MySQL Legacy require an API key?

Yes. It expects MYSQL_LEGACY_HOST, MYSQL_LEGACY_USER, MYSQL_LEGACY_PASSWORD, of which 1 is a secret.

›Can I use MySQL Legacy as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is MySQL Legacy in the official MCP registry?

Yes, as io.github.Rufflet/mysql-legacy-mcp.