ClickHouse

io.github.ClickHouse/mcp-clickhouse

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

View repository →Homepage →

Connect this server

Add this to your MCP client config — claude_desktop_config.json (Claude Desktop) or .cursor/mcp.json (Cursor).Suits: Claude Desktop · Cursor.

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
        "CLICKHOUSE_ALLOW_DROP": "false",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "30",
        "CLICKHOUSE_MCP_MAX_WORKERS": "10"
      }
    }
  }
}
Environment variables
  • CLICKHOUSE_HOSTrequiredHostname of the ClickHouse server
  • CLICKHOUSE_USERrequiredUsername for ClickHouse authentication
  • CLICKHOUSE_PASSWORDsecretPassword for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode
  • CLICKHOUSE_SECUREUse HTTPS to connect to ClickHouse
  • CLICKHOUSE_VERIFYVerify SSL certificates
  • CLICKHOUSE_ALLOW_WRITE_ACCESSAllow write operations (DDL and DML). Queries run read-only by default
  • CLICKHOUSE_ALLOW_DROPAllow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled
  • CLICKHOUSE_MCP_QUERY_TIMEOUTQuery tool timeout in seconds
  • CLICKHOUSE_MCP_MAX_WORKERSMaximum query worker thread pool size

A starting point — check the repository for exact arguments and setup. Restart your client after editing the config.

Category
Developer Tools
Version
0.7.0
Registry
active
Published
9/21/2026

More Developer Tools servers

Browse all Developer Tools →

io.github.clicksprotocol/mcp-server

clicks-protocol

Agent commerce settlement tools on Base: treasury setup, payment splits, yield and attribution.

Developer ToolsAdded 3 months ago

io.github.Cliftonz/tandoor-recipe-mcp

Cliftonz

Recipes, meal plans, shopping lists and more for your local or self-hosted Tandoor instance.

Developer ToolsAdded 3 days ago

Clipform

clipform

Interactive video forms that capture authentic responses. Build engaging forms in minutes.

Developer ToolsAdded 4 days ago

Clipia

clipia-ai

Generate AI images, video, speech, music and presentations from Claude, ChatGPT and Cursor.

Developer ToolsAdded 4 weeks ago

Cliptude

cliptude

Make 6–60 minute faceless YouTube documentaries: voiceover, footage, maps and charts.

Developer ToolsAdded 5 days ago

ClipUGC

clipugc

UGC videos for your app with AI influencers who keep the same face. Hosted (OAuth) or local.

Developer ToolsAdded 4 weeks ago

Add the badge to your site

Show visitors that ClickHouse is listed here — it’s also the link we check for a free listing.

ClickHouse — listed on Serverdex

HTML — for your website

<a href="https://serverdex.io/server/io-github-clickhouse-mcp-clickhouse?utm_source=badge"><img src="https://serverdex.io/brand/badge.svg" alt="ClickHouse — listed on Serverdex" width="123" height="40" loading="lazy"></a>

Recommended. A dofollow link from your own domain is the one that counts for search engines, and it's the link we check for a free listing.

Markdown — for your README

[![ClickHouse — listed on Serverdex](https://serverdex.io/brand/badge.svg)](https://serverdex.io/server/io-github-clickhouse-mcp-clickhouse?utm_source=badge)

Nice for visibility, but GitHub marks README links nofollow, so it doesn't pass authority. Use the HTML badge on your site as well.