NestDaddy
All servers NestDaddy MCP Blog Sign inTry it free
Databases

ClickHouse

io.github.ClickHouse/mcp-clickhouse · v0.7.0

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

Website Source code Set it up

Connect Runs on your machine

Terminal
claude mcp add mcp-clickhouse -e CLICKHOUSE_HOST=<CLICKHOUSE_HOST> -e CLICKHOUSE_USER=<CLICKHOUSE_USER> -e CLICKHOUSE_PASSWORD=<CLICKHOUSE_PASSWORD> -e CLICKHOUSE_PORT=<CLICKHOUSE_PORT> -e CLICKHOUSE_SECURE=<CLICKHOUSE_SECURE> -e CLICKHOUSE_VERIFY=<CLICKHOUSE_VERIFY> -e CLICKHOUSE_CA_CERT=<CLICKHOUSE_CA_CERT> -e CLICKHOUSE_CLIENT_CERT=<CLICKHOUSE_CLIENT_CERT> -e CLICKHOUSE_CLIENT_CERT_KEY=<CLICKHOUSE_CLIENT_CERT_KEY> -e CLICKHOUSE_TLS_MODE=<CLICKHOUSE_TLS_MODE> -e CLICKHOUSE_DATABASE=<CLICKHOUSE_DATABASE> -e CLICKHOUSE_ROLE=<CLICKHOUSE_ROLE> -e CLICKHOUSE_ALLOW_WRITE_ACCESS=<CLICKHOUSE_ALLOW_WRITE_ACCESS> -e CLICKHOUSE_ALLOW_DROP=<CLICKHOUSE_ALLOW_DROP> -e CLICKHOUSE_MCP_QUERY_TIMEOUT=<CLICKHOUSE_MCP_QUERY_TIMEOUT> -e CLICKHOUSE_MCP_MAX_WORKERS=<CLICKHOUSE_MCP_MAX_WORKERS> -- uvx mcp-clickhouse==0.7.0
claude_desktop_config.json
{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "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>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "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>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mcp-clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "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>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

NameDescription
CLICKHOUSE_HOST
Required		Hostname of the ClickHouse server
CLICKHOUSE_USER
Required		Username for ClickHouse authentication
CLICKHOUSE_PASSWORD
Optional, secret		Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode
CLICKHOUSE_PORT
Optional		ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise
CLICKHOUSE_SECURE
Optional		Use HTTPS to connect to ClickHouse
CLICKHOUSE_VERIFY
Optional		Verify SSL certificates
CLICKHOUSE_CA_CERT
Optional		Path to a PEM CA bundle for ClickHouse server certificate verification
CLICKHOUSE_CLIENT_CERT
Optional		Path to a PEM client certificate for the ClickHouse HTTPS connection
CLICKHOUSE_CLIENT_CERT_KEY
Optional		Path to the PEM private key for CLICKHOUSE_CLIENT_CERT
CLICKHOUSE_TLS_MODE
Optional		Client certificate mode: mutual, proxy, or strict
CLICKHOUSE_DATABASE
Optional		Default database to use
CLICKHOUSE_ROLE
Optional		ClickHouse role to activate for the session
CLICKHOUSE_ALLOW_WRITE_ACCESS
Optional		Allow write operations (DDL and DML). Queries run read-only by default
CLICKHOUSE_ALLOW_DROP
Optional		Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled
CLICKHOUSE_MCP_QUERY_TIMEOUT
Optional		Query tool timeout in seconds
CLICKHOUSE_MCP_MAX_WORKERS
Optional		Maximum query worker thread pool size

Details

Package[email protected] (PYPI, stdio)
Packageghcr.io/clickhouse/mcp-clickhouse:0.7.0 (OCI, stdio)
First published21 Sep 2026
Last updated21 Sep 2026
Registry nameio.github.ClickHouse/mcp-clickhouse

More databases servers See all

  • VibeScale

    Pre-launch checks for AI-built apps: leaked keys, Supabase RLS gaps, browser-exposed env vars.

  • Imf Mcp Server

    Query IMF SDMX 3.0 macroeconomic dataflows — WEO, BOP, CPI, exchange rates, 190 countries.

  • Apex DB

    Vehicle specifications, emissions, and powertrain data with source provenance.

  • TrialBase DB

    Clinical trials across multiple registries with identifiers and source links.

  • PatchLabs

    Security checks for AI-built apps (Lovable, Supabase, Bolt): RLS, headers, monitoring, fixes.

  • Tidy Byte Tools API

    Remote MCP for JSON repair, hashing, formatting, IDs, dates, units, and other small tools.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.