mysql_mcp_server_pro
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