ClickHouse MCP
Manage and query ClickHouse Cloud observability data through the managed ClickStack MCP server.
Uses your own API key. Composio asks for it once and keeps it; Quilt never sees it.
Reads on its own23
Agents use these right away.
- Clickstack describe metricDRILL-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.
- Clickstack describe sourceCALL THIS BEFORE WRITING QUERIES — prevents unknown-column errors.
- Clickstack emerging signalsDetect what is NEW or GONE between an earlier baseline window and a current window — log/event patterns that emerged, ramped up, or stopped.
- Clickstack event deltasRank the properties of two row groups (logs or trace spans) by how much their value distributions differ.
- Clickstack event patternsDiscover the most common log messages and event patterns.
- Clickstack get alertWithout an ID: list all alerts as a high-level summary (id, name, displayName, tags, state, source, interval).
- Clickstack get dashboardWithout an ID: list all dashboards (returns IDs, names, tags).
- Clickstack get dashboard tileRetrieve a single tile from a dashboard by tileId.
- Clickstack get saved searchWithout an ID: list all saved searches as a high-level summary (id, name, tags).
- Clickstack get source filter valuesList the available values for the required source filter columns on a single source.
- Clickstack get webhookList available webhook destinations (id, name, service type).
- Clickstack list metricsDISCOVERY: 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.
- Clickstack list sourcesList all data sources (logs, metrics, traces) and database connections available to this team.
- Clickstack list teamsList all teams the current user belongs to and identify which team is active for this session.
- Clickstack query tileExecute the query for a specific tile on an existing dashboard.
- Clickstack query tilesRun the queries for many tiles of a dashboard in ONE call and return a compact per-tile success/failure summary.
- Clickstack searchBrowse individual log/event/trace rows.
- Clickstack search dashboardsSearch dashboards by name and/or tags.
- Clickstack sqlExecute raw ClickHouse SQL.
- Clickstack tableCompute aggregated metrics as a table, single number, pie chart, or bar chart.
- Clickstack timeseriesPlot metrics over time as a line or stacked bar chart.
- Clickstack trace top time consuming operationsGiven a parent-span filter and a time window, return the child operations contributing the most cumulative time across all traces matching the parent filter.
- Clickstack trace waterfallFetch all spans in ONE trace and return them as a parent/child waterfall, pre-ordered for human-readable display.
Asks someone first9
Anything that sends, creates, changes or deletes waits for a person to approve it in the session’s chat.
- Clickstack delete dashboardPermanently delete a dashboard by ID.
- Clickstack delete sourcePermanently delete a data source by ID.
- Clickstack delete webhookPermanently delete a webhook by ID.
- Clickstack patch dashboardMake targeted updates to a dashboard without resubmitting the full object.
- Clickstack save alertCreate a new alert (omit id) or update an existing one (provide id).
- Clickstack save dashboardCreate a new dashboard (omit id) or update an existing one (provide id).
- Clickstack save saved searchCreate a new saved search (omit id) or update an existing one (provide id).
- Clickstack save sourceCreate a new data source (omit id) or update an existing one (provide id) so shipped telemetry becomes queryable.
- Clickstack save webhookCreate a new webhook (omit id) or update an existing one (provide id).