MySQL (read-only, switchable) for Claude Desktop
io.github.shibbirweb/mcp-mysql-read-only
Read-only MySQL access, with the database and server switchable mid-conversation.
client:Claude Desktop
transport:stdio
runtime:npm
Install MySQL (read-only, switchable) in Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.json · windows: %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"mcp-mysql-read-only": {
"command": "npx",
"args": [
"-y",
"@shibbirweb/mcp-mysql-read-only"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_PORT": "<MYSQL_PORT>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>",
"MYSQL_PROFILES": "<MYSQL_PROFILES>",
"MYSQL_DEFAULT_PROFILE": "<MYSQL_DEFAULT_PROFILE>",
"MYSQL_CONNECT_TIMEOUT_MS": "<MYSQL_CONNECT_TIMEOUT_MS>",
"MYSQL_QUERY_TIMEOUT_MS": "<MYSQL_QUERY_TIMEOUT_MS>"
}
}
}
}
Settings → Developer → Edit Config opens this file. Restart the app after saving. Claude Desktop docs