ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
The English summary is being prepared. Showing the original description.
See how to installReview the instructions the agent will receive before you install.
ClickHouse is a column-oriented DBMS for OLAP, optimized for fast analytical queries on large datasets. Key strengths: columnar storage, compression, parallel execution, distributed queries, real-time analytics.
| File | Contents |
|---|---|
| references/table-design.md | MergeTree engine types, table creation patterns, partitioning, ordering keys, data type selection |
| references/query-optimization.md | Filtering best practices, aggregations, window functions, materialized views, performance monitoring |
| references/data-pipeline.md | Bulk/streaming insert, ETL/CDC patterns, time series, funnel, cohort, and retention query templates |
| Engine | Use When | Trade-off |
|---|---|---|
| MergeTree | Default for most tables | No dedup or pre-aggregation |
| ReplacingMergeTree | Data has duplicates from multiple sources | Dedup only on merge, not query time |
| AggregatingMergeTree | Pre-computed rollups (hourly/daily stats) | Requires *State/*Merge function pairs |
SELECT *ClickHouse excels at analytical workloads. Design tables for your query patterns, batch inserts, and leverage materialized views for real-time aggregations.
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.
The English summary is being prepared. Showing the original description.
日本語の業務文書を作成・修正するときに使用する共通品質基準。事実性、確度、論理、簡潔さ、自然な日本語を守る。提案書、報告、技術説明、議事録、メール、Slack、要約、レビューに適用する。創作、広告コピー、コードや構造化データだけの生成には使用しない。
The English summary is being prepared. Showing the original description.
Universal coding standards, best practices, and patterns for TypeScript, JavaScript, React, and Node.js development.
The English summary is being prepared. Showing the original description.
Formal evaluation framework for Claude Code sessions implementing eval-driven development (EDD) principles.
The English summary is being prepared. Showing the original description.
Frontend development patterns for React, Next.js, state management, performance optimization, and UI best practices.
The English summary is being prepared. Showing the original description.
Example project-specific skill template. Use as a starting point when creating guidelines for your own projects.
The English summary is being prepared. Showing the original description.