mysql-mcp-server
MySQL Server implementation for Model Context Protocol (MCP) written in Go.
What can you do with mysql-mcp-server?
- Fully read-only (blocks all non-SELECT/SHOW/DESCRIBE/EXPLAIN)
- Multi-DSN Support: Connect to multiple MySQL or MariaDB instances, switch via tool
- MariaDB Support: Native compatibility with MariaDB 10.x, 11.x and 12.x
- Vector Search (MySQL 9.0+): Similarity search on vector columns
- MCP tools:
- listdatabases, listtables, describe_table
- run_query (safe and row-limited)
- ping, server_info
Features as listed in the project's README, checked 16 Nov 2026.
About mysql-mcp-server
A fast, read-only MySQL Server for the Model Context Protocol (MCP) written in Go. This project exposes safe MySQL introspection tools to Claude Desktop via MCP. Claude can explore databases, describe schemas, and execute controlled read-only SQL queries — ideal for secure development assistance, debugging, analytics, and schema documentation.
Opening text of the project's README, checked 16 Nov 2026.
Install
{
"mcpServers": {
"mysql": {
"command": "mysql-mcp-server",
"env": {
"MYSQL_DSN": "user:password@tcp(127.0.0.1:3306)/mydb?parseTime=true",
"MYSQL_MAX_ROWS": "200",
"MYSQL_MCP_EXTENDED": "1"
}
}
}
}Config as documented in its source, checked 16 Nov 2026. Placeholders such as API keys are the project's own: replace them with your values.
Requirements listed
- Docker and Docker Compose (for integration tests)
- MySQL client (optional, for manual database access)
Setup documented for
Tools (24)
| list_databases | |
| list_tables | |
| describe_table | |
| run_query | |
| server_info | |
| list_connections | |
| use_connection | |
| add_connection | |
| vector_search | |
| vector_info | |
| list_indexes | |
| show_create_table | |
| explain_query | |
| list_views | |
| list_triggers | |
| list_procedures | |
| list_functions | |
| list_partitions | |
| database_size | |
| table_size | |
| foreign_keys | |
| list_status | |
| list_variables | |
| ping |
Tool names from the README, checked 16 Nov 2026.
mysql-mcp-server compared with other MySQL servers
| Server | Licence | Tools | Last commit | Stars |
|---|---|---|---|---|
| mysql-mcp-server | Apache-2.0 | 24 | 13 Nov 2026 | 45 |
| mysql-mcp-server | MIT | 4 | 22 Sept 2026 | 75 |
Every value is a checked fact on that server's own page. This is a comparison of facts, not a ranking.
Verified facts
- Maintainer
- askdba
Source · checked 16 Nov 2026
- Licence
- Apache-2.0
Source · checked 16 Nov 2026
- Setup documented for
- Claude Code
- Claude Desktop
- Cursor
- ChatGPT
Source · checked 16 Nov 2026
- Repository
- github.com/askdba/mysql-mcp-server
Source · checked 16 Nov 2026
- Last commit
- 13 Nov 2026
Source · checked 16 Nov 2026
- GitHub stars
- 45
Source · checked 16 Nov 2026
- Open issues
- 7
Source · checked 16 Nov 2026
Each value links to where it was found and shows the date it was checked. How we verify
Frequently asked questions
What does mysql-mcp-server do?
MySQL Server implementation for Model Context Protocol (MCP) written in Go.
Which MCP clients does mysql-mcp-server document setup for?
Its README documents setup for Claude Code, Claude Desktop, Cursor, ChatGPT.
How do I install mysql-mcp-server?
Add the install config shown on this page to your MCP client's configuration. Check the README for client-specific steps.
What licence is mysql-mcp-server under?
Apache-2.0, as reported by the repository on 16 Nov 2026.
Is mysql-mcp-server still maintained?
The last commit was on 13 Nov 2026, and the repository had 7 open issues.
What tools does mysql-mcp-server expose?
24 tools: list_databases, list_tables, describe_table, run_query, server_info, list_connections, use_connection, add_connection, vector_search, vector_info, list_indexes, show_create_table, and more.
