avbbc Submit a tool

ClickHouse MCP

Runs SQL against a ClickHouse database with a read-only user: table listing, schema inspection, and query execution. The natural fit is event data where an agent can answer a specific question with one aggregation.…

Community stdio Verified 2026-11-12 databaseanalyticssqldata

Use it for

Analytical questions over event data that is already in ClickHouse

Skip it if

Ad-hoc writes or DDL — reads only, with a row limit

What it is

Runs SQL against a ClickHouse database with a read-only user: table listing, schema inspection, and query execution. The natural fit is event data where an agent can answer a specific question with one aggregation. A `LIMIT` in the prompt is not a cost control; the read-only user and the cluster quotas are.

Install

Terminal
uvx clickhouse-mcp

Client configuration

Paste this into your MCP client config, then restart the client.

MCP client config (JSON)
{
  "mcpServers": {
    "avbbc": {
      "command": "npx",
      "args": ["-y", "uvx clickhouse-mcp"]
    }
  }
}

Overlapping servers

All servers
  • 01
    PostHog MCPOfficial

    Queries PostHog for events, funnels, and cohorts through a project-scoped API key. The useful pattern is a question translated into one existing query, not free expl…

    #analytics#product#data
    TypeScriptstdio
  • 02
    Amplitude MCPCommunity

    Reads Amplitude charts and cohort data through the dashboard API: event segmentation, funnel results, and retention curves. It is a reporting interface rather than a…

    #analytics#product#retention
    TypeScriptstdio
  • 03
    DuckDB MCPCommunity

    Opens a local DuckDB database and exposes SQL over it, including files as views. That makes it the cheapest way to let an agent analyse a data dump on a laptop: no w…

    #database#analytics#local
    Pythonstdio

Tools that use this server

All tools

Skills built around it

All skills