altinity-expert-clickhouse-audit
Startup Procedure
Connectivity selection and setup is handled by the caller (upper prompt/orchestrator). Run a minimal preflight (e.g. select 1) and fail fast if connectivity is not OK.
Module Index
Complete module registry. This is the single source of truth for audit coverage.
| Module | Purpose | Triggers (Keywords) | Symptoms | Chains To |
|---|---|---|---|---|
| altinity-expert-clickhouse-overview | System health entry point, comprehensive audit | health check, audit, status, overview | General slowness, unclear issues | Route based on findings |
| altinity-expert-clickhouse-reporting | Query performance analysis | slow query, SELECT, performance, latency, timeout | High query duration, timeouts, excessive reads | memory, caches, schema |
| altinity-expert-clickhouse-ingestion | Insert performance diagnostics | slow insert, ingestion, batch size, new parts | Insert timeouts, part backlog growing | merges, storage, memory |
| altinity-expert-clickhouse-merges | Merge performance and part management | merge, parts, "too many parts", part count, backlog | High disk IO during merges, growing part counts | storage, schema, mutations |
| altinity-expert-clickhouse-mutations | ALTER UPDATE/DELETE tracking | mutation, ALTER UPDATE, ALTER DELETE, stuck | Mutations not completing, blocked mutations | merges, logs |
| altinity-expert-clickhouse-memory | RAM usage and OOM diagnostics | memory, OOM, MemoryTracker, RAM | Out of memory errors, high memory usage | merges, schema |
| altinity-expert-clickhouse-storage | Disk usage and compression | disk, storage, space, compression | Disk space issues, slow IO | - |
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