mysql_mcp_server_pro

Overview

The mysql_mcp_server_pro is a robust MCP server that extends beyond basic CRUD operations to provide comprehensive database management features. It includes specialized tools for SQL execution, Chinese field name conversion, health status analysis, table lock detection, and performance optimization. The server supports multiple MCP transfer modes (STDIO, SSE, Streamable Http) and implements OAuth2.0 for secure access with role-based permissions (readonly, writer, admin). It also offers built-in prompt templates for enhanced MySQL interaction.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• execute_sql

  SQL execution tool that can execute various SQL commands based on permission configuration

  Try:Execute SELECT * FROM usersTry:Create a new table called productsTry:Show all tables in the database
• get_chinese_initials

  Convert Chinese field names to pinyin initials

  Try:Convert '客户姓名' to pinyin initialsTry:Get pinyin for '部门编号'
• get_db_health_running

  Analyze MySQL health status including connection, transaction, and lock status

  Try:Check MySQL health statusTry:Show current transaction statusTry:Detect any lock issues
• get_table_desc

  Search for table structures in the database based on table names

  Try:Show structure of users tableTry:Describe columns in products tableTry:Get schema for orders and customers tables
• get_table_index

  Search for table indexes in the database based on table names

  Try:Show indexes on users tableTry:List all indexes in products tableTry:Get index information for orders table
• get_table_lock

  Check for row-level or table-level locks in the MySQL server

  Try:Check for table locksTry:Show current lock statusTry:Detect any row locks
• get_table_name

  Search for table names in the database based on table comments and descriptions

  Try:Find tables with 'customer' in commentsTry:Search for tables related to 'orders'Try:List tables with 'product' description
• get_db_health_index_usage

  Get index usage statistics including redundant and poorly performing indexes

  Try:Show index usage statisticsTry:List unused indexesTry:Check for redundant indexes
• optimize_sql

  Provide SQL optimization suggestions based on execution plans and table structure

  Try:Optimize this query: SELECT * FROM users WHERE name = 'John'Try:Review execution plan for slow queryTry:Suggest improvements for SELECT * FROM large_table
• use_prompt_queryTableData

  Use built-in prompts to construct tool chains for querying table data

  Try:Use prompt template to get customer dataTry:Query table data using built-in promptTry:Get product information using template

Comparable tools

Installation

pip install mysql_mcp_server_pro

MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=your_username
MYSQL_PASSWORD=your_password
MYSQL_DATABASE=your_database
MYSQL_ROLE=readonly # or writer, admin

# SSE mode
mysql_mcp_server_pro --mode sse --envfile /path/to/.env

# Streamable Http mode (default)
mysql_mcp_server_pro --envfile /path/to/.env

# With OAuth authentication
mysql_mcp_server_pro --oauth true

{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "MYSQL_HOST": "your_host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database",
        "MYSQL_ROLE": "admin"
      }
    }
  }
}

FAQ

What authentication methods does this MCP server support?

The server supports both basic authentication with environment variables and OAuth2.0 authentication with a token-based system.

How can I extend the server with custom tools?

You can add a new tool class in the handles package, inherit from BaseHandler, and implement get_tool_description and run_tool methods, then import it in __init__.py.

Compare mysql_mcp_server_pro with