How to connect ClickHouse MCP to Claude

Permanently delete a dashboard by ID.

Permanently delete a data source by ID.

Permanently delete a webhook by ID.

DRILL-DOWN: Use after clickstack_list_metrics (or after a clickstack_describe_source sample) to get attribute keys, sampled values, unit, and description for a specific (metricName, kind) pair.

CALL THIS BEFORE WRITING QUERIES — prevents unknown-column errors.

Detect what is NEW or GONE between an earlier baseline window and a current window — log/event patterns that emerged, ramped up, or stopped.

Rank the properties of two row groups (logs or trace spans) by how much their value distributions differ.

Discover the most common log messages and event patterns.

Without an ID: list all alerts as a high-level summary (id, name, state, source, interval).

Without an ID: list all dashboards (returns IDs, names, tags).

Retrieve a single tile from a dashboard by tileId.

Without an ID: list all saved searches as a high-level summary (id, name, tags).

List the available values for the required source filter columns on a single source.

List available webhook destinations (id, name, service type).

DISCOVERY: Use this after clickstack_describe_source when you need more metric names than the per-kind sample shows, or when you want to narrow by kind / name pattern / time window.

List all data sources (logs, metrics, traces) and database connections available to this team.

List all teams the current user belongs to and identify which team is active for this session.

Make targeted updates to a dashboard without resubmitting the full object.

Execute the query for a specific tile on an existing dashboard.

Run the queries for many tiles of a dashboard in ONE call and return a compact per-tile success/failure summary.

Create a new alert (omit id) or update an existing one (provide id).

Create a new dashboard (omit id) or update an existing one (provide id).

Create a new saved search (omit id) or update an existing one (provide id).

Create a new data source (omit id) or update an existing one (provide id) so shipped telemetry becomes queryable.

Create a new webhook (omit id) or update an existing one (provide id).

Browse individual log/event/trace rows.

Search dashboards by name and/or tags.

Execute raw ClickHouse SQL.

Compute aggregated metrics as a table, single number, pie chart, or bar chart.

Plot metrics over time as a line or stacked bar chart.

Given a parent-span filter and a time window, return the child operations contributing the most cumulative time across all traces matching the parent filter.

Fetch all spans in ONE trace and return them as a parent/child waterfall, pre-ordered for human-readable display.