概要
Designed as an extensible Model Context Protocol (MCP) server, this tool enhances MySQL database interaction beyond standard CRUD operations by integrating advanced analysis features. It supports various MCP transfer modes and OAuth2.0 for secure, flexible deployment. Developers can leverage its custom tool extension mechanism to tailor functionality, while built-in tools offer capabilities like SQL execution, performance optimization, database health monitoring, table structure analysis, and intelligent data querying via prompt templates. It also includes robust permission control and supports multiple SQL executions, making it a comprehensive solution for managing and analyzing MySQL databases within an MCP ecosystem.
主な機能
- Includes SQL execution plan analysis and professional performance optimization tools.
- Features robust permission control with readonly, writer, and admin roles.
- Comprehensive MySQL CRUD operations and advanced database analysis.
- Offers database health status, table lock, and index usage analysis.
- 0 GitHub stars
- Supports all Model Context Protocol (MCP) transfer modes (STDIO, SSE, Streamable Http).
ユースケース
- Monitoring database health, connection status, transaction status, and detecting table-level or row-level locks.
- Executing complex SQL commands, managing database schema, and inserting/updating data.
- Analyzing MySQL performance, identifying slow queries, and optimizing SQL based on execution plans and index usage.
Sponsored