MySQL MCP Xu

Name: MySQL MCP Xu
Author: XMQSVIP

XMQSVIP

Get started Repository

基于 FastMCP 执行 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-xu --env MYSQL_DATABASE='<MYSQL_DATABASE>' --env MYSQL_HOST='<MYSQL_HOST>' --env MYSQL_PASSWORD='<MYSQL_PASSWORD>' --env MYSQL_PORT='<MYSQL_PORT>' --env MYSQL_ROLE='<MYSQL_ROLE>' --env MYSQL_USER='<MYSQL_USER>' -- uvx mysql-mcp-xu

~/.codex/config.toml

[mcp_servers.mysql-xu]
command = "uvx"
args = ["mysql-mcp-xu"]
env = { MYSQL_DATABASE = "<MYSQL_DATABASE>", MYSQL_HOST = "<MYSQL_HOST>", MYSQL_PASSWORD = "<MYSQL_PASSWORD>", MYSQL_PORT = "<MYSQL_PORT>", MYSQL_ROLE = "<MYSQL_ROLE>", MYSQL_USER = "<MYSQL_USER>" }

# codex mcp add mysql-xu --env MYSQL_DATABASE='<MYSQL_DATABASE>' --env MYSQL_HOST='<MYSQL_HOST>' --env MYSQL_PASSWORD='<MYSQL_PASSWORD>' --env MYSQL_PORT='<MYSQL_PORT>' --env MYSQL_ROLE='<MYSQL_ROLE>' --env MYSQL_USER='<MYSQL_USER>' -- uvx mysql-mcp-xu

~/.cursor/mcp.json

{
  "mcpServers": {
    "mysql-xu": {
      "command": "uvx",
      "args": [
        "mysql-mcp-xu"
      ],
      "env": {
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_ROLE": "<MYSQL_ROLE>",
        "MYSQL_USER": "<MYSQL_USER>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "mysql-xu": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mysql-mcp-xu"
      ],
      "env": {
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_ROLE": "<MYSQL_ROLE>",
        "MYSQL_USER": "<MYSQL_USER>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "mysql-xu": {
      "command": "uvx",
      "args": [
        "mysql-mcp-xu"
      ],
      "env": {
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_ROLE": "<MYSQL_ROLE>",
        "MYSQL_USER": "<MYSQL_USER>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "mysql-xu": {
      "command": "uvx",
      "args": [
        "mysql-mcp-xu"
      ],
      "env": {
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_ROLE": "<MYSQL_ROLE>",
        "MYSQL_USER": "<MYSQL_USER>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "mysql-xu": {
      "command": "uvx",
      "args": [
        "mysql-mcp-xu"
      ],
      "env": {
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_ROLE": "<MYSQL_ROLE>",
        "MYSQL_USER": "<MYSQL_USER>"
      }
    }
  }
}

Environment variables

MYSQL_DATABASE
MYSQL_HOST
MYSQL_PASSWORD
MYSQL_PORT
MYSQL_ROLE
MYSQL_USER

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

Setup

Environment variables

Related