mysql_mcp_server_pro

mysql_mcp_server_pro

54
databases

mcp_mysql_server is a tool that extends MySQL database operations with enhanced functionalities, including anomaly analysis and custom tool integration. It offers robust features such as SQL execution, health monitoring, and permission controls, making it an invaluable resource for database management and analysis.

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