菜单
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Web取得の標準前処理レイヤー。URL・公式ドキュメント・ブログ・ニュース・OSSページを読むときは、原則として毎回このSkillでDefuddleを使い本文をMarkdown/JSON化してから読む。生HTMLのまま要約・分析・比較・レビューしない。トリガー例: URLを読む/Webページ要約/OSS調査/公式Doc確認/記事解析/競合サイト確認/Web一次情報確認。
Formal evaluation framework for Claude Code sessions implementing eval-driven development (EDD) principles.
Frontend development patterns for React, Next.js, state management, performance optimization, and UI best practices.
Example project-specific skill template. Use as a starting point when creating guidelines for your own projects.
Practical prompt patterns and techniques for effective Claude Code usage. Reference when crafting prompts, planning workflows, or debugging interactions.
Use this skill when the user explicitly asks for TDD or a tests-first workflow, or when developing a new feature with a test coverage requirement. Provides a structured red-green-refactor workflow with unit, integration, and E2E test guidance.
| name | clickhouse-io |
| description | ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. |
| when_to_use | Use when the user is modeling analytics tables, tuning ClickHouse queries, or building ingestion and reporting workflows on ClickHouse. |
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.