{"slug":"wenb1n-dev/mysql_mcp_server_pro","name":"MySQL Server Pro","description":"A MySQL server with CRUD operations, database anomaly analysis, and support for SSE and STDIO.","category":"database","tags":[],"official":false,"stars":244,"transport":"stdio","install":[{"cmd":"pip install mysql_mcp_server_pro","imports":[]}],"tools":[{"name":"execute_sql","description":"SQL execution tool that can execute SELECT, SHOW, DESCRIBE, EXPLAIN, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, TRUNCATE commands based on permission configuration"},{"name":"get_chinese_initials","description":"Convert Chinese field names to pinyin initials"},{"name":"get_db_health_running","description":"Analyze MySQL health status (connection status, transaction status, running status, lock status detection)"},{"name":"get_table_desc","description":"Search for table structures in the database based on table names, supporting multi-table queries"},{"name":"get_table_index","description":"Search for table indexes in the database based on table names, supporting multi-table queries"},{"name":"get_table_lock","description":"Check if there are row-level locks or table-level locks in the current MySQL server"},{"name":"get_table_name","description":"Search for table names in the database based on table comments and descriptions"},{"name":"get_db_health_index_usage","description":"Get the index usage of the currently connected mysql database, including redundant index situations, poorly performing index situations, and the top 5 unused index situations with query times greater than 30 seconds"},{"name":"optimize_sql","description":"Professional SQL performance optimization tool, providing expert optimization suggestions based on MySQL execution plans, table structure information, table data volume, and table indexes"},{"name":"use_prompt_queryTableData","description":"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)"}],"env_vars":["MYSQL_HOST","MYSQL_PORT"],"auth_type":"none","github":"https://github.com/wenb1n-dev/mysql_mcp_server_pro","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}