Skills
.Work. You
Rest

clickhouse-development

Community

Design robust schemas for fast analytics.

Data & Analytics#analytics#partitioning#query-optimization#schema-design#clickhouse#upsert
Authormatt-metivier
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Designers and engineers often struggle to implement scalable ClickHouse schemas, deduplication strategies, and performant query patterns in analytics workloads. This Skill provides a structured approach to schema design, engine choice (ReplacingMergeTree vs MergeTree), partitioning, TTL, and common optimization techniques, with concrete examples.

Core Features & Use Cases

  • Schema design guidance for ClickHouse tables using ReplacingMergeTree (upserts) and MergeTree (append-only data) with recommended ORDER BY and PARTITION BY patterns.
  • TypeScript client usage patterns to ensure safe, parameterized queries and efficient data retrieval.
  • Real-world examples showcasing end-to-end analytics workflows, including migration and optimization patterns for large datasets.

Quick Start

Design a scalable ClickHouse schema for a new analytics dataset, selecting the appropriate engine, keys, and optimization features.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: clickhouse-development
Download link: https://github.com/matt-metivier/zk-hub/archive/main.zip#clickhouse-development

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.