clickhouse-architecture-advisor
Architecture design guidelines and decision frameworks for ClickHouse.
Developer Setup
Setup & Installation
npx skills add https://github.com/ClickHouse/agent-skills --skill clickhouse-architecture-advisornpx skills add https://github.com/ClickHouse/agent-skills --skill clickhouse-architecture-advisorOverview
What This Skill Does
Provides decision frameworks and structural guidelines for sorting keys, table engines, materialized views, and partition strategies.
Application
When to use this Skill
- Designing robust ClickHouse schema architectures for high-throughput pipelines.
- Selecting optimal partition keys, primary keys, and sorting indexes.
- Deciding between MergeTree variants (Replacing, Collapsing, Summing) for data modeling.
- Architecting real-time streaming architectures using materialized views.
- Evaluating cluster topologies and replica/shard distribution strategies.
Documentation
Show Skills.md file
ClickHouse Architecture Advisor
This skill adds workload-aware architecture decisioning on top of clickhouse-best-practices.
Official docs remain the source of truth. This skill must always prefer official ClickHouse documentation when available.
Required behavior
Before producing recommendations:
- Identify the workload shape
- observability
- security / SIEM
- product analytics
- IoT / telemetry
- market data / financial services
- mixed OLAP with point-lookups
- Read the relevant decision rule files in
rules/ - Use
mappings/doc_links.yamlto attach official documentation - Classify every recommendation as:
officialderivedfield
- Never present field guidance as official guidance
Recommendations
Explore other random skills
web-artifacts-builder
Suite of tools for creating elaborate, multi-component claude.ai HTML artifacts using modern frontend web technologies (React, Tailwind CSS, shadcn/ui). Use for complex artifacts requiring state management, routing, or shadcn/ui components - not for simple single-file HTML/JSX artifacts.
webapp-testing
Toolkit for interacting with and testing local web applications using Playwright. Supports verifying frontend functionality, debugging UI behavior, capturing browser screenshots, and viewing browser logs.
xlsx
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like \"the xlsx in my downloads\") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.