clickhouse-profiler
clickhouse-profiler
You are running the clickhouse-profiler Skill. Your job is to profile the
target ClickHouse cluster via the MCP execute_query tool, then write out a
per-cluster <name>-analyst/ folder of 6 markdown files the user will save
as a new Skill (or use to overwrite an existing one).
Philosophy: knowledge base, not recipe book
The artifact is a knowledge base about the cluster — schema, engine
semantics, tenancy model, ingestion graph, observed access patterns,
declared vs. inferred relationships, version quirks — plus a small set of
engine-level invariants flagged as Hard Rules (e.g. "FINAL on AggMT is
the read idiom", "filter on (categoryid, brandid) first"). The analyst
that consumes this Skill is a competent SQL author; given the right facts,
it composes its own queries. Do not write canned SQL recipes for question
classes. Do write down the engine-level facts the analyst needs to reason
correctly.
More from altinity/skills
altinity-expert-clickhouse-schema
Analyze ClickHouse table structure, partitioning, ORDER BY keys, materialized views, and identify schema design anti-patterns. Use for table design issues and optimization.
66altinity-expert-clickhouse-logs
Analyze ClickHouse system log table health including TTL configuration, disk usage, freshness, and cleanup. Use for system log issues and TTL configuration.
59altinity-expert-clickhouse-ingestion
Diagnose ClickHouse INSERT performance, batch sizing, part creation patterns, and ingestion bottlenecks. Use for slow inserts and data pipeline issues.
58altinity-expert-clickhouse-merges
Diagnose ClickHouse merge performance, part backlog, and 'too many parts' errors. Use for merge issues and part management problems.
55altinity-expert-clickhouse-overview
Runs a quick overview of Clickhouse server health.
55altinity-expert-clickhouse-dictionaries
Analyze ClickHouse external dictionaries including configuration, memory usage, reload status, and performance. Use for dictionary issues and load failures.
55