InnerVault

ClickHouse

Stale Official MCP Registry, io.github.ClickHouse

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

Open the source (opens github.com) https://github.com/clickhouse/mcp-clickhouse

Before you use it

  • Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
  • Needs credentials: CLICKHOUSE_PASSWORD. Use a key with the least access you can.

What it is

MCP servers from io.github.ClickHouse.

The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.

How to get it

pypi package (stdio)

mcp-clickhouse@0.7.0

From the server's entry in the official MCP Registry

oci package (stdio)

ghcr.io/clickhouse/mcp-clickhouse:0.7.0

From the server's entry in the official MCP Registry

Settings it asks for

  • 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
  • CLICKHOUSE_CLIENT_CERT_KEY · Path to the PEM private key for CLICKHOUSE_CLIENT_CERT
  • CLICKHOUSE_TLS_MODE · Client certificate mode: mutual, proxy, or strict
  • CLICKHOUSE_DATABASE · Default database to use
  • CLICKHOUSE_ROLE · ClickHouse role to activate for the session

Related

  1. DataOps ClickHouse MCP server with query optimization and pipeline monitoring

    Stale Official MCP Registry, io.github.Aguantar Updated 8 months ago 2 notes

    clickhouse-dataops-mcp@0.1.1
  2. ClickHouse

    MCP servers

    Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.

    Stale Official MCP Registry, io.github.alyiox Updated 57 days ago 2 notes

    mcp-clickhousex@0.11.0
  3. nightingale

    MCP servers

    Open-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.

    Indexed GitHub, ccfos 13.5k ★Apache-2.0Updated today

    git clone https://github.com/ccfos/nightingale.git
  4. mcp-clickhouse

    MCP servers

    ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.

    Stale Official MCP Registry, io.github.dockndevai Updated 48 days ago 2 notes

    @dockndevai/mcp-clickhouse@0.3.0
  5. mcp-clickhouse

    MCP servers

    Read-only ClickHouse for AI agents — analytics queries, table inspection, sizes, health.

    Stale Official MCP Registry, io.github.infoinlet-marketplace Updated 5 months ago 1 note

    @infoinlet/mcp-clickhouse@0.1.1
  6. hypequery ClickHouse

    MCP servers

    Governed ClickHouse analytics for agents: named datasets and metrics as tools, never raw SQL.

    Indexed Official MCP Registry, io.github.hypequery Updated yesterday 1 note

    @hypequery/mcp@0.14.0