MySQL (read-only, switchable) MCP Server
io.github.shibbirweb/mcp-mysql-read-only
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.
MYSQL_HOSTHostname of the MySQL server. Defaults to 127.0.0.1
MYSQL_PORTPort of the MySQL server. Defaults to 3306
MYSQL_USERMySQL user. Prefer an account holding only SELECT grants
MYSQL_PASSWORDsecretPassword for MYSQL_USER. Empty when the account has none
MYSQL_DATABASEDatabase to open at startup. Can be changed later without restarting
MYSQL_PROFILESsecretJSON object of named connections to switch between, keyed by profile name
MYSQL_DEFAULT_PROFILEWhich MYSQL_PROFILES entry to start on
MYSQL_CONNECT_TIMEOUT_MSConnection timeout in milliseconds. Defaults to 10000
MYSQL_QUERY_TIMEOUT_MSServer-side query timeout in milliseconds. Defaults to 30000
{
"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.

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

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

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

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

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