The ClickHouse Best Practices skill transforms Claude into a specialized database administrator for high-performance OLAP workloads. It utilizes a prioritized framework of 28 atomic rules to guide schema creation, query optimization, and data ingestion strategies. By focusing on ClickHouse-specific mechanics like columnar storage, sparse indexes, and MergeTree engines, this skill ensures that database designs are performant, scalable, and compliant with industry standards. It is particularly useful for developers looking to optimize JOIN performance, minimize storage bitwidth, and manage complex cluster configurations with Kubernetes or distributed tables.
Key Features
01Data ingestion strategy patterns for high-frequency batching and async inserts
022 GitHub stars
03Deep-dive references for Kubernetes Operator and cluster management
04Validated citations from official ClickHouse and Altinity documentation
05JOIN algorithm optimization and query filter alignment guidance
06Rule-based schema reviews for optimal Primary Key and Data Type selection
Use Cases
01Troubleshooting slow analytical queries and optimizing complex JOIN performance
02Validating CREATE TABLE statements for optimal sorting, partitioning, and compression
03Designing high-throughput data ingestion pipelines to avoid 'Too Many Parts' errors
