A
licenseC
qualityC
maintenanceEnables executing SQL queries, managing databases, and switching between multiple project environments via MCP, without requiring a local MySQL client.
14
317 npm
1
MIT
mysql-mcp-zag
by Michaelzag
Execute SQL queries and browse database tables and structure via MCP tools and resources.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mysql-mcp-zaglist all tables in the database"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MySQL MCP Server
A modern MySQL Model Context Protocol (MCP) server built with FastMCP.
Features
Execute SQL queries via MCP tools
Browse database tables and structure via MCP resources
SSL certificate support
Connection pooling and error handling
Related MCP server: database-remote-mcp
Configuration
Command Line Arguments
Required Arguments
Argument | Description | Default |
| MySQL username | (required) |
| MySQL password | (required) |
| MySQL database name | (required) |
Database Connection (Optional)
Argument | Description | Default |
| MySQL server host |
|
| MySQL server port |
|
SSL Configuration (Optional)
Argument | Description | Default |
| Path to SSL CA certificate file | (none - SSL auto-negotiated) |
| Path to SSL client certificate file | (none) |
| Path to SSL client private key file | (none) |
| Disable SSL connection entirely |
|
Note: If --ssl-cert is provided, --ssl-key must also be provided, and vice versa.
Advanced Options (Optional)
Argument | Description | Default |
| Character set for the connection |
|
| Collation for the connection |
|
| MySQL SQL mode |
|
Usage
Simple Configuration
{
"mcpServers": {
"mysql": {
"command": "uvx",
"args": [
"mysql-mcp-zag",
"--host", "localhost",
"--port", "3306",
"--user", "your_user",
"--password", "your_password",
"--database", "your_database"
]
}
}
}Complex Configuration
{
"mcpServers": {
"mysql": {
"command": "uvx",
"args": [
"mysql-mcp-zag",
"--host", "your-remote-host.com",
"--port", "25060",
"--user", "your_user",
"--password", "your_password",
"--database", "your_database",
"--ssl-ca", "/path/to/ca-certificate.pem"
]
}
}
}Available Tools
execute_sql: Execute SQL queries
Available Resources
mysql://tables: List all tablesmysql://tables/{table}: Describe table structure
Requirements
Python 3.13+
MySQL server
uvx (for installation and usage)
Created by Michael Zag, Michael@MichaelZag.com
This server cannot be deployed
Maintenance
ActivityInactive
ResponsivenessNo issues
Related MCP Connectors
Governed data discovery, exact queries, decisions, simulations, and runtime utilities over MCP.
Paid remote MCP for governed database query review, SQL simulation, approvals, and audits.
Query, join, profile, clean and convert CSV/JSON/Parquet with server-side DuckDB over MCP.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Related MCP Servers
- FlicenseNot gradedqualityCmaintenanceEnables remote database access (RDBMS and MongoDB) through MCP tools, supporting read/write queries, schema management, and more.-
- FlicenseAqualityBmaintenanceEnables interaction with MariaDB/MySQL databases via MCP, supporting read-only mode, SQL execution, and schema inspection.6-
- AlicenseNot gradedqualityCmaintenanceEnables inspecting database schemas and executing read-only SQL queries on a PostgreSQL database via MCP tools.7 npmMIT