general MCP Server
Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Discovered via unknown and last synced 3mo ago.
1. Install the package
uvx --from mysql_mcp_server_pro mysql_mcp_server_pro --mode stdio
2. Add to claude_desktop_config.json
{
"mcpServers": {
"mysql-mcp-server-pro": {
"command": "npx",
"args": [
"mysql_mcp_server_pro"
]
}
}
}Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) / %APPDATA%\Claude\claude_desktop_config.json (Windows)
Analyze MySQL health status (connection status, transaction status, running status, lock status detection)
This is a prompt for querying table data using tools. If description is empty, it will be initialized as a MySQL database query assistant
Search for table names in the database based on table comments and descriptions
Check if there are row-level locks or table-level locks in the current MySQL server
Search for table indexes in the database based on table names, supporting multi-table queries
SQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configuration
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 enable it, see this class for details)
Convert Chinese field names to pinyin initials
This is a prompt for analyzing MySQL-related issues
Search for table structures in the database based on table names, supporting multi-table queries
Get the index usage of the currently connected mysql database, including redundant index situations, poorly performing index situations, and the top 5 unused index situations with query times greater than 30 seconds
Professional SQL performance optimization tool, providing expert optimization suggestions based on MySQL execution plans, table structure information, table data volume, and table indexes.
Databao agent is an open-source agent that enables you to chat with your data and receive answers in text, interactive charts, and tables.
Skardi is a self-improving context framework for ai agents
Lightweight task & matter service for the OCTO platform — REST API, timeline tracking, and LLM-powered extraction. Part of the OCTO open workplace for humans × AI agents.