Skip to content
Claude Desktop

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

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "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

MySQL (read-only, switchable) in other clients