clickhouse-architect
✓ClickHouse schema design and optimization. TRIGGERS - ClickHouse schema, compression codecs, MergeTree, ORDER BY tuning, partition key.
Installation
SKILL.md
Prescriptive schema design, compression selection, and performance optimization for ClickHouse (v24.4+). Covers both ClickHouse Cloud (SharedMergeTree) and self-hosted (ReplicatedMergeTree) deployments.
The ORDER BY clause is the most critical decision in ClickHouse schema design.
| Column Type | Default Codec | Read-Heavy Alternative | Example |
ClickHouse schema design and optimization. TRIGGERS - ClickHouse schema, compression codecs, MergeTree, ORDER BY tuning, partition key. Source: terrylica/cc-skills.
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/terrylica/cc-skills --skill clickhouse-architect- Source
- terrylica/cc-skills
- Category
- </>Dev Tools
- Verified
- ✓
- First Seen
- 2026-02-04
- Updated
- 2026-02-18
Quick answers
What is clickhouse-architect?
ClickHouse schema design and optimization. TRIGGERS - ClickHouse schema, compression codecs, MergeTree, ORDER BY tuning, partition key. Source: terrylica/cc-skills.
How do I install clickhouse-architect?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/terrylica/cc-skills --skill clickhouse-architect 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/terrylica/cc-skills
Details
- Category
- </>Dev Tools
- Source
- skills.sh
- First Seen
- 2026-02-04