altinity-expert-clickhouse-schema
CommunityDiagnose ClickHouse schemas for optimal design.
Authorntk148v
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Analyze ClickHouse table schemas to detect partitioning and design anti-patterns. This helps data teams optimize performance, reduce maintenance burden, and surface schema inefficiencies early.
Core Features & Use Cases
- Partition health audits to detect overly granular partitions and suggest reorganization for better performance and easier maintenance.
- Primary key and ORDER BY analysis to optimize data locality, compression, and query patterns.
- Materialized View (MV) design checks to ensure maintainable and efficient MV pipelines, including dependency clarity.
- Diagnostic queries and guidance to surface schema inefficiencies and actionable optimization recommendations.
Quick Start
Run the altinity-expert-clickhouse-schema audits against your MergeTree tables to surface design issues and optimization opportunities.
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-schema Download link: https://github.com/ntk148v/clicklens/archive/main.zip#altinity-expert-clickhouse-schema 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 471,000+ vetted skills library on demand.