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 SQL Execution Plan Analysis
• 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

# Download dependencies
uv sync

# run 
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