# 安装 QueryPilot

- 类型: MCP 工具
- 说明: Safe SQL gateway for AI agents: SELECT-only validation, access policies, masking, audit trail, evals
- 仓库: https://github.com/nickklos10/QueryPilot

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

### Claude Code
```
请帮我安装 askskill 上的 "QueryPilot" MCP 服务：
执行：claude mcp add 'io-github-nickklos10-querypilot' -- uvx querypilot
```

### Codex
```
请帮我安装 askskill 上的 "QueryPilot" MCP 服务：
在 ~/.codex/config.toml 中添加：
[mcp_servers.io-github-nickklos10-querypilot]
command = "uvx"
args = ["querypilot"]
然后重启 Codex 生效
```

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

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

### Claude Code
```bash
claude mcp add --env QUERYPILOT_DATABASE_URL=YOUR_VALUE --env QUERYPILOT_DIALECT=YOUR_VALUE --env QUERYPILOT_MAX_ROWS=YOUR_VALUE --env QUERYPILOT_TIMEOUT_SECONDS=YOUR_VALUE --env QUERYPILOT_ACCESS_POLICY_JSON=YOUR_VALUE --env QUERYPILOT_MCP_TRANSPORT=YOUR_VALUE --transport stdio io-github-nickklos10-querypilot -- uvx querypilot
```
需要环境变量：QUERYPILOT_DATABASE_URL, QUERYPILOT_DIALECT, QUERYPILOT_MAX_ROWS, QUERYPILOT_TIMEOUT_SECONDS, QUERYPILOT_ACCESS_POLICY_JSON, QUERYPILOT_MCP_TRANSPORT

### Codex
```bash
codex mcp add --env QUERYPILOT_DATABASE_URL=YOUR_VALUE --env QUERYPILOT_DIALECT=YOUR_VALUE --env QUERYPILOT_MAX_ROWS=YOUR_VALUE --env QUERYPILOT_TIMEOUT_SECONDS=YOUR_VALUE --env QUERYPILOT_ACCESS_POLICY_JSON=YOUR_VALUE --env QUERYPILOT_MCP_TRANSPORT=YOUR_VALUE io-github-nickklos10-querypilot -- uvx querypilot
```
配置文件 ~/.codex/config.toml：
```toml
[mcp_servers.io-github-nickklos10-querypilot]
command = "uvx"
args = ["querypilot"]

[mcp_servers.io-github-nickklos10-querypilot.env]
QUERYPILOT_DATABASE_URL = "YOUR_VALUE"
QUERYPILOT_DIALECT = "YOUR_VALUE"
QUERYPILOT_MAX_ROWS = "YOUR_VALUE"
QUERYPILOT_TIMEOUT_SECONDS = "YOUR_VALUE"
QUERYPILOT_ACCESS_POLICY_JSON = "YOUR_VALUE"
QUERYPILOT_MCP_TRANSPORT = "YOUR_VALUE"
```
需要环境变量：QUERYPILOT_DATABASE_URL, QUERYPILOT_DIALECT, QUERYPILOT_MAX_ROWS, QUERYPILOT_TIMEOUT_SECONDS, QUERYPILOT_ACCESS_POLICY_JSON, QUERYPILOT_MCP_TRANSPORT

### Cursor
配置文件 .cursor/mcp.json：
```json
{
  "mcpServers": {
    "io-github-nickklos10-querypilot": {
      "command": "uvx",
      "args": [
        "querypilot"
      ],
      "env": {
        "QUERYPILOT_DATABASE_URL": "YOUR_VALUE",
        "QUERYPILOT_DIALECT": "YOUR_VALUE",
        "QUERYPILOT_MAX_ROWS": "YOUR_VALUE",
        "QUERYPILOT_TIMEOUT_SECONDS": "YOUR_VALUE",
        "QUERYPILOT_ACCESS_POLICY_JSON": "YOUR_VALUE",
        "QUERYPILOT_MCP_TRANSPORT": "YOUR_VALUE"
      }
    }
  }
}
```
一键安装：cursor://anysphere.cursor-deeplink/mcp/install?name=io-github-nickklos10-querypilot&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJxdWVyeXBpbG90Il0sImVudiI6eyJRVUVSWVBJTE9UX0RBVEFCQVNFX1VSTCI6IllPVVJfVkFMVUUiLCJRVUVSWVBJTE9UX0RJQUxFQ1QiOiJZT1VSX1ZBTFVFIiwiUVVFUllQSUxPVF9NQVhfUk9XUyI6IllPVVJfVkFMVUUiLCJRVUVSWVBJTE9UX1RJTUVPVVRfU0VDT05EUyI6IllPVVJfVkFMVUUiLCJRVUVSWVBJTE9UX0FDQ0VTU19QT0xJQ1lfSlNPTiI6IllPVVJfVkFMVUUiLCJRVUVSWVBJTE9UX01DUF9UUkFOU1BPUlQiOiJZT1VSX1ZBTFVFIn19
需要环境变量：QUERYPILOT_DATABASE_URL, QUERYPILOT_DIALECT, QUERYPILOT_MAX_ROWS, QUERYPILOT_TIMEOUT_SECONDS, QUERYPILOT_ACCESS_POLICY_JSON, QUERYPILOT_MCP_TRANSPORT