MySQL MCP
Rank #34,299io.github.gistrec/mcp-mysql-client
MCP server for one MySQL database: schema, read-only queries and guarded writes.
MySQL MCP is a Model Context Protocol (MCP) server published by gistrec. It ranks #34,299 of 132,405 servers tracked on MCP Toplist. MySQL MCP is listed across 2 registries — Official MCP and Glama, with 1 tracked version. It was first listed on Aug 22, 2026 and most recently updated on Aug 23, 2026.
Ranks ahead of 98,106 of 132,405 servers on MCP Toplist.
Use MySQL MCP
Requires user-supplied configuration before first use — typically an API key, token or connection string set via environment variables.
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.
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 50% of 132,405" /></a>Variants: append ?metric=score or ?metric=stars to the image URL.
Listed on 2 registries
gistrec
Other servers by gistrec
View all gistrec servers →Available versions (1)
| Version | Published |
|---|---|
| 1.0.0 | Aug 23, 2026 |
Frequently asked questions
- Who maintains MySQL MCP?
- MySQL MCP is maintained by gistrec, which publishes 2 MCP servers (11 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 1 version of MySQL MCP, most recently published on Aug 23, 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.