mysql-mcp-zag 1.0.0

A modern MySQL Model Context Protocol (MCP) server built with FastMCP

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
• Full type safety with Python 3.13+

Installation

uv sync

Configuration

Set environment variables:

export MYSQL_HOST=localhost
export MYSQL_PORT=3306
export MYSQL_USER=your_user
export MYSQL_PASSWORD=your_password
export MYSQL_DATABASE=your_database

# Optional
export MYSQL_CERT=/path/to/cert.crt  # Supports .crt, .pem, and other SSL certificate formats
export MYSQL_CHARSET=utf8mb4

Usage

As MCP Server

Configure in your MCP client (e.g., Claude Desktop):

{
  "mcpServers": {
    "mysql": {
      "command": "uv",
      "args": ["--directory", "/path/to/mysql-mcp", "run", "mysql_mcp_server"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "user",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "database"
      }
    }
  }
}

Direct Usage

uv run mysql_mcp_server

Available Tools

• execute_sql: Execute SQL queries

Available Resources

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

Development

# Run tests
uv run pytest

# Lint and format
uv run ruff check --fix src tests
uv run black src tests
uv run mypy src

# Run server locally
uv run mysql_mcp_server

Requirements

• Python 3.13+
• MySQL server
• UV package manager

---

Created by Michael Zag, [e-mail]