MySQL (read-only, switchable) MCP Server

io.github.shibbirweb/mcp-mysql-read-only

Repository Registry

What is the MySQL (read-only, switchable) MCP server?

Read-only MySQL access, with the database and server switchable mid-conversation.

How to install MySQL (read-only, switchable)

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

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
secret
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
secret
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

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mcp-mysql-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "@shibbirweb/mcp-mysql-read-only"
      ],
      "env": {
        "MYSQL_HOST": "<YOUR_MYSQL_HOST>",
        "MYSQL_PORT": "<YOUR_MYSQL_PORT>",
        "MYSQL_USER": "<YOUR_MYSQL_USER>",
        "MYSQL_PASSWORD": "<YOUR_MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<YOUR_MYSQL_DATABASE>",
        "MYSQL_PROFILES": "<YOUR_MYSQL_PROFILES>",
        "MYSQL_DEFAULT_PROFILE": "<YOUR_MYSQL_DEFAULT_PROFILE>",
        "MYSQL_CONNECT_TIMEOUT_MS": "<YOUR_MYSQL_CONNECT_TIMEOUT_MS>",
        "MYSQL_QUERY_TIMEOUT_MS": "<YOUR_MYSQL_QUERY_TIMEOUT_MS>"
      }
    }
  }
}

Related MCP servers

Databases (read-only, switchable)

Active

Read-only SQL, MongoDB, Redis and Elasticsearch access, switchable mid-conversation.

TypeScript

MIT

View repository →

AIDataParser

Active

Extract schema-guaranteed JSON from PDFs, images and messy text. 50 free credits, no card.

JavaScript

MIT

View repository →

AISOTools

Active

Search, compare, and find alternatives across a catalog of 3,000+ AI tools.

MIT

View repository →

API Status Check

Active

Live status probes plus published uptime and incident history for 280+ APIs and cloud services.

JavaScript

MIT

View repository →

MyMCPTools

Active

Find MCP servers and check whether they actually respond, via live handshake probes.

JavaScript

MIT

View repository →

io.github.shichuanqiong/agoradm

Active

DM / IM + public arena for AI agents (A2A 1.0) — hosted endpoint or local package.

Python

Apache-2.0

View repository →