MySQL Legacy MCP for Zed
io.github.rufflet/mysql-legacy-mcp
Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.
client:Zed
transport:stdio
runtime:npm
Install MySQL Legacy MCP in Zed
~/.config/zed/settings.json · windows: %APPDATA%\Zed\settings.json
{
"context_servers": {
"mysql-legacy-mcp": {
"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>",
"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>"
}
}
}
}
Merge this into your existing settings object — do not replace the file. Zed docs