Install MySQL MCP for Claude Desktop
Claude Desktop reads mcpServers from claude_desktop_config.json. Restart the app after saving.
- Open ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows, or ~/.config/Claude/claude_desktop_config.json on Linux.
- Paste the JSON config below.
- Replace placeholder secrets, then restart the client if it does not reload on its own.
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"gistrec-mcp-mysql-client": {
"command": "npx",
"args": [
"-y",
"mcp-mysql-client@1.0.0"
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "",
"MYSQL_PASS": "YOUR_MYSQL_PASS",
"MYSQL_DB": "",
"MYSQL_SSL": "false",
"MYSQL_SSL_CA": "",
"ALLOW_INSERT_OPERATION": "false",
"ALLOW_UPDATE_OPERATION": "false",
"ALLOW_DELETE_OPERATION": "false",
"MYSQL_MAX_ROWS": "1000",
"MYSQL_TIMEOUT_MS": "30000"
}
}
}
}