name: agent-clickhouse-io description: ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. author: affaan-m version: 4.1.0-fractal
ClickHouse 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
Skills similaires
Ingénierie de Prompts
Data & IA
Bonnes pratiques et templates de prompt engineering pour maximiser les résultats IA.
claudeCursorWindsurf+1beginner
289
78
852
Visualisation de Données
Data & IA
Génère des visualisations de données et graphiques adaptés à vos données.
claudeCursorWindsurfintermediate
198
56
683
Architecture RAG
Data & IA
Guide de configuration d'architectures RAG (Retrieval-Augmented Generation).
claudeCursorWindsurfadvanced
167
51
645