MySQL MCP Server Pro

Name: MySQL MCP Server Pro
Author: wenb1n-dev

wenb1n-dev

Get started Repository

让智能体对 MySQL 增删改查，执行数据库异常分析，并支持权限控制与自定义工具扩展。

Setup

Choose your client, copy the config, then fill in any required environment variables.

Add to Cursor Add to VS Code

claude mcp add mysql-server-pro --env ENV_FILE_PATH='<ENV_FILE_PATH>' --env MYSQL_HOST='<MYSQL_HOST>' --env MYSQL_PORT='<MYSQL_PORT>' --env MYSQL_USER='<MYSQL_USER>' --env MYSQL_PASSWORD='<MYSQL_PASSWORD>' --env MYSQL_DATABASE='<MYSQL_DATABASE>' --env MYSQL_ROLE='<MYSQL_ROLE>' -- uvx --from mysql_mcp_server_pro mysql_mcp_server_pro --mode stdio

~/.codex/config.toml

[mcp_servers.mysql-server-pro]
command = "uvx"
args = ["--from", "mysql_mcp_server_pro", "mysql_mcp_server_pro", "--mode", "stdio"]
env = { ENV_FILE_PATH = "<ENV_FILE_PATH>", MYSQL_HOST = "<MYSQL_HOST>", MYSQL_PORT = "<MYSQL_PORT>", MYSQL_USER = "<MYSQL_USER>", MYSQL_PASSWORD = "<MYSQL_PASSWORD>", MYSQL_DATABASE = "<MYSQL_DATABASE>", MYSQL_ROLE = "<MYSQL_ROLE>" }

# codex mcp add mysql-server-pro --env ENV_FILE_PATH='<ENV_FILE_PATH>' --env MYSQL_HOST='<MYSQL_HOST>' --env MYSQL_PORT='<MYSQL_PORT>' --env MYSQL_USER='<MYSQL_USER>' --env MYSQL_PASSWORD='<MYSQL_PASSWORD>' --env MYSQL_DATABASE='<MYSQL_DATABASE>' --env MYSQL_ROLE='<MYSQL_ROLE>' -- uvx --from mysql_mcp_server_pro mysql_mcp_server_pro --mode stdio

~/.cursor/mcp.json

{
  "mcpServers": {
    "mysql-server-pro": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "ENV_FILE_PATH": "<ENV_FILE_PATH>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_ROLE": "<MYSQL_ROLE>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "mysql-server-pro": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "ENV_FILE_PATH": "<ENV_FILE_PATH>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_ROLE": "<MYSQL_ROLE>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "mysql-server-pro": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "ENV_FILE_PATH": "<ENV_FILE_PATH>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_ROLE": "<MYSQL_ROLE>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "mysql-server-pro": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "ENV_FILE_PATH": "<ENV_FILE_PATH>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_ROLE": "<MYSQL_ROLE>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "mysql-server-pro": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "ENV_FILE_PATH": "<ENV_FILE_PATH>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_ROLE": "<MYSQL_ROLE>"
      }
    }
  }
}

Environment variables

ENV_FILE_PATH
MYSQL_HOST
MYSQL_PORT
MYSQL_USER
MYSQL_PASSWORD
MYSQL_DATABASE
MYSQL_ROLE

Replace the placeholders with your own credentials and keep them out of version control.

Setup

Environment variables

Related