MySQL MCP for Zed
io.github.gistrec/mcp-mysql-client
MCP server for one MySQL database: schema, read-only queries and guarded writes.
client:Zed
transport:stdio
runtime:npm
Install MySQL MCP in Zed
~/.config/zed/settings.json · windows: %APPDATA%\Zed\settings.json
{
"context_servers": {
"mcp-mysql-client": {
"command": "npx",
"args": [
"-y",
"mcp-mysql-client"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_PORT": "<MYSQL_PORT>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASS": "<MYSQL_PASS>",
"MYSQL_DB": "<MYSQL_DB>",
"MYSQL_SSL": "<MYSQL_SSL>",
"MYSQL_SSL_CA": "<MYSQL_SSL_CA>",
"ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
"ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
"ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
"MYSQL_MAX_ROWS": "<MYSQL_MAX_ROWS>",
"MYSQL_TIMEOUT_MS": "<MYSQL_TIMEOUT_MS>"
}
}
}
}
Merge this into your existing settings object — do not replace the file. Zed docs