mysql_mcp_server_pro
54
mcp_mysql_server is a tool that extends MySQL database operations with enhanced functionalities, including anomaly analysis and custom tool integration. It offers robust features such as SQL execution, health monitoring, and permission controls, making it an invaluable resource for database management and analysis.
mcp_mysql_server
Introduction
- Provides CRUD operations and database anomaly analysis for MySQL.
- Supports STDIO and SSE modes, multiple SQL executions, and querying by table comments.
- Analyzes SQL execution plans, converts Chinese fields to pinyin, and evaluates database health and lock status.
- Role-based permission control for readonly, writer, and admin roles.
Tool List
- Various tools for SQL execution, health analysis, table structure queries, and more.
Usage Instructions
- Installation via pip and environment configuration.
- Instructions for running the server in different modes (SSE and STDIO).
Custom Tool Extensions
- Guidance on extending the server with custom tools by implementing specific methods.