About Mysql MCP Zag
Mysql MCP Zag is an MCP server published by Michaelzag in the Data category: a modern MySQL Model Context Protocol (MCP) server built with FastMCP.
Six months or more without a commit doesn't mean the server is broken, but check the open issues before depending on it in production.
Install
git clone https://github.com/Michaelzag/mysql-mcp-zagThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Tools (1)
execute_sqlExecute SQL queries
Parameters not published.
Ask AI
Ask AI about Mysql MCP Zag
Powered by Claude · Grounded in docs
Security checks
- ✓README presentThe repository ships documentation.
- !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.
4 checks have not been run yet.
Releases
README
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
Configuration
Command Line Arguments
Required Arguments
| Argument | Description | Default |
|---|---|---|
--user |
MySQL username | (required) |
--password |
MySQL password | (required) |
--database |
MySQL database name | (required) |
Database Connection (Optional)
| Argument | Description | Default |
|---|---|---|
--host |
MySQL server host | localhost |
--port |
MySQL server port | 3306 |
SSL Configuration (Optional)
| Argument | Description | Default |
|---|---|---|
--ssl-ca |
Path to SSL CA certificate file | (none - SSL auto-negotiated) |
--ssl-cert |
Path to SSL client certificate file | (none) |
--ssl-key |
Path to SSL client private key file | (none) |
--ssl-disabled |
Disable SSL connection entirely | false |
Note: If --ssl-cert is provided, --ssl-key must also be provided, and vice versa.
Advanced Options (Optional)
| Argument | Description | Default |
|---|---|---|
--charset |
Character set for the connection | utf8mb4 |
--collation |
Collation for the connection | utf8mb4_unicode_ci |
--sql-mode |
MySQL SQL mode | TRADITIONAL |
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
README copy captured when this server was indexed; it may lag the repository. The original is authoritative.