Install MySQL (read-only, switchable) 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": {
    "shibbirweb-mcp-mysql-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "@shibbirweb/mcp-mysql-read-only@1.1.6"
      ],
      "env": {
        "MYSQL_HOST": "",
        "MYSQL_PORT": "",
        "MYSQL_USER": "",
        "MYSQL_PASSWORD": "YOUR_MYSQL_PASSWORD",
        "MYSQL_DATABASE": "",
        "MYSQL_PROFILES": "YOUR_MYSQL_PROFILES",
        "MYSQL_DEFAULT_PROFILE": "",
        "MYSQL_CONNECT_TIMEOUT_MS": "",
        "MYSQL_QUERY_TIMEOUT_MS": ""
      }
    }
  }
}

Official Claude Desktop docs

Install MySQL (read-only, switchable) for Claude Desktop | MCPpedia