MySQL MCP server with multi-connection support, safe-by-default writes, query inspection and performance analysis.
接入配置
选择客户端,复制配置,再按项目文档补齐环境变量。
claude mcp add mysql-server-guangyiding --env MYSQL_DATASOURCES='<MYSQL_DATASOURCES>' --env MYSQL_DANGER_MODE='<MYSQL_DANGER_MODE>' -- npx -y @nolimit35/mysql-mcp-server~/.codex/config.toml
[mcp_servers.mysql-server-guangyiding]
command = "npx"
args = ["-y", "@nolimit35/mysql-mcp-server"]
env = { MYSQL_DATASOURCES = "<MYSQL_DATASOURCES>", MYSQL_DANGER_MODE = "<MYSQL_DANGER_MODE>" }
# codex mcp add mysql-server-guangyiding --env MYSQL_DATASOURCES='<MYSQL_DATASOURCES>' --env MYSQL_DANGER_MODE='<MYSQL_DANGER_MODE>' -- npx -y @nolimit35/mysql-mcp-server~/.cursor/mcp.json
{
"mcpServers": {
"mysql-server-guangyiding": {
"command": "npx",
"args": [
"-y",
"@nolimit35/mysql-mcp-server"
],
"env": {
"MYSQL_DATASOURCES": "<MYSQL_DATASOURCES>",
"MYSQL_DANGER_MODE": "<MYSQL_DANGER_MODE>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"mysql-server-guangyiding": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@nolimit35/mysql-mcp-server"
],
"env": {
"MYSQL_DATASOURCES": "<MYSQL_DATASOURCES>",
"MYSQL_DANGER_MODE": "<MYSQL_DANGER_MODE>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"mysql-server-guangyiding": {
"command": "npx",
"args": [
"-y",
"@nolimit35/mysql-mcp-server"
],
"env": {
"MYSQL_DATASOURCES": "<MYSQL_DATASOURCES>",
"MYSQL_DANGER_MODE": "<MYSQL_DANGER_MODE>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"mysql-server-guangyiding": {
"command": "npx",
"args": [
"-y",
"@nolimit35/mysql-mcp-server"
],
"env": {
"MYSQL_DATASOURCES": "<MYSQL_DATASOURCES>",
"MYSQL_DANGER_MODE": "<MYSQL_DANGER_MODE>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"mysql-server-guangyiding": {
"command": "npx",
"args": [
"-y",
"@nolimit35/mysql-mcp-server"
],
"env": {
"MYSQL_DATASOURCES": "<MYSQL_DATASOURCES>",
"MYSQL_DANGER_MODE": "<MYSQL_DANGER_MODE>"
}
}
}
}需要的环境变量
MYSQL_DATASOURCESMYSQL_DANGER_MODE
把占位值换成你自己的密钥;不要把密钥提交到代码仓库。