wenb1n-dev_mysql_mcp_server_pro
If you are the rightful owner of wenb1n-dev_mysql_mcp_server_pro and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include advanced database anomaly analysis and customization capabilities.
mcp_mysql_server_pro is a versatile tool designed to enhance MySQL database management by providing not only standard CRUD operations but also advanced features such as anomaly analysis and custom tool extensions. It supports both STDIO and SSE modes, allowing for flexible integration into various development environments. The server is equipped with capabilities to execute multiple SQL commands, analyze SQL execution plans, and convert Chinese field names to pinyin. Additionally, it offers robust database health status analysis and permission control with three distinct roles: readonly, writer, and admin. This makes it an ideal choice for developers looking to streamline database operations while maintaining a high level of security and efficiency. The tool is also designed to be easily extendable, allowing developers to add custom functionalities as needed.
Features
- Supports both STDIO and SSE modes for flexible integration.
- Advanced database anomaly analysis capabilities.
- Permission control with three roles: readonly, writer, and admin.
- Supports multiple SQL execution and SQL execution plan analysis.
- Easily extendable with custom tools.
Tools
execute_sql
SQL execution tool that can execute various commands based on permission configuration.
get_chinese_initials
Convert Chinese field names to pinyin initials.
get_db_health_running
Analyze MySQL health status including connection, transaction, and lock status.
get_table_desc
Search for table structures in the database based on table names.
get_table_index
Search for table indexes in the database based on table names.