altinity-expert-clickhouse-index-analysis
OfficialOptimize ClickHouse index usage for queries.
Data & Analytics#query-optimization#clickhouse#projections#index-analysis#order-by#primary-key#data-skipping-index
AuthorAltinity
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Analyzes how ClickHouse indexes (PRIMARY KEY, ORDER BY, skipping indices, projections) are used in real workloads and identifies misalignments between query patterns and index design to reduce data scanned and improve performance.
Core Features & Use Cases
- Inspect PRIMARY KEY, ORDER BY, skip indices, and projections to guide index redesigns.
- Compare current index usage against actual query patterns to surface inefficiencies.
- Use in performance tuning to understand why queries read excessive data and how to align indexes with common filters.
Quick Start
Analyze a representative workload to reveal under- and over-utilized indexes and suggest concrete improvements.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: altinity-expert-clickhouse-index-analysis Download link: https://github.com/Altinity/Skills/archive/main.zip#altinity-expert-clickhouse-index-analysis Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.