MySQL MCP Server
A Python MCP server for listing, reading and querying MySQL tables through a controlled interface.
Sources and review
Checked against public documentation on . Suitability guidance is our editorial judgment; this is not a performance benchmark or an endorsement.
Querying MySQL from an MCP client in a Python environment.
About MySQL MCP Server
This community MySQL MCP server lists tables as resources, reads table contents and executes SQL with error handling. It supports a multi-database mode, SSH tunnelling and both stdio and streamable HTTP transports, with the HTTP mode suggested for remote or self-hosted deployments.
MySQL MCP Server is listed in this index written primarily in Python, with 1.4k stars on GitHub. Its latest recorded repository push was in October 2026; that is not an ASE editorial review date.
Before connecting: access and data
This record's specific permissions have not been reviewed by ASE. Read the publisher's documentation before copying setup or connecting.
- List the accounts, files and services the enabled tools can read, change or execute. Check your actual credentials and discovered tools.
- Use narrowly scoped credentials and read-only mode where supported. Review proposed writes before approving them; a generated configuration does not apply these limits for you.
- Local launch is not local-only data processing. External services receive requests, and your client may pass tool results to its model provider. Check both destinations before sharing private data.
- Keep keys and browser session files out of shared config, repositories and screenshots. Know how to disconnect the server and separately revoke its credentials or account sessions.
Add MySQL MCP Server to your MCP client
Generated from the launch command in the project's README. Your client starts the server on demand. Replace <user>, <password> and <database> with your own values first.
Claude Code
claude mcp add mysql-mcp-server -e MYSQL_HOST=localhost -e 'MYSQL_USER=<user>' -e 'MYSQL_PASSWORD=<password>' -e 'MYSQL_DATABASE=<database>' -- uvx mysql_mcp_serverCursor
{
"mcpServers": {
"mysql-mcp-server": {
"command": "uvx",
"args": ["mysql_mcp_server"],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_USER": "<user>",
"MYSQL_PASSWORD": "<password>",
"MYSQL_DATABASE": "<database>"
}
}
}
}VS Code
{
"servers": {
"mysql-mcp-server": {
"type": "stdio",
"command": "uvx",
"args": ["mysql_mcp_server"],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_USER": "<user>",
"MYSQL_PASSWORD": "<password>",
"MYSQL_DATABASE": "<database>"
}
}
}
}Claude Desktop
{
"mcpServers": {
"mysql-mcp-server": {
"command": "uvx",
"args": ["mysql_mcp_server"],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_USER": "<user>",
"MYSQL_PASSWORD": "<password>",
"MYSQL_DATABASE": "<database>"
}
}
}
}Codex
[mcp_servers.mysql-mcp-server]
command = "uvx"
args = ["mysql_mcp_server"]
env = { MYSQL_HOST = "localhost", MYSQL_USER = "<user>", MYSQL_PASSWORD = "<password>", MYSQL_DATABASE = "<database>" }