MySQL Legacy MCP
Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.
Install
registry version 0.2.1
npm
npx -y mysql-legacy-mcpnpm
npx -y mysql-legacy-mcp@0.2.1
Setup by client
Pick your client — the config below is generated for this server (local stdio). Copy respects the “Pin version” switch above.
claude_desktop_config.json
{
"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>"
}
}
}
}{
"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>"
}
}
}
}Format verified against the official Claude Desktop docs ↗.
terminal
claude mcp add --env MYSQL_LEGACY_HOST=<YOUR_MYSQL_LEGACY_HOST> --env MYSQL_LEGACY_USER=<YOUR_MYSQL_LEGACY_USER> --env MYSQL_LEGACY_PASSWORD=<YOUR_MYSQL_LEGACY_PASSWORD> mysql-legacy-mcp -- npx -y mysql-legacy-mcp
claude mcp add --env MYSQL_LEGACY_HOST=<YOUR_MYSQL_LEGACY_HOST> --env MYSQL_LEGACY_USER=<YOUR_MYSQL_LEGACY_USER> --env MYSQL_LEGACY_PASSWORD=<YOUR_MYSQL_LEGACY_PASSWORD> mysql-legacy-mcp -- npx -y mysql-legacy-mcp@0.2.1
Format verified against the official Claude Code docs ↗.
.cursor/mcp.json
{
"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>"
}
}
}
}{
"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>"
}
}
}
}Format verified against the official Cursor docs ↗.
.vscode/mcp.json
{
"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>"
}
}
}
}{
"servers": {
"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>"
}
}
}
}Format verified against the official VS Code docs ↗.
mcp_config.json
{
"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>"
}
}
}
}{
"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>"
}
}
}
}Format verified against the official Windsurf docs ↗.
Environment variables
Defined in the server's official registry manifest. Required secrets are shown as <YOUR_…> placeholders in the configs above.
MYSQL_LEGACY_HOSTrequired — Database host or local tunnel endpointMYSQL_LEGACY_USERrequired — Dedicated database reader accountMYSQL_LEGACY_PASSWORDrequired secret — Nonempty database account passwordMYSQL_LEGACY_PORT— TCP port, 1–65535MYSQL_LEGACY_DATABASE— Optional default databaseMYSQL_LEGACY_HIDE_SYSTEM_DATABASES— Hide mysql and information_schema from listingsMYSQL_LEGACY_QUERY_TIMEOUT— Driver query timeout, 100–60000 millisecondsMYSQL_LEGACY_MAX_ROWS— SELECT response row limit, 1–1000
GitHub
最近更新于 37 天前 · MIT license
About this server
MySQL Legacy MCP MCP server for legacy MySQL 5.0–5.6 databases through stdio. The package is on npm as mysql legacy mcp and in the official MCP Registry as io.github.Rufflet/mysql legacy mcp . It uses MySQL 5.1 compatible SQL and SHOW metadata queries. Live MCP tests cover MySQL 5.0.51a, 5.1.73, 5.5…
Summary from the project README — github.com/Rufflet/mysql-legacy-mcp
Distributed as npm, listed under Databases. Review our MCP security guide before granting access to real data.
Frequently asked questions
What does the MySQL Legacy MCP MCP server do?
MySQL Legacy MCP MCP server for legacy MySQL 5.0–5.6 databases through stdio. The package is on npm as mysql legacy mcp and in the official MCP Registry as io.github.Rufflet/mysql legacy mcp . It uses MySQL 5.1 compatible SQL and SHOW metadata queries. Live MCP tests cover MySQL 5.0.51a, 5.1.73, 5.5
How do I install MySQL Legacy MCP?
Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.
Is MySQL Legacy MCP free to use?
The MCP server itself is free to install. The source is public on https://github.com/Rufflet/mysql-legacy-mcp. Any third-party service it calls may require its own API key and account.
Which clients support MySQL Legacy MCP?
Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.
Add this badge
Publish this server? Link back with a badge on your README or site — copy either snippet.
Markdown
[](https://mcpnav.net/server/mysql-legacy-mcp/)
HTML
<a href="https://mcpnav.net/server/mysql-legacy-mcp/"><img src="https://mcpnav.net/badge/mysql-legacy-mcp.svg" alt="Listed on MCPNav" height="20"></a>