Clickhouse System Queries

If you're running ClickHouse in production, you're already digging through system.query_log to find slow queries or diagnose cluster issues. This skill wraps that workflow with table-specific references and smart routing between search_query_log for lookups and execute_sql for time-bucketed aggregations. It enforces time bounds by default, inherits conversation context for date ranges, and handles the ProfileEvents map-versus-flattened-column mess so you don't have to remember which schema you're on. Right now it only covers system.query_log, but the pattern is clean enough that adding system.metrics or system.replicas would be straightforward. A solid operational companion if ClickHouse monitoring is part of your daily routine.

Install to Claude Code

npx -y skills add frankchen021/datastoria --skill clickhouse-system-queries --agent claude-code