MySQL MCP Server Pro

What it does

Connects AI models to MySQL databases, enabling not just standard data manipulation but deep database diagnostics and performance tuning.

Tools

• execute_sql: Run SELECT, INSERT, UPDATE, DELETE, and administrative commands based on role permissions.
• optimize_sql: Expert SQL performance optimization based on execution plans and table structures.
• get_db_health_running: Analyze MySQL health, including connection, transaction, and lock status.
• get_table_name: Find tables based on comments and descriptions.
• get_table_desc: Query table structures and field definitions.
• get_table_lock: Detect row-level and table-level locks.
• get_db_health_index_usage: Analyze redundant or poorly performing indexes.

Installation

Add the following to your claude_desktop_config.json:

{
  "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-user",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_DATABASE": "your-db",
        "MYSQL_ROLE": "readonly"
      }
    }
  }
}

Supported hosts

• Claude Desktop
• Cursor
• Cline