agent-clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
28
20%
Does it follow best practices?
Run evals on this skill
Adds up to 20 points to the overall score
View guide
Passed
No findings from the security scan
Fix and improve this skill with Tessl
tessl review fix ./.agent/skills/agent-clickhouse-io/SKILL.mdClickHouse Analytics Patterns
ClickHouse-specific patterns for high-performance analytics and data engineering.
Overview
ClickHouse is a column-oriented database management system (DBMS) for online analytical processing (OLAP). It's optimized for fast analytical queries on large datasets.
Key Features:
- Column-oriented storage
- Data compression
- Parallel query execution
- Distributed queries
- Real-time analytics
Table Design Patterns
🧠 Knowledge Modules (Fractal Skills)
1. MergeTree Engine (Most Common)
2. ReplacingMergeTree (Deduplication)
3. AggregatingMergeTree (Pre-aggregation)
4. Efficient Filtering
5. Aggregations
6. Window Functions
7. Bulk Insert (Recommended)
8. Streaming Insert
9. Real-time Aggregations
10. Query Performance
11. Table Statistics
12. Time Series Analysis
13. Funnel Analysis
14. Cohort Analysis
15. ETL Pattern
16. Change Data Capture (CDC)
17. 1. Partitioning Strategy
18. 2. Ordering Key
19. 3. Data Types
20. 4. Avoid
21. 5. Monitoring
- Repository
- Dokhacgiakhoa/antigravity-ide
- Commit
c4a059b
- Last updated
- First committed
Is this your skill?
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.