---
title: "ClickHouse 自建 mcp-clickhouse"
filename: "~/.codex/config.toml"
canonical: /templates/mcp-clickhouse-stdio/
---

# ClickHouse 自建 mcp-clickhouse

通过 uv 启动 mcp-clickhouse，并使用 env_vars 提供连接信息与密码。默认采用只读查询，独立于 Cloud 托管服务。

```
codex mcp add mcp-clickhouse -- uv run --with mcp-clickhouse --python 3.10 mcp-clickhouse

[mcp_servers.mcp-clickhouse]
command = "uv"
args = ["run", "--with", "mcp-clickhouse", "--python", "3.10", "mcp-clickhouse"]
env_vars = ["CLICKHOUSE_HOST", "CLICKHOUSE_USER", "CLICKHOUSE_PASSWORD"]
startup_timeout_sec = 60
enabled = true

[mcp_servers.mcp-clickhouse.env]
CLICKHOUSE_SECURE = "true"

# 自建明文 HTTP 才改：
# CLICKHOUSE_SECURE = "false"
# 并把 CLICKHOUSE_PORT 加进 env_vars

```