mysql_mcp_server_pro MCP server

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

What mysql_mcp_server_pro does

Summarised from the project README; check the repository for the latest details.

Tools exposed (10)

• execute_sql – SQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUN
• get_chinese_initials – Convert Chinese field names to pinyin initials
• get_db_health_running – Analyze MySQL health status (connection status, transaction status, running status, lock status detection)
• get_table_desc – Search for table structures in the database based on table names, supporting multi-table queries
• get_table_index – Search for table indexes in the database based on table names, supporting multi-table queries
• get_table_lock – Check if there are row-level locks or table-level locks in the current MySQL server
• get_table_name – Search for table names in the database based on table comments and descriptions
• get_db_health_index_usage – Get the index usage of the currently connected mysql database, including redundant index situations, poorly performing index situations, and
• optimize_sql – Professional SQL performance optimization tool, providing expert optimization suggestions based on MySQL execution plans, table structure in
• use_prompt_queryTableData – 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

How to install mysql_mcp_server_pro

Featured in: Best MCP servers for MySQL

Listed on Socketlist – add this badge to your README:

Badge markdown[](https://socketlist.pages.dev/s/wenb1n-dev-mysql-mcp-server-pro/)

Maintain this project? Get it featured for free during launch →

Compare with codebase-memory-mcp →

Related Databases MCP servers