MCP-Mirror/wenb1n-dev_mysql_mcp_server_pro

3.2

If you are the rightful owner of wenb1n-dev_mysql_mcp_server_pro and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include advanced database anomaly analysis and customization capabilities.

Tools

Functions exposed to the LLM to take actions

execute_sql

SQL execution tool that can execute various commands based on permission configuration.

get_chinese_initials

Convert Chinese field names to pinyin initials.

get_db_health_running

Analyze MySQL health status including connection, transaction, and lock status.

get_table_desc

Search for table structures in the database based on table names.

get_table_index

Search for table indexes in the database based on table names.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

MCP-Mirror

Claim Ownership

Verify you have write access to the repository

Version

v1.4.0

Repository

https://github.com/MCP-Mirror/wenb1n-dev_mysql_mcp_server_pro

License

MIT License

Last publish date

2025-05-28

Last update date

2025-05-30

Server configs

in claude desktop

{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro"
      ],
      "env": {
        "MYSQL_HOST": "192.168.x.xxx",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "root",
        "MYSQL_DATABASE": "a_llm",
        "MYSQL_ROLE": "admin"
      }
    }
  }
}

in vscode

{
  "mcpServers": {
    "operateMysql": {
      "isActive": true,
      "name": "operateMysql",
      "command": "uv",
      "args": [
        "--directory",
        "/Volumes/mysql_mcp_server_pro/src/mysql_mcp_server_pro",
        "run",
        "-m",
        "mysql_mcp_server_pro.server",
        "--stdio"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "123456",
        "MYSQL_DATABASE": "a_llm",
        "MYSQL_ROLE": "admin"
      }
    }
  }
}

in vscode

{
  "mcpServers": {
    "operateMysql": {
      "name": "operateMysql",
      "description": "",
      "isActive": true,
      "baseUrl": "http://localhost:9000/sse"
    }
  }
}