Mysql MCP Server Pro

🚀 mcp_mysql_server

mcp_mysql_server is a powerful tool server primarily designed for MySQL database operations. It supports two operating modes, SSE and STDIO, and offers various practical features such as SQL execution and database health analysis.

✨ Features

• SQL Execution: Supports the execution of various SQL commands.
• Database Health Analysis: Includes database status checks and performance optimization suggestions.
• Index Management: Provides index status viewing and optimization suggestions.
• Slow SQL Analysis: Helps identify and optimize slow - executing SQL queries.
• Deadlock Problem Diagnosis: Analyzes and resolves deadlock issues in the database.

📦 Tool List

Supported Tools

Prompt Information

• analyzing - mysql - prompt: Used to analyze MySQL - related problems.
• query - table - data - prompt: Query data based on table comments.

🚀 Quick Start

SSE Mode Configuration

1. Configure the mcp client tool:

{
  "handles": {
    "execute_sql": {
      "type": "tool",
      "description": "Execute various SQL commands"
    },
    // Similar configuration for other tools
  }
}

2. Modify the config.env file and add database information:

MYSQL_HOST=127.0.0.1
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASSWORD=password

3. Start the service:

python server.py

STDIO Mode Configuration

1. Configure the mcp client tool as follows:

{
  "handles": {
    "execute_sql": {
      "type": "tool",
      "description": "Execute various SQL commands"
    },
    // Similar configuration for other tools
  }
}

2. Modify the config.env file and add database information:

MYSQL_HOST=127.0.0.1
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASSWORD=password

3. Start the service:

python server.py

💻 Custom Tool Extension

Steps

1. Create a new tool class in the handles package, inheriting from BaseHandler.
2. Implement the get_tool_description and run_tool methods.
3. Import the new tool into the __init__.py file.

💻 Usage Examples

Create an Organizational Structure Table and Insert Data

# Task
Create an organizational structure table containing fields such as department name, department number, affiliated department, and validity.

# Requirements
- Table name: t_admin_rms_zzjg
- Field types: Use 'varchar(255)' for strings, 'int' for integers, and 'boolean' for booleans.
- A primary key field must be included. The serial number XH is of type varchar(255).
- Fixed fields at the end of the table: creator - CJR varchar(50), creation time - CJSJ datetime, modifier - XGR varchar(50), modification time - XGSJ datetime.
- After creation, insert 5 real data records.

Query Data of Zhang San in the User Information Table

Query the data of Zhang San in the user information table.

Analyze Slow SQL

Analyze the following SQL execution plan and provide optimization suggestions:
select * from t_jcsjzx_hjkq_cd_xsz_sk xsz
left join t_jcsjzx_hjkq_jcd jcd on jcd.cddm = xsz.cddm

Analyze Deadlock Problems

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

Check MySQL Health Status

Check the current health status of MySQL.

Through the above features and examples, mcp_mysql_server can help developers efficiently manage databases and provides various practical tools to optimize database performance.