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.
mcp_mysql_server_pro is a robust MySQL server tool designed to facilitate not only standard CRUD operations but also advanced database anomaly analysis. It supports both STDIO and SSE modes, allowing for flexible integration into various development environments. The server can execute multiple SQL commands separated by semicolons and provides features such as querying database table names and fields based on comments, SQL execution plan analysis, and table lock analysis. Additionally, it offers database health status analysis and permission control with three distinct roles: readonly, writer, and admin. This tool is particularly useful for developers looking to extend its capabilities with custom tools, making it a versatile choice for managing MySQL databases. The server also supports Chinese field to pinyin conversion and prompt template invocation, enhancing its usability in diverse scenarios.
Features
- Supports both STDIO and SSE modes for flexible integration.
- Allows multiple SQL execution with commands separated by semicolons.
- Provides database health status analysis and table lock analysis.
- Offers permission control with roles: readonly, writer, and admin.
- Supports Chinese field to pinyin conversion and SQL execution plan analysis.
Tools
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
