MySQL
Manages MySQL database operations, health monitoring, and AI-assisted insights through the Model Context Protocol.
About
mcp_mysql provides a powerful Model Context Protocol (MCP) server designed for comprehensive MySQL database management. It extends beyond basic database interactions, offering advanced features for detailed database analysis, proactive health monitoring, and intelligent, AI-assisted operations. With support for multiple transport modes (STDIO and SSE), cross-database access, robust security through role-based access control, and specialized tools for performance optimization, lock detection, and schema discovery, it empowers users to efficiently interact with and gain deeper insights into their MySQL environments. Its AI integration includes prompt templates for enhanced analysis and querying, making database management more intuitive and effective.
Key Features
- Supports STDIO and SSE transport modes for flexible integration
- Integrates AI with prompt templates for intelligent database management and querying
- Enables cross-database access and multi-statement SQL execution
- Implements role-based access control (readonly, writer, admin) for secure operations
- Provides advanced analysis for health, performance, and lock monitoring
- 0 GitHub stars
Use Cases
- Performing comprehensive MySQL health and performance monitoring
- Leveraging AI to analyze slow queries, troubleshoot issues, and generate intelligent queries
- Executing cross-database SQL queries and analyzing table structures