Content
# mcp_mysql_server
## Introduction
- Added support for STDIO mode and SSE mode
- Added support for multiple SQL execution, separated by ";"
- Added ability to query database table names and fields based on table comments
- Added Chinese field to pinyin conversion
## Usage Instructions
### STDIO Mode
- Use src/studio_mcp/operatemysql.py
Add the following content to your mcp client tools, such as cursor, cline, etc.
mcp json as follows:
```
{
"mcpServers": {
"operateMysql": {
"isActive": true,
"name": "operateMysql",
"command": "uv",
"args": [
"--directory",
"G:\\python\\mysql_mcp\\src\\studio_mcp", # Here you need to replace with your project path.
"run",
"operatemysql.py"
],
"env": {
"MYSQL_HOST": "192.168.xxx.xxx",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASSWORD": "root",
"MYSQL_DATABASE": "a_llm"
}
}
}
}
```
### SSE Mode
- Use src/sse_mcp/operatemysql.py
- Use uv to start the service
Add the following content to your mcp client tools, such as cursor, cline, etc.
mcp json as follows:
```
{
"mcpServers": {
"operateMysql": {
"name": "operateMysql",
"description": "",
"isActive": true,
"baseUrl": "http://localhost:9000/sse"
}
}
}
```
Modify the .env file content to modify the database connection information to your database connection information
```
# MySQL database configuration
MYSQL_HOST=192.168.xxx.xxx
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASSWORD=root
MYSQL_DATABASE=a_llm
```
Start command
```
uv run operatemysql.py
```
## Example
prompt format as follows
```
# Task
Create an organization structure table, table structure as follows: department name, department number, parent department, whether effective.
# Requirements
- Table name use t_admin_rms_zzjg,
- Field requirements: string type uses 'varchar(255)', integer type uses 'int', float type uses 'float', date and time type uses 'datetime', boolean type uses 'boolean', text type uses 'text', large text type uses 'longtext', large integer type uses 'bigint', large float type uses 'double'.
- Table header needs to add primary key field, serial number XH varchar(255)
- Table last needs to add fixed fields: creator-CJR varchar(50), creation time-CJSJ datetime, modifier-XGR varchar(50), modification time-XGSJ datetime.
- Field naming uses tool return content as field naming
- Common fields need to add indexes
- Each field needs to add comments, table comments need to be added
- Generate 5 real data after creation
```
#### Effect picture
