mcp-server-mysql
A Model Context Protocol server that provides read-only access to MySQL database
The MySQL MCP Server lets your AI connect directly to a MySQL database: inspect schemas, run SELECTs, and analyse data — no exporting to CSV and pasting it into the chat.
The everyday uses are "what does this table look like and what indexes does it have?" and ad-hoc data exploration. You stop switching to a DB client just to confirm a column name while writing code.
Why use it
Good for: backend engineers and analysts who query often but don't want to open a client every time.
Before connecting: **use a read-only account for production**. This server supports read-only mode — turn it on. A wrong SQL statement against production isn't reversible.
Before you connect
Config example (to connect)
{
"mcpServers": {
"mcp_server_mysql": {
"command": "npx",
"args": ["-y", "@benborla29/mcp-server-mysql"],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASS": "your_password",
"MYSQL_DB": "your_database"
}
}
}
}Install / Connect
# No npm package — install from source.
# See the repo's README for the exact command:
# https://github.com/benborla/mcp-server-mysqlFollow the official README; env and args vary per server.
🛠️ Maintenance weight 30% · 61 pts
📊 Adoption weight 25% · 60 pts
✅ Usability weight 20% · 20 pts
❤️ Health & community weight 25% · 78 pts
Sources: GitHub API · updated 2026-08-19
90-day trend
⭐ stars +0%
Frequently Asked Questions
Can I lock it to read-only?
Yes. The server has a read-only setting, and you should also use a read-only database account — two layers.
How does it differ from the PostgreSQL server?
Different protocol and dialect, same purpose. Both are listed on this site; pick whichever matches your database.
Similar / alternative servers
How to choose among these
Database servers split into relational vs. vector; vector stores are all for RAG, differing by scale and hosting.
- Relational DB (business data, SQL)→Pick Supabase / Neon / MongoDB / ClickHouse — match your DB
- RAG with semantic memory→Pick a vector store: Pinecone (scaled) / Qdrant / Chroma (light) / Weaviate
capital.hove/read-only-local-mysql-mcp-server
MCP server for read-only MySQL database queries in Claude Desktop
postgres-mcp
Postgres MCP Pro provides configurable read/write access and performance analysi
capital.hove/read-only-local-postgres-mcp-server
MCP server for read-only PostgreSQL database queries in Claude Desktop
chroma-mcp
A Model Context Protocol (MCP) server implementation that provides database capa
One email a week, 5 minutes to see what happened in the MCP ecosystem
New servers, breakout trends, abandonment alerts — tracked automatically, curated by hand, sent to your inbox.
One email a week · unsubscribe anytime · no data selling