Mysql MCP Server Pro

Unclaimed

by wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

Install

$pip install mysql_mcp_server_pro

Unclaimed listing

Is this your MCP server?

This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.

Claim this server

Tools (10)

execute_sql

SQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configuration

get_chinese_initials

Convert Chinese field names to pinyin initials

get_db_health_index_usage

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

get_db_health_running

Analyze MySQL health status (connection status, transaction status, running status, lock status detection)

get_table_desc

Search for table structures in the database based on table names, supporting multi-table queries

get_table_index

Search for table indexes in the database based on table names, supporting multi-table queries

get_table_lock

Check if there are row-level locks or table-level locks in the current MySQL server

get_table_name

Search for table names in the database based on table comments and descriptions

optimize_sql

Professional SQL performance optimization tool, providing expert optimization suggestions based on MySQL execution plans, table structure information, table data volume, and table indexes.

use_prompt_queryTableData

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)