Learn Skills
EnglishEspañolFrançaisDeutsch简体中文繁體中文日本語한국어
·clickhouse-schema-design
{}

clickhouse-schema-design

✓
obsessiondb/clickhouse-plugin

15+ schema rules for ClickHouse tables. ALWAYS LOAD when creating or modifying tables. Achieves sub-second queries, 10x compression, and automated data lifecycle.

obsessiondb·clickhouse·schema·design
2Installs·0Trend·@obsessiondb

Installation

GitHub: obsessiondb/clickhouse-plugin
$npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-schema-design

SKILL.md

Search terms: schema design, ORDER BY, PRIMARY KEY, PARTITION BY, data types, TTL, indexgranularity

| MergeTree | Append-only data (events, logs) | Standard storage, no special merge logic | | ReplacingMergeTree | Deduplication, upserts | Keeps latest row per ORDER BY key; query with argMax pattern | | SummingMergeTree | Pre-aggregated counters | Automatically sums numeric columns on merge |

| AggregatingMergeTree | Complex aggregates (uniq, quantile) | Stores intermediate states; use -State/-Merge functions | | CollapsingMergeTree | Mutable rows | Uses +1/-1 sign column to cancel/update rows |

15+ schema rules for ClickHouse tables. ALWAYS LOAD when creating or modifying tables. Achieves sub-second queries, 10x compression, and automated data lifecycle. Source: obsessiondb/clickhouse-plugin.

View raw

Facts (cite-ready)

Stable fields and commands for AI/search citations.

Install command
npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-schema-design
Source
obsessiondb/clickhouse-plugin
Category
{}Data Analysis
Verified
✓
First Seen
2026-02-05
Updated
2026-02-18
URL
https://www.learn-skills.dev/en/skills/obsessiondb/clickhouse-plugin/clickhouse-schema-design

Quick answers

What is clickhouse-schema-design?

15+ schema rules for ClickHouse tables. ALWAYS LOAD when creating or modifying tables. Achieves sub-second queries, 10x compression, and automated data lifecycle. Source: obsessiondb/clickhouse-plugin.

How do I install clickhouse-schema-design?

Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-schema-design Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code or Cursor

Where is the source repository?

https://github.com/obsessiondb/clickhouse-plugin

Details

Category
{}Data Analysis
Source
skills.sh
First Seen
2026-02-05

Related Skills

None