tokenlite mysql mcp for Zed
io.github.andezdev/tokenlite-mysql-mcp
A secure, efficient, and intelligent MySQL server for the Model Context Protocol
client:Zed
transport:stdio
runtime:npm
Install tokenlite mysql mcp in Zed
~/.config/zed/settings.json · windows: %APPDATA%\Zed\settings.json
{
"context_servers": {
"tokenlite-mysql-mcp": {
"command": "npx",
"args": [
"-y",
"@andezdev/tokenlite-mysql-mcp"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_NAME": "<DB_NAME>",
"MCP_EXPLAIN_MAX_SCAN_ROWS": "<MCP_EXPLAIN_MAX_SCAN_ROWS>",
"MCP_QUERY_ROW_LIMIT": "<MCP_QUERY_ROW_LIMIT>",
"MCP_SAFE_QUERY_MAX_ROWS": "<MCP_SAFE_QUERY_MAX_ROWS>",
"MCP_SAFE_QUERY_ENABLE_BLOCKING": "<MCP_SAFE_QUERY_ENABLE_BLOCKING>",
"MCP_METADATA_PATH": "<MCP_METADATA_PATH>",
"MCP_TEMPLATES_PATH": "<MCP_TEMPLATES_PATH>",
"TOOL_PREFIX": "<TOOL_PREFIX>",
"MCP_RATE_LIMIT_RPM": "<MCP_RATE_LIMIT_RPM>",
"MYSQL_QUERY_TIMEOUT": "<MYSQL_QUERY_TIMEOUT>",
"MYSQL_CONNECTION_LIMIT": "<MYSQL_CONNECTION_LIMIT>",
"MYSQL_CONNECT_TIMEOUT": "<MYSQL_CONNECT_TIMEOUT>",
"MYSQL_RETRY_ATTEMPTS": "<MYSQL_RETRY_ATTEMPTS>",
"MYSQL_RETRY_DELAY_MS": "<MYSQL_RETRY_DELAY_MS>",
"MYSQL_QUEUE_LIMIT": "<MYSQL_QUEUE_LIMIT>",
"MCP_DDL_CACHE_TTL": "<MCP_DDL_CACHE_TTL>",
"MCP_LOG_LEVEL": "<MCP_LOG_LEVEL>",
"ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
"ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
"ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
"ALLOW_DDL_OPERATION": "<ALLOW_DDL_OPERATION>",
"DB_SSL": "<DB_SSL>",
"DB_SSL_REJECT_UNAUTHORIZED": "<DB_SSL_REJECT_UNAUTHORIZED>"
}
}
}
}
Merge this into your existing settings object — do not replace the file. Zed docs