ClickHouse

Overview

ClickHouse is a Model Context Protocol (MCP) server: Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB. Because it speaks the Model Context Protocol, AI assistants can use ClickHouse as a set of callable tools instead of you copy-pasting between apps.

It runs locally: the Python package mcp-clickhouse (via uvx) speaks MCP over stdio on your machine. Configuration happens through environment variables — you'll need CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD. The current release is v0.4.1, published under the Apache-2.0 license, with source at ClickHouse/mcp-clickhouse on GitHub, where it has earned 862 stars.

On mcp.site, ClickHouse sits in the Database category. Any MCP client can use it — Claude Desktop, Claude Code, Cursor, VS Code, Windsurf, Zed among them — via the install snippets below. If you maintain ClickHouse for ClickHouse, claim this listing to verify ownership, earn the Verified badge, and keep the details current.

Installation

// claude_desktop_config.json
{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<clickhouse-host>",
        "CLICKHOUSE_USER": "<clickhouse-user>",
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>"
      }
    }
  }
}

Requires CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD