MySQL (read-only, switchable) MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add mcp-mysql-read-only -- npx -y @shibbirweb/mcp-mysql-read-only

{
  "mcpServers": {
    "mcp-mysql-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "@shibbirweb/mcp-mysql-read-only"
      ]
    }
  }
}

[mcp_servers.mcp-mysql-read-only]
command = "npx"
args = ["-y", "@shibbirweb/mcp-mysql-read-only"]

{
  "mcpServers": {
    "mcp-mysql-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "@shibbirweb/mcp-mysql-read-only"
      ]
    }
  }
}

{
  "servers": {
    "mcp-mysql-read-only": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@shibbirweb/mcp-mysql-read-only"
      ]
    }
  }
}

Optional settings from the registry entry, left out of the block above: MYSQL_HOST (Hostname of the MySQL server. Defaults to 127.0.0.1), MYSQL_PORT (Port of the MySQL server. Defaults to 3306), MYSQL_USER (MySQL user. Prefer an account holding only SELECT grants), MYSQL_PASSWORD (Password for MYSQL_USER. Empty when the account has none), MYSQL_DATABASE (Database to open at startup. Can be changed later without restarting), MYSQL_PROFILES (JSON object of named connections to switch between, keyed by profile name), MYSQL_DEFAULT_PROFILE (Which MYSQL_PROFILES entry to start on), MYSQL_CONNECT_TIMEOUT_MS (Connection timeout in milliseconds. Defaults to 10000), MYSQL_QUERY_TIMEOUT_MS (Server-side query timeout in milliseconds. Defaults to 30000).