Database · Developer Tools

mysql_mcp_server_pro logo

mysql_mcp_server_pro

wenb1n-dev/mysql_mcp_server_pro

mcp_mysql_server_pro is not just about MySQL CRUD operations, but also includes database anomaly analysis capabilities and makes it easy for developers to extend with custom tools.

Install

uvx --from mysql_mcp_server_pro mysql_mcp_server_pro --mode stdio

Client configuration

{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_ROLE": "<MYSQL_ROLE>"
      }
    }
  }
}

Environment variables

MYSQL_HOSTMYSQL_PORTMYSQL_USERMYSQL_PASSWORDMYSQL_DATABASEMYSQL_ROLE
GitHub stars
29
Category
Database, Developer Tools
Updated
Oct 6, 2026

Tools (10)

  • execute_sql

    SQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands…

  • get_chinese_initials

    Convert Chinese field names to pinyin initials

  • get_db_health_running

    Analyze MySQL health status (connection status, transaction status, running status, lock status detection)

  • get_table_desc

    Search for table structures in the database based on table names, supporting multi-table queries

  • get_table_index

    Search for table indexes in the database based on table names, supporting multi-table queries

  • get_table_lock

    Check if there are row-level locks or table-level locks in the current MySQL server

  • get_table_name

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

  • get_db_health_index_usage

    Get the index usage of the currently connected mysql database, including redundant index situations, poorly performing index situations, and the top 5 unused…

  • optimize_sql

    Professional SQL performance optimization tool, providing expert optimization suggestions based on MySQL execution plans, table structure information, table…

  • use_prompt_queryTableData

    Use built-in prompts to let the model construct a chain call of tools in mcp (not a commonly used fixed tool, you need to modify the code to enable it, see…

Details on this page are taken from the project's README. Open README

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database