# 安装 MySQL MCP

- 类型: MCP 工具
- 说明: MCP server for one MySQL database: schema, read-only queries and guarded writes.
- 仓库: https://github.com/gistrec/mcp-mysql-client

## 方式一 · 一键代装（复制提示词让 AI 代劳）

### Claude Code
```
请帮我安装 askskill 上的 "MySQL MCP" MCP 服务：
执行：claude mcp add 'io-github-gistrec-mcp-mysql-client' -- npx -y mcp-mysql-client
```

### Codex
```
请帮我安装 askskill 上的 "MySQL MCP" MCP 服务：
在 ~/.codex/config.toml 中添加：
[mcp_servers.io-github-gistrec-mcp-mysql-client]
command = "npx"
args = ["-y","mcp-mysql-client"]
然后重启 Codex 生效
```

### Cursor
```
请帮我安装 askskill 上的 "MySQL MCP" MCP 服务：
在 .cursor/mcp.json 的 "mcpServers" 中添加：
"io-github-gistrec-mcp-mysql-client": { "command": "npx", "args": ["-y","mcp-mysql-client"] }
然后在 Cursor 设置 > MCP 中启用
```

## 方式二 · 命令行安装（原生命令与配置）

### Claude Code
```bash
claude mcp add --env MYSQL_HOST=YOUR_VALUE --env MYSQL_PORT=YOUR_VALUE --env MYSQL_USER=YOUR_VALUE --env MYSQL_PASS=YOUR_VALUE --env MYSQL_DB=YOUR_VALUE --env MYSQL_SSL=YOUR_VALUE --env MYSQL_SSL_CA=YOUR_VALUE --env ALLOW_INSERT_OPERATION=YOUR_VALUE --env ALLOW_UPDATE_OPERATION=YOUR_VALUE --env ALLOW_DELETE_OPERATION=YOUR_VALUE --env MYSQL_MAX_ROWS=YOUR_VALUE --env MYSQL_TIMEOUT_MS=YOUR_VALUE --transport stdio io-github-gistrec-mcp-mysql-client -- npx -y mcp-mysql-client
```
需要环境变量：MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB, MYSQL_SSL, MYSQL_SSL_CA, ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, ALLOW_DELETE_OPERATION, MYSQL_MAX_ROWS, MYSQL_TIMEOUT_MS

### Codex
```bash
codex mcp add --env MYSQL_HOST=YOUR_VALUE --env MYSQL_PORT=YOUR_VALUE --env MYSQL_USER=YOUR_VALUE --env MYSQL_PASS=YOUR_VALUE --env MYSQL_DB=YOUR_VALUE --env MYSQL_SSL=YOUR_VALUE --env MYSQL_SSL_CA=YOUR_VALUE --env ALLOW_INSERT_OPERATION=YOUR_VALUE --env ALLOW_UPDATE_OPERATION=YOUR_VALUE --env ALLOW_DELETE_OPERATION=YOUR_VALUE --env MYSQL_MAX_ROWS=YOUR_VALUE --env MYSQL_TIMEOUT_MS=YOUR_VALUE io-github-gistrec-mcp-mysql-client -- npx -y mcp-mysql-client
```
配置文件 ~/.codex/config.toml：
```toml
[mcp_servers.io-github-gistrec-mcp-mysql-client]
command = "npx"
args = ["-y","mcp-mysql-client"]

[mcp_servers.io-github-gistrec-mcp-mysql-client.env]
MYSQL_HOST = "YOUR_VALUE"
MYSQL_PORT = "YOUR_VALUE"
MYSQL_USER = "YOUR_VALUE"
MYSQL_PASS = "YOUR_VALUE"
MYSQL_DB = "YOUR_VALUE"
MYSQL_SSL = "YOUR_VALUE"
MYSQL_SSL_CA = "YOUR_VALUE"
ALLOW_INSERT_OPERATION = "YOUR_VALUE"
ALLOW_UPDATE_OPERATION = "YOUR_VALUE"
ALLOW_DELETE_OPERATION = "YOUR_VALUE"
MYSQL_MAX_ROWS = "YOUR_VALUE"
MYSQL_TIMEOUT_MS = "YOUR_VALUE"
```
需要环境变量：MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB, MYSQL_SSL, MYSQL_SSL_CA, ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, ALLOW_DELETE_OPERATION, MYSQL_MAX_ROWS, MYSQL_TIMEOUT_MS

### Cursor
配置文件 .cursor/mcp.json：
```json
{
  "mcpServers": {
    "io-github-gistrec-mcp-mysql-client": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-mysql-client"
      ],
      "env": {
        "MYSQL_HOST": "YOUR_VALUE",
        "MYSQL_PORT": "YOUR_VALUE",
        "MYSQL_USER": "YOUR_VALUE",
        "MYSQL_PASS": "YOUR_VALUE",
        "MYSQL_DB": "YOUR_VALUE",
        "MYSQL_SSL": "YOUR_VALUE",
        "MYSQL_SSL_CA": "YOUR_VALUE",
        "ALLOW_INSERT_OPERATION": "YOUR_VALUE",
        "ALLOW_UPDATE_OPERATION": "YOUR_VALUE",
        "ALLOW_DELETE_OPERATION": "YOUR_VALUE",
        "MYSQL_MAX_ROWS": "YOUR_VALUE",
        "MYSQL_TIMEOUT_MS": "YOUR_VALUE"
      }
    }
  }
}
```
一键安装：cursor://anysphere.cursor-deeplink/mcp/install?name=io-github-gistrec-mcp-mysql-client&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIm1jcC1teXNxbC1jbGllbnQiXSwiZW52Ijp7Ik1ZU1FMX0hPU1QiOiJZT1VSX1ZBTFVFIiwiTVlTUUxfUE9SVCI6IllPVVJfVkFMVUUiLCJNWVNRTF9VU0VSIjoiWU9VUl9WQUxVRSIsIk1ZU1FMX1BBU1MiOiJZT1VSX1ZBTFVFIiwiTVlTUUxfREIiOiJZT1VSX1ZBTFVFIiwiTVlTUUxfU1NMIjoiWU9VUl9WQUxVRSIsIk1ZU1FMX1NTTF9DQSI6IllPVVJfVkFMVUUiLCJBTExPV19JTlNFUlRfT1BFUkFUSU9OIjoiWU9VUl9WQUxVRSIsIkFMTE9XX1VQREFURV9PUEVSQVRJT04iOiJZT1VSX1ZBTFVFIiwiQUxMT1dfREVMRVRFX09QRVJBVElPTiI6IllPVVJfVkFMVUUiLCJNWVNRTF9NQVhfUk9XUyI6IllPVVJfVkFMVUUiLCJNWVNRTF9USU1FT1VUX01TIjoiWU9VUl9WQUxVRSJ9fQ
需要环境变量：MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB, MYSQL_SSL, MYSQL_SSL_CA, ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, ALLOW_DELETE_OPERATION, MYSQL_MAX_ROWS, MYSQL_TIMEOUT_MS