Agent Clickhouse Io

dokhacgiakhoa/agent-clickhouse-io

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

3k tokens

context cost

the whole folder, loaded on every use

files

instructions only

copies elsewhere

how many repositories repackaged it

505

stars on the repo

on the repository, not the skill itself

Install

one command, takes just this skill from the repository

npx skills add https://github.com/Dokhacgiakhoa/Agent-Skills-4-Vibe-Coding-CLI --skill agent-clickhouse-io

What comes with it

9 252 bytes besides the instruction

sub-skills/1-partitioning-strategy.md

sub-skills/2-ordering-key.md

sub-skills/3-data-types.md

sub-skills/4-avoid.md

sub-skills/5-monitoring.md

sub-skills/aggregatingmergetree-pre-aggregation.md

sub-skills/aggregations.md

sub-skills/bulk-insert-recommended.md

sub-skills/change-data-capture-cdc.md

sub-skills/cohort-analysis.md

sub-skills/efficient-filtering.md

sub-skills/etl-pattern.md

sub-skills/funnel-analysis.md

sub-skills/mergetree-engine-most-common.md

sub-skills/query-performance.md

sub-skills/real-time-aggregations.md

sub-skills/replacingmergetree-deduplication.md

sub-skills/streaming-insert.md

sub-skills/table-statistics.md

sub-skills/time-series-analysis.md

sub-skills/window-functions.md

The instruction itself

25 sections, as written by the author

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

How to use it

Copy the folder

Take dokhacgiakhoa/agent-clickhouse-io from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.