MySQL Legacy MCP

Name: MySQL Legacy MCP
Author: Rufflet

Community

MCP server by Rufflet · updated 1 month ago · ★ 0 · 20 downloads a week

Score 30

Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0. MySQL Legacy MCP is a community project by Rufflet, not verified by a company domain.

Install Add to Cursor Add to VS Code GitHub

Yours? Claim it

Works withClaude Code Claude Desktop Cursor Codex Gemini CLI VS Code Windsurf Antigravity CLI

Maintenance

Last commit 31 days ago

Licence

MIT: permissive, fine for commercial use

Quality

Clear description, published package or server URL, original repository

Security

Not checked yet. What we check

What you need

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

From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.

Install MySQL Legacy MCP

Built from the published package, never by AI

claude mcp add mysql-legacy-mcp -e MYSQL_LEGACY_HOST=YOUR_MYSQL_LEGACY_HOST -e MYSQL_LEGACY_USER=YOUR_MYSQL_LEGACY_USER -e MYSQL_LEGACY_PASSWORD=YOUR_MYSQL_LEGACY_PASSWORD -- npx -y mysql-legacy-mcp

Run in your terminal. Add --scope user to use it in every project.

Step-by-step: install MySQL Legacy MCP in Claude Code

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

Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.

Step-by-step: install MySQL Legacy MCP in Claude Desktop

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

Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).

Step-by-step: install MySQL Legacy MCP in Cursor

{
  "servers": {
    "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"
      }
    }
  }
}

Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".

Step-by-step: install MySQL Legacy MCP in VS Code

codex mcp add mysql-legacy-mcp --env MYSQL_LEGACY_HOST=YOUR_MYSQL_LEGACY_HOST --env MYSQL_LEGACY_USER=YOUR_MYSQL_LEGACY_USER --env MYSQL_LEGACY_PASSWORD=YOUR_MYSQL_LEGACY_PASSWORD -- npx -y mysql-legacy-mcp

Step-by-step: install MySQL Legacy MCP in Codex

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

Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).

Step-by-step: install MySQL Legacy MCP in Antigravity CLI

gemini mcp add mysql-legacy-mcp npx -y mysql-legacy-mcp

Gemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.

Step-by-step: install MySQL Legacy MCP in Gemini CLI

MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the mysql-legacy-mcp block.

Weekly newsletter

Like MySQL Legacy MCP? Get the best new MCP servers every week

The best new tools, security warnings before you install something risky, and one practical tip. Free, three minute read.

Alternatives to MySQL Legacy MCP

All alternatives →

Supabase supabase

MCP server for interacting with the Supabase platform

AAB Local and remote 65k/wk

ArcadeDB MCP Server ArcadeData

Built-in MCP server for ArcadeDB multi-model database (graph, document, vector, time-series)

AAA Local 1.2k

MCP Toolbox for Databasesgoogleapis

MCP Toolbox for Databases enables your agent to connect to your database.

AAA Local 17k

MCP Toolbox for Databasesgoogleapis

MCP Toolbox for Databases enables your agent to connect to your database.

AAA Local 17k

mcpkubeshark

Real-time Kubernetes network traffic visibility and API analysis for HTTP, gRPC, Redis, Kafka, DNS.

AAA Local 12k

Ruvector ruvnet

Self-learning vector database for Node.js — hybrid search, Graph RAG, FlashAttention-3, HNSW, 50+ attention mechanisms

AAA Local 72k/wk

MySQL Legacy MCP vs Supabase MySQL Legacy MCP vs ArcadeDB MCP Server MySQL Legacy MCP vs MCP Toolbox for Databases

MySQL Legacy MCP: common questions

How do I install MySQL Legacy MCP?

In Claude Code run claude mcp add mysql-legacy-mcp -e MYSQL_LEGACY_HOST=YOUR_MYSQL_LEGACY_HOST -e MYSQL_LEGACY_USER=YOUR_MYSQL_LEGACY_USER -e MYSQL_LEGACY_PASSWORD=YOUR_MYSQL_LEGACY_PASSWORD -- npx -y mysql-legacy-mcp. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.

Is MySQL Legacy MCP the official server?

MySQL Legacy MCP is a community project by Rufflet, not verified by a company domain.

Is MySQL Legacy MCP free?

The code is published under the MIT licence. The service it connects to may have its own pricing.

Is MySQL Legacy MCP safe to use?

It scores 30 of 100. Grades: maintenance B, licence A, quality C. The security check has not run for it yet. Review the code before you install. How grades work.

What are alternatives to MySQL Legacy MCP?

Does MySQL Legacy MCP work with ChatGPT?

Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.