Lets models query and operate on MySQL databases through MCP.
接入配置
选择客户端，复制配置，再按项目文档补齐环境变量。
claude mcp add mysql-server-malove86 --env MYSQL_HOST='<MYSQL_HOST>' --env MYSQL_USER='<MYSQL_USER>' --env MYSQL_PASSWORD='<MYSQL_PASSWORD>' --env MYSQL_DATABASE='<MYSQL_DATABASE>' -- npx -y @malove86/mcp-mysql-server~/.codex/config.toml
[mcp_servers.mysql-server-malove86]
command = "npx"
args = ["-y", "@malove86/mcp-mysql-server"]
env = { MYSQL_HOST = "<MYSQL_HOST>", MYSQL_USER = "<MYSQL_USER>", MYSQL_PASSWORD = "<MYSQL_PASSWORD>", MYSQL_DATABASE = "<MYSQL_DATABASE>" }
# codex mcp add mysql-server-malove86 --env MYSQL_HOST='<MYSQL_HOST>' --env MYSQL_USER='<MYSQL_USER>' --env MYSQL_PASSWORD='<MYSQL_PASSWORD>' --env MYSQL_DATABASE='<MYSQL_DATABASE>' -- npx -y @malove86/mcp-mysql-server~/.cursor/mcp.json
{
"mcpServers": {
"mysql-server-malove86": {
"command": "npx",
"args": [
"-y",
"@malove86/mcp-mysql-server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"mysql-server-malove86": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@malove86/mcp-mysql-server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"mysql-server-malove86": {
"command": "npx",
"args": [
"-y",
"@malove86/mcp-mysql-server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"mysql-server-malove86": {
"command": "npx",
"args": [
"-y",
"@malove86/mcp-mysql-server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"mysql-server-malove86": {
"command": "npx",
"args": [
"-y",
"@malove86/mcp-mysql-server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>"
}
}
}
}需要的环境变量
MYSQL_HOSTMYSQL_USERMYSQL_PASSWORDMYSQL_DATABASE
把占位值换成你自己的密钥；不要把密钥提交到代码仓库。