Install MySQL Legacy MCP for Claude Desktop
Claude Desktop reads mcpServers from claude_desktop_config.json. Restart the app after saving.
- Open ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows, or ~/.config/Claude/claude_desktop_config.json on Linux.
- Paste the JSON config below.
- Replace placeholder secrets, then restart the client if it does not reload on its own.
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"rufflet-mysql-legacy-mcp": {
"command": "npx",
"args": [
"-y",
"mysql-legacy-mcp@0.2.1"
],
"env": {
"MYSQL_LEGACY_HOST": "",
"MYSQL_LEGACY_USER": "",
"MYSQL_LEGACY_PASSWORD": "YOUR_MYSQL_LEGACY_PASSWORD",
"MYSQL_LEGACY_PORT": "3306",
"MYSQL_LEGACY_DATABASE": "",
"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"
}
}
}
}