Skip to content
mcp/harbor
Cline

ClickHouse for Cline

io.github.clickhouse/mcp-clickhouse

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

client:Cline transport:stdio runtime:pypi

Install ClickHouse in Cline

~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json · windows: %APPDATA%\Code\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen. 

{
  "mcpServers": {
    "mcp-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_CA_CERT": "<CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Cline's MCP Servers pane edits this file for you if you would rather not find it. Cline docs

ClickHouse in other clients

ClickHouse MCP server