PluginBench
MCP Server
Active
MIT

MySQL (read-only, switchable) MCP Server

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

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

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

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

0
TypeScript
MIT
View repository →
AIAIDataParser logo

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

0
JavaScript
MIT
View repository →

MCP server for Box admin-log analytics — external-sharing visibility, read-only

0
Python
MIT
View repository →
JQJ-Quants MCP logo

MCP server for retrieving Japanese stock market data via J-Quants API v2

2
Python
MIT
View repository →
AIAISOTools logo

AISOTools

Active

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

3
MIT
View repository →

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

1
JavaScript
MIT
View repository →