mysql_mcp_server_pro

mysql_mcp_server_pro

3.9
Certified
databases

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include database anomaly analysis and custom tool extensions.

execute_sql

SQL execution tool, which can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands according to permission configuration

get_chinese_initials

Convert Chinese field names to pinyin first letters

get_db_health_running

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

get_table_desc

Search the table structure in the database based on table name, supports multi-table query

get_table_index

Search table indexes in the database based on table names, support multi-table query

get_table_lock

Check whether row-level or table-level locks exist in the current MySQL server

get_table_name

Search table names in database based on table annotations and descriptions