ClickHouse

MCP server · by ClickHouse

Databases PythonDocker v0.7.0

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

View source ↗ Website ↗ Generate config for multiple servers More servers

Install

Pin version registry version 0.7.0

Python
uvx mcp-clickhouse

Python
uvx mcp-clickhouse@0.7.0

Docker
docker run -i --rm ghcr.io/clickhouse/mcp-clickhouse:0.7.0

Setup by client

Pick your client — the config below is generated for this server (local stdio). Copy respects the “Pin version” switch above.

claude_desktop_config.json

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Format verified against the official Claude Desktop docs ↗.

terminal

claude mcp add --env CLICKHOUSE_HOST=<YOUR_CLICKHOUSE_HOST> --env CLICKHOUSE_USER=<YOUR_CLICKHOUSE_USER> --env CLICKHOUSE_PASSWORD=<YOUR_CLICKHOUSE_PASSWORD> mcp-clickhouse -- uvx mcp-clickhouse

claude mcp add --env CLICKHOUSE_HOST=<YOUR_CLICKHOUSE_HOST> --env CLICKHOUSE_USER=<YOUR_CLICKHOUSE_USER> --env CLICKHOUSE_PASSWORD=<YOUR_CLICKHOUSE_PASSWORD> mcp-clickhouse -- uvx mcp-clickhouse@0.7.0

Format verified against the official Claude Code docs ↗.

.cursor/mcp.json

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Format verified against the official Cursor docs ↗.

.vscode/mcp.json

{
  "servers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

{
  "servers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Format verified against the official VS Code docs ↗.

mcp_config.json

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Format verified against the official Windsurf docs ↗.

Environment variables

Defined in the server's official registry manifest. Required secrets are shown as <YOUR_…> placeholders in the configs above.

CLICKHOUSE_HOST required — Hostname of the ClickHouse server
CLICKHOUSE_USER required — Username for ClickHouse authentication
CLICKHOUSE_PASSWORD secret — Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode
CLICKHOUSE_PORT — ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise
CLICKHOUSE_SECURE — Use HTTPS to connect to ClickHouse
CLICKHOUSE_VERIFY — Verify SSL certificates
CLICKHOUSE_CA_CERT — Path to a PEM CA bundle for ClickHouse server certificate verification
CLICKHOUSE_CLIENT_CERT — Path to a PEM client certificate for the ClickHouse HTTPS connection

GitHub

⭐ 887 stars · 最近更新于 22 天前 · Apache-2.0 license

About this server

ClickHouse MCP Server / The server implements MCP 202…

Summary from the project README — github.com/ClickHouse/mcp-clickhouse

Distributed as Python, Docker, listed under Databases. Review our MCP security guide before granting access to real data.

Frequently asked questions

What does the ClickHouse MCP server do?

ClickHouse MCP Server / The server implements MCP 202

How do I install ClickHouse?

Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.

Is ClickHouse free to use?

The MCP server itself is free to install. The source is public on https://github.com/ClickHouse/mcp-clickhouse. Any third-party service it calls may require its own API key and account.

Which clients support ClickHouse?

Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.

Add this badge

Publish this server? Link back with a badge on your README or site — copy either snippet.

Markdown

[![Listed on MCPNav](https://mcpnav.net/badge/mcp-clickhouse.svg)](https://mcpnav.net/server/mcp-clickhouse/)

HTML

<a href="https://mcpnav.net/server/mcp-clickhouse/"><img src="https://mcpnav.net/badge/mcp-clickhouse.svg" alt="Listed on MCPNav" height="20"></a>