# 安装 ClickHouse

- 类型: MCP 工具
- 说明: Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
- 仓库: https://github.com/ClickHouse/mcp-clickhouse

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

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

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

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

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

### Claude Code
```bash
claude mcp add --env CLICKHOUSE_HOST=YOUR_VALUE --env CLICKHOUSE_USER=YOUR_VALUE --env CLICKHOUSE_PASSWORD=YOUR_VALUE --env CLICKHOUSE_PORT=YOUR_VALUE --env CLICKHOUSE_SECURE=YOUR_VALUE --env CLICKHOUSE_VERIFY=YOUR_VALUE --env CLICKHOUSE_DATABASE=YOUR_VALUE --env CLICKHOUSE_ROLE=YOUR_VALUE --env CLICKHOUSE_ALLOW_WRITE_ACCESS=YOUR_VALUE --env CLICKHOUSE_ALLOW_DROP=YOUR_VALUE --env CLICKHOUSE_MCP_QUERY_TIMEOUT=YOUR_VALUE --transport stdio io-github-clickhouse-mcp-clickhouse -- uvx mcp-clickhouse
```
需要环境变量：CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_PORT, CLICKHOUSE_SECURE, CLICKHOUSE_VERIFY, CLICKHOUSE_DATABASE, CLICKHOUSE_ROLE, CLICKHOUSE_ALLOW_WRITE_ACCESS, CLICKHOUSE_ALLOW_DROP, CLICKHOUSE_MCP_QUERY_TIMEOUT

### Codex
```bash
codex mcp add --env CLICKHOUSE_HOST=YOUR_VALUE --env CLICKHOUSE_USER=YOUR_VALUE --env CLICKHOUSE_PASSWORD=YOUR_VALUE --env CLICKHOUSE_PORT=YOUR_VALUE --env CLICKHOUSE_SECURE=YOUR_VALUE --env CLICKHOUSE_VERIFY=YOUR_VALUE --env CLICKHOUSE_DATABASE=YOUR_VALUE --env CLICKHOUSE_ROLE=YOUR_VALUE --env CLICKHOUSE_ALLOW_WRITE_ACCESS=YOUR_VALUE --env CLICKHOUSE_ALLOW_DROP=YOUR_VALUE --env CLICKHOUSE_MCP_QUERY_TIMEOUT=YOUR_VALUE io-github-clickhouse-mcp-clickhouse -- uvx mcp-clickhouse
```
配置文件 ~/.codex/config.toml：
```toml
[mcp_servers.io-github-clickhouse-mcp-clickhouse]
command = "uvx"
args = ["mcp-clickhouse"]

[mcp_servers.io-github-clickhouse-mcp-clickhouse.env]
CLICKHOUSE_HOST = "YOUR_VALUE"
CLICKHOUSE_USER = "YOUR_VALUE"
CLICKHOUSE_PASSWORD = "YOUR_VALUE"
CLICKHOUSE_PORT = "YOUR_VALUE"
CLICKHOUSE_SECURE = "YOUR_VALUE"
CLICKHOUSE_VERIFY = "YOUR_VALUE"
CLICKHOUSE_DATABASE = "YOUR_VALUE"
CLICKHOUSE_ROLE = "YOUR_VALUE"
CLICKHOUSE_ALLOW_WRITE_ACCESS = "YOUR_VALUE"
CLICKHOUSE_ALLOW_DROP = "YOUR_VALUE"
CLICKHOUSE_MCP_QUERY_TIMEOUT = "YOUR_VALUE"
```
需要环境变量：CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_PORT, CLICKHOUSE_SECURE, CLICKHOUSE_VERIFY, CLICKHOUSE_DATABASE, CLICKHOUSE_ROLE, CLICKHOUSE_ALLOW_WRITE_ACCESS, CLICKHOUSE_ALLOW_DROP, CLICKHOUSE_MCP_QUERY_TIMEOUT

### Cursor
配置文件 .cursor/mcp.json：
```json
{
  "mcpServers": {
    "io-github-clickhouse-mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "YOUR_VALUE",
        "CLICKHOUSE_USER": "YOUR_VALUE",
        "CLICKHOUSE_PASSWORD": "YOUR_VALUE",
        "CLICKHOUSE_PORT": "YOUR_VALUE",
        "CLICKHOUSE_SECURE": "YOUR_VALUE",
        "CLICKHOUSE_VERIFY": "YOUR_VALUE",
        "CLICKHOUSE_DATABASE": "YOUR_VALUE",
        "CLICKHOUSE_ROLE": "YOUR_VALUE",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "YOUR_VALUE",
        "CLICKHOUSE_ALLOW_DROP": "YOUR_VALUE",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "YOUR_VALUE"
      }
    }
  }
}
```
一键安装：cursor://anysphere.cursor-deeplink/mcp/install?name=io-github-clickhouse-mcp-clickhouse&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJtY3AtY2xpY2tob3VzZSJdLCJlbnYiOnsiQ0xJQ0tIT1VTRV9IT1NUIjoiWU9VUl9WQUxVRSIsIkNMSUNLSE9VU0VfVVNFUiI6IllPVVJfVkFMVUUiLCJDTElDS0hPVVNFX1BBU1NXT1JEIjoiWU9VUl9WQUxVRSIsIkNMSUNLSE9VU0VfUE9SVCI6IllPVVJfVkFMVUUiLCJDTElDS0hPVVNFX1NFQ1VSRSI6IllPVVJfVkFMVUUiLCJDTElDS0hPVVNFX1ZFUklGWSI6IllPVVJfVkFMVUUiLCJDTElDS0hPVVNFX0RBVEFCQVNFIjoiWU9VUl9WQUxVRSIsIkNMSUNLSE9VU0VfUk9MRSI6IllPVVJfVkFMVUUiLCJDTElDS0hPVVNFX0FMTE9XX1dSSVRFX0FDQ0VTUyI6IllPVVJfVkFMVUUiLCJDTElDS0hPVVNFX0FMTE9XX0RST1AiOiJZT1VSX1ZBTFVFIiwiQ0xJQ0tIT1VTRV9NQ1BfUVVFUllfVElNRU9VVCI6IllPVVJfVkFMVUUifX0
需要环境变量：CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_PORT, CLICKHOUSE_SECURE, CLICKHOUSE_VERIFY, CLICKHOUSE_DATABASE, CLICKHOUSE_ROLE, CLICKHOUSE_ALLOW_WRITE_ACCESS, CLICKHOUSE_ALLOW_DROP, CLICKHOUSE_MCP_QUERY_TIMEOUT