MySQL MCP
Rank #19,484io.github.gistrec/mcp-mysql-client
MCP server for one MySQL database: schema, read-only queries and guarded writes.
What you can do with MySQL MCP
MySQL MCP is a Model Context Protocol (MCP) server published by gistrec. It ranks #19,484 of 171,126 active servers on MCP Toplist. MySQL MCP is listed across 2 registries — Official MCP and Glama, with 4 tracked versions. It was first listed on Aug 22, 2026 and most recently updated on Nov 4, 2026.
Not verifiedMCP Toplist has not yet written a checked profile for this server, so the paragraph above is assembled from registry data only. The repository README is the authority on what it does.
What MySQL MCP can and cannot do
Not verifiedMCP Toplist has not catalogued this server's tools or limitations. The repository README lists them.
What you need before using MySQL MCP
The registry listing declares required configuration before first use — typically an API key, token or connection string set via environment variables.
Declared by Glama, last synced Nov 7, 2026. Not independently verified by MCP Toplist.
- MYSQL_HOST · optional
- MYSQL_PORT · optional
- MYSQL_USER · required
- MYSQL_PASS · optional
- MYSQL_DB · required
- MYSQL_SSL · optional
- MYSQL_SSL_CA · optional
- ALLOW_INSERT_OPERATION · optional
- ALLOW_UPDATE_OPERATION · optional
- ALLOW_DELETE_OPERATION · optional
- MYSQL_MAX_ROWS · optional
- MYSQL_TIMEOUT_MS · optional
Connect MySQL MCP and confirm it works
claude mcp add mcp-mysql-client -e "MYSQL_HOST=<your MYSQL_HOST>" -e "MYSQL_PORT=<your MYSQL_PORT>" -e "MYSQL_USER=<your MYSQL_USER>" -e "MYSQL_PASS=<your MYSQL_PASS>" -e "MYSQL_DB=<your MYSQL_DB>" -e "MYSQL_SSL=<your MYSQL_SSL>" -e "MYSQL_SSL_CA=<your MYSQL_SSL_CA>" -e "ALLOW_INSERT_OPERATION=<your ALLOW_INSERT_OPERATION>" -e "ALLOW_UPDATE_OPERATION=<your ALLOW_UPDATE_OPERATION>" -e "ALLOW_DELETE_OPERATION=<your ALLOW_DELETE_OPERATION>" -e "MYSQL_MAX_ROWS=<your MYSQL_MAX_ROWS>" -e "MYSQL_TIMEOUT_MS=<your MYSQL_TIMEOUT_MS>" -- npx -y mcp-mysql-clientReplace each placeholder with your own value before saving.
[mcp_servers.mcp-mysql-client]
command = "npx"
args = ["-y", "mcp-mysql-client"]
[mcp_servers.mcp-mysql-client.env]
MYSQL_HOST = "<your MYSQL_HOST>"
MYSQL_PORT = "<your MYSQL_PORT>"
MYSQL_USER = "<your MYSQL_USER>"
MYSQL_PASS = "<your MYSQL_PASS>"
MYSQL_DB = "<your MYSQL_DB>"
MYSQL_SSL = "<your MYSQL_SSL>"
MYSQL_SSL_CA = "<your MYSQL_SSL_CA>"
ALLOW_INSERT_OPERATION = "<your ALLOW_INSERT_OPERATION>"
ALLOW_UPDATE_OPERATION = "<your ALLOW_UPDATE_OPERATION>"
ALLOW_DELETE_OPERATION = "<your ALLOW_DELETE_OPERATION>"
MYSQL_MAX_ROWS = "<your MYSQL_MAX_ROWS>"
MYSQL_TIMEOUT_MS = "<your MYSQL_TIMEOUT_MS>"Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.
{
"mcpServers": {
"mcp-mysql-client": {
"command": "npx",
"args": [
"-y",
"mcp-mysql-client"
],
"env": {
"MYSQL_HOST": "<your MYSQL_HOST>",
"MYSQL_PORT": "<your MYSQL_PORT>",
"MYSQL_USER": "<your MYSQL_USER>",
"MYSQL_PASS": "<your MYSQL_PASS>",
"MYSQL_DB": "<your MYSQL_DB>",
"MYSQL_SSL": "<your MYSQL_SSL>",
"MYSQL_SSL_CA": "<your MYSQL_SSL_CA>",
"ALLOW_INSERT_OPERATION": "<your ALLOW_INSERT_OPERATION>",
"ALLOW_UPDATE_OPERATION": "<your ALLOW_UPDATE_OPERATION>",
"ALLOW_DELETE_OPERATION": "<your ALLOW_DELETE_OPERATION>",
"MYSQL_MAX_ROWS": "<your MYSQL_MAX_ROWS>",
"MYSQL_TIMEOUT_MS": "<your MYSQL_TIMEOUT_MS>"
}
}
}
}Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.
{
"mcpServers": {
"mcp-mysql-client": {
"command": "npx",
"args": [
"-y",
"mcp-mysql-client"
],
"env": {
"MYSQL_HOST": "<your MYSQL_HOST>",
"MYSQL_PORT": "<your MYSQL_PORT>",
"MYSQL_USER": "<your MYSQL_USER>",
"MYSQL_PASS": "<your MYSQL_PASS>",
"MYSQL_DB": "<your MYSQL_DB>",
"MYSQL_SSL": "<your MYSQL_SSL>",
"MYSQL_SSL_CA": "<your MYSQL_SSL_CA>",
"ALLOW_INSERT_OPERATION": "<your ALLOW_INSERT_OPERATION>",
"ALLOW_UPDATE_OPERATION": "<your ALLOW_UPDATE_OPERATION>",
"ALLOW_DELETE_OPERATION": "<your ALLOW_DELETE_OPERATION>",
"MYSQL_MAX_ROWS": "<your MYSQL_MAX_ROWS>",
"MYSQL_TIMEOUT_MS": "<your MYSQL_TIMEOUT_MS>"
}
}
}
}Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.
{
"servers": {
"mcp-mysql-client": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-mysql-client"
],
"env": {
"MYSQL_HOST": "<your MYSQL_HOST>",
"MYSQL_PORT": "<your MYSQL_PORT>",
"MYSQL_USER": "<your MYSQL_USER>",
"MYSQL_PASS": "<your MYSQL_PASS>",
"MYSQL_DB": "<your MYSQL_DB>",
"MYSQL_SSL": "<your MYSQL_SSL>",
"MYSQL_SSL_CA": "<your MYSQL_SSL_CA>",
"ALLOW_INSERT_OPERATION": "<your ALLOW_INSERT_OPERATION>",
"ALLOW_UPDATE_OPERATION": "<your ALLOW_UPDATE_OPERATION>",
"ALLOW_DELETE_OPERATION": "<your ALLOW_DELETE_OPERATION>",
"MYSQL_MAX_ROWS": "<your MYSQL_MAX_ROWS>",
"MYSQL_TIMEOUT_MS": "<your MYSQL_TIMEOUT_MS>"
}
}
}
}Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.
{
"mcpServers": {
"mcp-mysql-client": {
"command": "npx",
"args": [
"-y",
"mcp-mysql-client"
],
"env": {
"MYSQL_HOST": "<your MYSQL_HOST>",
"MYSQL_PORT": "<your MYSQL_PORT>",
"MYSQL_USER": "<your MYSQL_USER>",
"MYSQL_PASS": "<your MYSQL_PASS>",
"MYSQL_DB": "<your MYSQL_DB>",
"MYSQL_SSL": "<your MYSQL_SSL>",
"MYSQL_SSL_CA": "<your MYSQL_SSL_CA>",
"ALLOW_INSERT_OPERATION": "<your ALLOW_INSERT_OPERATION>",
"ALLOW_UPDATE_OPERATION": "<your ALLOW_UPDATE_OPERATION>",
"ALLOW_DELETE_OPERATION": "<your ALLOW_DELETE_OPERATION>",
"MYSQL_MAX_ROWS": "<your MYSQL_MAX_ROWS>",
"MYSQL_TIMEOUT_MS": "<your MYSQL_TIMEOUT_MS>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.
{
"mcpServers": {
"mcp-mysql-client": {
"command": "npx",
"args": [
"-y",
"mcp-mysql-client"
],
"env": {
"MYSQL_HOST": "<your MYSQL_HOST>",
"MYSQL_PORT": "<your MYSQL_PORT>",
"MYSQL_USER": "<your MYSQL_USER>",
"MYSQL_PASS": "<your MYSQL_PASS>",
"MYSQL_DB": "<your MYSQL_DB>",
"MYSQL_SSL": "<your MYSQL_SSL>",
"MYSQL_SSL_CA": "<your MYSQL_SSL_CA>",
"ALLOW_INSERT_OPERATION": "<your ALLOW_INSERT_OPERATION>",
"ALLOW_UPDATE_OPERATION": "<your ALLOW_UPDATE_OPERATION>",
"ALLOW_DELETE_OPERATION": "<your ALLOW_DELETE_OPERATION>",
"MYSQL_MAX_ROWS": "<your MYSQL_MAX_ROWS>",
"MYSQL_TIMEOUT_MS": "<your MYSQL_TIMEOUT_MS>"
}
}
}
}Replace each placeholder with your own value before saving.
After adding the config, ask your client to list this server's tools. A tool list confirms the connection; an empty list or an error means the server did not start or needs credentials.
When to choose another server
No task-specific alternatives are catalogued for MySQL MCPyet; the list above is its publisher's other servers.
What changed, and when this was checked
- First listed
- Aug 22, 2026
- Latest version published
- Nov 4, 2026
- Version history
- 4 versions tracked (below)
- Requirements evidence
- Declared by Glama, last synced Nov 7, 2026. Not independently verified by MCP Toplist.
- Profile checked
- Not yet — purpose, capabilities and requirements above come from registry data only
- Ranking data as of
- Nov 7, 2026
- Official MCP ↗listed since Aug 23, 2026 · still listed
- Glama ↗listed since Aug 24, 2026 · still listed
Do you maintain MySQL MCP? to correct or enrich this profile.
Available versions (4)
| Version | Published |
|---|---|
| 1.1.1 | Nov 4, 2026 |
| 1.1.0 | Oct 31, 2026 |
| 1.0.1 | Oct 22, 2026 |
| 1.0.0 | Aug 23, 2026 |
Ranks ahead of 151,642 of 171,126 servers on MCP Toplist.
Show your rank
Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.
[](https://mcptoplist.com/server/io.github.gistrec%2Fmcp-mysql-client)<a href="https://mcptoplist.com/server/io.github.gistrec%2Fmcp-mysql-client"><img src="https://mcptoplist.com/badge/io.github.gistrec%2Fmcp-mysql-client.svg" alt="MCP Toplist: Top 25% of 171,126" /></a>Variants: append ?metric=score or ?metric=stars to the image URL.
Frequently asked questions
- Who maintains MySQL MCP?
- MySQL MCP is maintained by gistrec, which publishes 2 MCP servers (29 total versions) tracked on MCP Toplist.
- Is MySQL MCP listed on the Official MCP Registry?
- Yes — MySQL MCP is listed on the Official MCP Registry, alongside Glama.
- How many versions does MySQL MCP have?
- MCP Toplist tracks 4 versions of MySQL MCP, most recently published on Nov 4, 2026.
- Where can I find the source code for MySQL MCP?
- The source code for MySQL MCP is hosted at github.com/gistrec/mcp-mysql-client.
Do you run this server?
Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.