mcp-server-mysql-py 0.1.0

A Python MCP server for MySQL database queries

mcp-server-mysql-py

A Python MCP server for MySQL database queries.

Installation

pip install mcp-server-mysql-py

Configuration

Set environment variables:

• MYSQL_HOST - Database host (default: 127.0.0.1)
• MYSQL_PORT - Database port (default: 3306)
• MYSQL_USER - Database user (default: root)
• MYSQL_PASS - Database password
• MYSQL_DB - Database name

Usage

MCP Client Configuration

{
  "mcpServers": {
    "mysql": {
      "command": "mcp-server-mysql-py",
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "password",
        "MYSQL_DB": "mydb"
      }
    }
  }
}

Tools

• mysql_query - Execute SQL queries
• mysql_tables - List all tables
• mysql_describe - Show table columns