MCP Mysql Server

🚀 mcp_mysql_server

The mcp_mysql_server_pro not only supports basic CRUD operations for MySQL but also includes database anomaly analysis capabilities. It also allows developers to easily extend custom tools.

🚀 Quick Start

The mcp_mysql_server_pro offers a wide range of features and tools to enhance MySQL database management. Here's a quick overview of its capabilities and how to use them.

✨ Features

• Mode Support: Supports both STDIO and SSE modes.
• Multiple SQL Execution: Allows execution of multiple SQL statements separated by ";".
• Table Query by Comment: Enables searching for database table names and fields based on table comments.
• SQL Execution Plan Analysis: Provides analysis of SQL execution plans.
• Chinese Field to Pinyin: Converts Chinese field names to pinyin.
• Table Lock Analysis: Analyzes table lock status in the database.
• Database Health Status Analysis: Checks the health status of the MySQL database.
• Role-based Permission Control: Supports three roles with different permission levels:

  "readonly": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN"],  # Read-only permissions
  "writer": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE"],  # Read-write permissions
  "admin": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", 
           "CREATE", "ALTER", "DROP", "TRUNCATE"]  # Administrator permissions
  

• Prompt Template Invocation: Supports the use of prompt templates.

📚 Documentation

Tool List

Prompt List

Usage Instructions

SSE Mode Configuration and Startup

1. Create a new tool class in the handles folder, inherit from BaseHandler, and implement the get_tool_description and run_tool methods.
2. Import the new tool into the __init__.py file to make it effective.

💻 Usage Examples

Basic Usage - STDIO Mode

# Task
Create an organizational structure table with the following structure: Department Name, Department Number, Parent Department, and Validity.

# Requirements
 - Table name: t_admin_rms_zzjg
 - Field requirements: Use 'varchar(255)' for string types, 'int' for integer types, 'float' for floating-point types, 'datetime' for date and time types, 'boolean' for boolean types, 'text' for text types, 'longtext' for large text types, 'bigint' for large integer types, and 'double' for large floating-point types.
 - The table header must include a primary key field, serial number XH varchar(255).
 - The table must include the following fixed fields: Creator - CJR varchar(50), Creation Time - CJSJ datetime, Modifier - XGR varchar(50), Modification Time - XGSJ datetime.
 - Field names should use the content returned by the tool.
 - Public fields need to be indexed.
 - Each field and the table need to be commented.
 - Generate 5 real data records after creation.

Query Data Example

# Prompt
Query user information data for Zhang San.

Analyze Slow SQL Example

select * from t_jcsjzx_hjkq_cd_xsz_sk xsz
left join t_jcsjzx_hjkq_jcd jcd on jcd.cddm = xsz.cddm 
Review the execution plan based on the current index situation and provide optimization suggestions (in Markdown format), including table index status, execution details, and optimization suggestions.

Resolve SQL Deadlock Example

update t_admin_rms_zzjg set sfyx = '0' where xh = '1' is stuck. Please analyze the reason.

Check Health Status Example

Check the current health status of MySQL.