ClickHouse MCP Server

Name: ClickHouse MCP Server
Author: ClickHouse

ClickHouse官方

Connect ClickHouse to AI assistants: run SQL queries, list databases and tables, inspect schemas, and optionally query via chDB.

接入配置

选择客户端，复制配置，再按项目文档补齐环境变量。

一键添加到 Cursor 一键添加到 VS Code

claude mcp add clickhouse --env CLICKHOUSE_HOST='<CLICKHOUSE_HOST>' --env CLICKHOUSE_USER='<CLICKHOUSE_USER>' --env CLICKHOUSE_PASSWORD='<CLICKHOUSE_PASSWORD>' --env CLICKHOUSE_PORT='<CLICKHOUSE_PORT>' --env CLICKHOUSE_SECURE='<CLICKHOUSE_SECURE>' --env CLICKHOUSE_VERIFY='<CLICKHOUSE_VERIFY>' --env CLICKHOUSE_CONNECT_TIMEOUT='<CLICKHOUSE_CONNECT_TIMEOUT>' --env CLICKHOUSE_SEND_RECEIVE_TIMEOUT='<CLICKHOUSE_SEND_RECEIVE_TIMEOUT>' --env CLICKHOUSE_DATABASE='<CLICKHOUSE_DATABASE>' -- uvx mcp-clickhouse

~/.codex/config.toml

[mcp_servers.clickhouse]
command = "uvx"
args = ["mcp-clickhouse"]
env = { CLICKHOUSE_HOST = "<CLICKHOUSE_HOST>", CLICKHOUSE_USER = "<CLICKHOUSE_USER>", CLICKHOUSE_PASSWORD = "<CLICKHOUSE_PASSWORD>", CLICKHOUSE_PORT = "<CLICKHOUSE_PORT>", CLICKHOUSE_SECURE = "<CLICKHOUSE_SECURE>", CLICKHOUSE_VERIFY = "<CLICKHOUSE_VERIFY>", CLICKHOUSE_CONNECT_TIMEOUT = "<CLICKHOUSE_CONNECT_TIMEOUT>", CLICKHOUSE_SEND_RECEIVE_TIMEOUT = "<CLICKHOUSE_SEND_RECEIVE_TIMEOUT>", CLICKHOUSE_DATABASE = "<CLICKHOUSE_DATABASE>" }

# codex mcp add clickhouse --env CLICKHOUSE_HOST='<CLICKHOUSE_HOST>' --env CLICKHOUSE_USER='<CLICKHOUSE_USER>' --env CLICKHOUSE_PASSWORD='<CLICKHOUSE_PASSWORD>' --env CLICKHOUSE_PORT='<CLICKHOUSE_PORT>' --env CLICKHOUSE_SECURE='<CLICKHOUSE_SECURE>' --env CLICKHOUSE_VERIFY='<CLICKHOUSE_VERIFY>' --env CLICKHOUSE_CONNECT_TIMEOUT='<CLICKHOUSE_CONNECT_TIMEOUT>' --env CLICKHOUSE_SEND_RECEIVE_TIMEOUT='<CLICKHOUSE_SEND_RECEIVE_TIMEOUT>' --env CLICKHOUSE_DATABASE='<CLICKHOUSE_DATABASE>' -- uvx mcp-clickhouse

~/.cursor/mcp.json

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CONNECT_TIMEOUT": "<CLICKHOUSE_CONNECT_TIMEOUT>",
        "CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "<CLICKHOUSE_SEND_RECEIVE_TIMEOUT>",
        "CLICKHOUSE_DATABASE": "<CLICKHOUSE_DATABASE>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CONNECT_TIMEOUT": "<CLICKHOUSE_CONNECT_TIMEOUT>",
        "CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "<CLICKHOUSE_SEND_RECEIVE_TIMEOUT>",
        "CLICKHOUSE_DATABASE": "<CLICKHOUSE_DATABASE>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CONNECT_TIMEOUT": "<CLICKHOUSE_CONNECT_TIMEOUT>",
        "CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "<CLICKHOUSE_SEND_RECEIVE_TIMEOUT>",
        "CLICKHOUSE_DATABASE": "<CLICKHOUSE_DATABASE>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CONNECT_TIMEOUT": "<CLICKHOUSE_CONNECT_TIMEOUT>",
        "CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "<CLICKHOUSE_SEND_RECEIVE_TIMEOUT>",
        "CLICKHOUSE_DATABASE": "<CLICKHOUSE_DATABASE>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CONNECT_TIMEOUT": "<CLICKHOUSE_CONNECT_TIMEOUT>",
        "CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "<CLICKHOUSE_SEND_RECEIVE_TIMEOUT>",
        "CLICKHOUSE_DATABASE": "<CLICKHOUSE_DATABASE>"
      }
    }
  }
}

需要的环境变量

CLICKHOUSE_HOST
CLICKHOUSE_USER
CLICKHOUSE_PASSWORD
CLICKHOUSE_PORT
CLICKHOUSE_SECURE
CLICKHOUSE_VERIFY
CLICKHOUSE_CONNECT_TIMEOUT
CLICKHOUSE_SEND_RECEIVE_TIMEOUT
CLICKHOUSE_DATABASE

把占位值换成你自己的密钥；不要把密钥提交到代码仓库。

接入配置

需要的环境变量

相关推荐