AI agent skill · by @Dokhacgiakhoa

Agent Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Archived 2026-10-23 · Source updated 2026-06-11. Check the original repository for the latest version.

SKILL.md instructions

# 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)](./sub-skills/mergetree-engine-most-common.md)
### 2. [ReplacingMergeTree (Deduplication)](./sub-skills/replacingmergetree-deduplication.md)
### 3. [AggregatingMergeTree (Pre-aggregation)](./sub-skills/aggregatingmergetree-pre-aggregation.md)
### 4. [Efficient Filtering](./sub-skills/efficient-filtering.md)
### 5. [Aggregations](./sub-skills/aggregations.md)
### 6. [Window Functions](./sub-skills/window-functions.md)
### 7. [Bulk Insert (Recommended)](./sub-skills/bulk-insert-recommended.md)
### 8. [Streaming Insert](./sub-skills/streaming-insert.md)
### 9. [Real-time Aggregations](./sub-skills/real-time-aggregations.md)
### 10. [Query Performance](./sub-skills/query-performance.md)
### 11. [Table Statistics](./sub-skills/table-statistics.md)
### 12. [Time Series Analysis](./sub-skills/time-series-analysis.md)
### 13. [Funnel Analysis](./sub-skills/funnel-analysis.md)
### 14. [Cohort Analysis](./sub-skills/cohort-analysis.md)
### 15. [ETL Pattern](./sub-skills/etl-pattern.md)
### 16. [Change Data Capture (CDC)](./sub-skills/change-data-capture-cdc.md)
### 17. [1. Partitioning Strategy](./sub-skills/1-partitioning-strategy.md)
### 18. [2. Ordering Key](./sub-skills/2-ordering-key.md)
### 19. [3. Data Types](./sub-skills/3-data-types.md)
### 20. [4. Avoid](./sub-skills/4-avoid.md)
### 21. [5. Monitoring](./sub-skills/5-monitoring.md)