clickhouse

仓库创建 2026年6月30日最近提交 20 天前SkillHot 收录 20 天前

▸ 精选理由

适合做大规模时序/日志分析与高效聚合查询的专用指导。

这个 Skill 做什么

为 ClickHouse 提供架构设计、表引擎选择与查询优化建议。

专门用于 ClickHouse 的 OLAP 与事件分析场景，帮你做表结构设计、选择合适的表引擎（MergeTree 系列等）、编写高效聚合和窗口查询，以及配置物化视图、分片和副本策略。会给出索引、预聚合和查询重写的实战建议，旨在把慢查询加速并优化存储与计算成本。

▸ 展开 SKILL.md 英文原文

Use when the project uses ClickHouse — OLAP analytics, event ingestion, time-series, log storage, table engines, materialized views, sharding/replication, slow analytic queries.

数据与抓取ClickHouseOLAP表引擎查询优化通用

Stars

Forks

仓库内 Skill

7 日增星

安装 / 使用

给你的 Agent 一句话（通用）

帮我安装这个 skill：https://raw.githubusercontent.com/muxammadmamajonov/dot-claude/main/.claude/skills/clickhouse/SKILL.md

或 curl 直取 SKILL.md

curl -fsSL "https://raw.githubusercontent.com/muxammadmamajonov/dot-claude/main/.claude/skills/clickhouse/SKILL.md"

SKILL.MD 节选查看完整文件 ↗

# ClickHouse Skill

## When to use

- Designing ClickHouse schemas for event streams, log pipelines, or analytical dashboards
- Choosing the right table engine (MergeTree family, ReplacingMergeTree, AggregatingMergeTree, CollapsingMergeTree, Distributed)
- Writing efficient OLAP queries (aggregations, window functions, array operations)
- Setting up materialized views for pre-aggregation
- Configuring replication with ClickHouse Keeper or ZooKeeper
- Ingesting data from Kafka, S3, HTTP, or other ClickHouse engines
- Diagnosing slow queries via `EXPLAIN`, `system.query_log`, and `system.parts`

---

## Workflow

1. **Define the query patterns first** — ClickHouse schema design is query-driven

via SKILL·HOT · 数据来自 GitHub 公开信息 · 原文版权归作者所有