altinity · Agent Skills
출처를 확인한 실질적인 문서가 있는 Skill 8개입니다. 카드를 열어 원문, 패키지 구성과 설치 방법을 확인하세요.
altinity-expert-clickhouse-caches
Analyzes the ClickHouse mark cache, uncompressed cache, query cache and compiled expression cache, their hit ratios and their RAM footprint. Use when cache hit ratios are poor, caches take too much RAM, mark counts look excessive, or cache sizing needs tuning.
- 1시간 설치 수
- 1
- GitHub Stars
- 17
- 업데이트
- 9월 17일
altinity-expert-clickhouse-index-analysis
Analyze whether ClickHouse indexes (PRIMARY KEY, ORDER BY, skipping indexes, projections) are effective for the actual query patterns. Use when investigating index effectiveness, ORDER BY key design, query-to-index alignment, or when queries scan far more data than expected.
- 1시간 설치 수
- 1
- GitHub Stars
- 17
- 업데이트
- 9월 17일
altinity-expert-clickhouse-ingestion
Diagnoses ClickHouse INSERT performance, batch sizing, part creation patterns and materialized-view overhead on inserts. Use for slow inserts, failed inserts, micro-batching, high part creation rate, Buffer table flushes and data pipeline issues.
- 1시간 설치 수
- 1
- GitHub Stars
- 17
- 업데이트
- 9월 17일
altinity-expert-clickhouse-kafka
Diagnose ClickHouse Kafka engine health, stuck consumers, thread pool capacity, consumer lag, slow materialized views, and Kafka rack-awareness or cross-AZ traffic. Use for Kafka lag, consumer errors, rebalances, thread starvation, or unexpected cross-AZ Kafka cost.
- 1시간 설치 수
- 1
- GitHub Stars
- 17
- 업데이트
- 9월 17일
altinity-expert-clickhouse-memory
Diagnoses ClickHouse RAM usage, memory limits, OOM errors and the allocation breakdown across queries, caches, dictionaries and primary keys. Use when MEMORYLIMITEXCEEDED appears, the server is killed by the OOM killer, memory grows steadily, or GROUP BY and JOIN queries run out of memory.
- 1시간 설치 수
- 1
- GitHub Stars
- 17
- 업데이트
- 9월 17일
altinity-expert-clickhouse-mutations
Diagnoses ClickHouse mutations - ALTER UPDATE, ALTER DELETE, MATERIALIZE and column changes. Use for stuck mutations, mutations that never finish, latestfailreason errors, growing mutation queues and slow ALTER operations.
- 1시간 설치 수
- 1
- GitHub Stars
- 17
- 업데이트
- 9월 17일
altinity-expert-clickhouse-part-log
Diagnoses part lifecycle problems from system.partlog - part creation, merges, mutations, downloads, removals and moves. Use when there are too many parts or micro-batch inserts, merge backlog or slow merges, mutation storms from ALTER UPDATE or DELETE, unusual DownloadPart replication churn, unexpected RemovePart spikes, or Keeper znode growth tied to part activity.
- 1시간 설치 수
- 1
- GitHub Stars
- 17
- 업데이트
- 9월 17일
altinity-expert-clickhouse-reporting
Diagnoses ClickHouse SELECT query performance, query patterns, slow queries, failures and optimization opportunities. Use for query latency, timeouts, high CPU queries, queries reading too much data and repeated expensive query patterns.
- 1시간 설치 수
- 1
- GitHub Stars
- 17
- 업데이트
- 9월 17일
