MySQL (read-only, switchable)
CommunityMCP server by shibbirweb · updated · ★ 0 · 31 downloads a week
Read-only MySQL access, with the database and server switchable mid-conversation. MySQL (read-only, switchable) is a community project by shibbirweb, not verified by a company domain.
Last commit 14 days ago
MIT: permissive, fine for commercial use
Clear description, published package or server URL, original repository
Not checked yet. What we check
What you need
| Setting | Needed | What it is |
|---|---|---|
MYSQL_Environment variable | Optional | Hostname of the MySQL server. Defaults to 127.0.0.1 |
MYSQL_Environment variable | Optional | Port of the MySQL server. Defaults to 3306 |
MYSQL_Environment variable | Optional | MySQL user. Prefer an account holding only SELECT grants |
MYSQL_Environment variable, secret | Optional | Password for MYSQL_USER. Empty when the account has none |
MYSQL_Environment variable | Optional | Database to open at startup. Can be changed later without restarting |
MYSQL_Environment variable, secret | Optional | JSON object of named connections to switch between, keyed by profile name |
MYSQL_Environment variable | Optional | Which MYSQL_PROFILES entry to start on |
MYSQL_Environment variable | Optional | Connection timeout in milliseconds. Defaults to 10000 |
MYSQL_Environment variable | Optional | Server-side query timeout in milliseconds. Defaults to 30000 |
From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.
Install MySQL (read-only, switchable)
Built from the published package, never by AIclaude mcp add mysql-read-only-switchable -- npx -y @shibbirweb/mcp-mysql-read-onlyRun in your terminal. Add --scope user to use it in every project.
Step-by-step: install MySQL (read-only, switchable) in Claude Code
{
"mcpServers": {
"mysql-read-only-switchable": {
"command": "npx",
"args": [
"-y",
"@shibbirweb/mcp-mysql-read-only"
]
}
}
}Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.
Step-by-step: install MySQL (read-only, switchable) in Claude Desktop
{
"mcpServers": {
"mysql-read-only-switchable": {
"command": "npx",
"args": [
"-y",
"@shibbirweb/mcp-mysql-read-only"
]
}
}
}Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).
Step-by-step: install MySQL (read-only, switchable) in Cursor
{
"servers": {
"mysql-read-only-switchable": {
"command": "npx",
"args": [
"-y",
"@shibbirweb/mcp-mysql-read-only"
]
}
}
}Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".
Step-by-step: install MySQL (read-only, switchable) in VS Code
codex mcp add mysql-read-only-switchable -- npx -y @shibbirweb/mcp-mysql-read-onlyStep-by-step: install MySQL (read-only, switchable) in Codex
{
"mcpServers": {
"mysql-read-only-switchable": {
"command": "npx",
"args": [
"-y",
"@shibbirweb/mcp-mysql-read-only"
]
}
}
}Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).
Step-by-step: install MySQL (read-only, switchable) in Antigravity CLI
gemini mcp add mysql-read-only-switchable npx -y @shibbirweb/mcp-mysql-read-onlyGemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.
Step-by-step: install MySQL (read-only, switchable) in Gemini CLI
MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the mysql-read-only-switchable block.
Weekly newsletter
Like MySQL (read-only, switchable)? Get the best new MCP servers every week
The best new tools, security warnings before you install something risky, and one practical tip. Free, three minute read.
Alternatives to MySQL (read-only, switchable)
All alternatives →MCP server for interacting with the Supabase platform
Built-in MCP server for ArcadeDB multi-model database (graph, document, vector, time-series)
MCP Toolbox for Databases enables your agent to connect to your database.
MCP Toolbox for Databases enables your agent to connect to your database.
Real-time Kubernetes network traffic visibility and API analysis for HTTP, gRPC, Redis, Kafka, DNS.
Self-learning vector database for Node.js — hybrid search, Graph RAG, FlashAttention-3, HNSW, 50+ attention mechanisms
MySQL (read-only, switchable): common questions
How do I install MySQL (read-only, switchable)?
In Claude Code run claude mcp add mysql-read-only-switchable -- npx -y @shibbirweb/mcp-mysql-read-only. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.
Is MySQL (read-only, switchable) the official server?
MySQL (read-only, switchable) is a community project by shibbirweb, not verified by a company domain.
Is MySQL (read-only, switchable) free?
The code is published under the MIT licence. The service it connects to may have its own pricing.
Is MySQL (read-only, switchable) safe to use?
It scores 64 of 100. Grades: maintenance A, licence A, quality C. The security check has not run for it yet. Review the code before you install. How grades work.
What are alternatives to MySQL (read-only, switchable)?
Similar MCP servers: Supabase, ArcadeDB MCP Server, MCP Toolbox for Databases, MCP Toolbox for Databases.
Does MySQL (read-only, switchable) work with ChatGPT?
Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.
