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

Database Connection (Optional)

SSL Configuration (Optional)

Note: If --ssl-cert is provided, --ssl-key must also be provided, and vice versa.

Advanced Options (Optional)

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 tables

• mysql://tables/{table}: Describe table structure

Requirements

• Python 3.13+

• MySQL server

• uvx (for installation and usage)

Created by Michael Zag, Michael@MichaelZag.com