ClickHouse Patterns
ClickHouse analytics patterns: MergeTree schema design, query optimization, partitioning, materialized views, and high-volume ingestion.
- What
- ClickHouse analytics patterns: MergeTree schema design, query optimization, partitioning, materialized views, and high-volume ingestion.
- Cost
- Free
- Needs
- a ClickHouse instance (or schemas/queries to write or review). Pure guidance skill, nothing to install.
- Level
- Beginner — a ClickHouse instance (or schemas/queries to write…
- Install
- Copy the installer prompt below into your Muse — your agent does the rest.
Curated by Skill Harbor: a patterns skill for high-performance analytics on ClickHouse, the column-oriented OLAP database. It covers MergeTree engine selection and table schema design, writing fast analytical queries (aggregations, window functions, joins), optimization techniques (partition pruning, projections, materialized views), ingesting large volumes (batch inserts, Kafka integration), migrating from PostgreSQL or MySQL to ClickHouse for analytics, and building real-time dashboards and time-series analytics. Concrete, ClickHouse-specific guidance rather than generic SQL advice. By @affaan-m, listed here with credit to its creator. From the affaan-m/ECC repository (MIT). Honest caveats: pure guidance, nothing to install; requires a ClickHouse instance for anything hands-on; OLAP only, this is not the skill for transactional (OLTP) workloads. Skill Harbor never reviews the code, review it yourself before use.
Version:
Quick answer
ClickHouse Patterns is a free Muse skill for high-performance analytics on ClickHouse, the column-oriented OLAP database. It covers MergeTree engine selection and table schema design, writing fast analytical queries with aggregations, window functions and joins, optimization through partition pruning, projections and materialized views, ingesting large volumes, and migrating from PostgreSQL or MySQL to ClickHouse.
Install
Copy the install package below, then paste it into Muse🧪 Install ran in our test sandbox · Nov 11, 2026📌 Pinned version: commit 4eb71d9Pinned version: install the code at commit 4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2 exactly (Skill Harbor tested this version). Do not substitute a newer version. If this commit is unreachable, stop and tell me. Use "ClickHouse Patterns" with your Muse. Prerequisites: a ClickHouse instance (or schemas/queries to write or review). Pure guidance skill, nothing to install. 1. Open the skill: https://raw.githubusercontent.com/affaan-m/ECC/4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2/skills/clickhouse-io/SKILL.md and copy the full SKILL.md text. 2. Paste it into a chat with Muse and add: "Review this table schema against these patterns: MergeTree engine choice, partition key, ordering key." 3. For a slow query, paste the query plus EXPLAIN output and ask: "Optimize this using partition pruning, projections, or a materialized view." Tip: include the table DDL with every query question; the optimization advice depends on the schema. Safety: a skill is plain-text instructions; it runs nothing by itself. Test schema changes on a non-production replica first.
Saved to your recent installs. Find it anytime on /connect.
🔒 Security, provenance and what this touches
The install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
Verification certificate
Dated facts about what was checked for this listing, and how. This is not a safety certification.
- Pinned version
- 4eb71d9 · 2026-10-13
- Sandbox install test
- Install ran in our test sandbox · Nov 11, 2026
- Creator identity
- Not verified
- Fingerprint watch
- Last checked · Nov 21, 2026 : no change detected in the files linked by this install prompt
- Install prompt analysis
- 2026-10-13 : No commands, network calls, packages, file writes or API keys detected.
Skill Harbor never reviews the code of a listed skill. These are dated facts about the install prompt and our install test, not a safety certification. Review a skill yourself before you install it. How we verify
Questions
How do I install a skill?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the skill up for you — no manual configuration.
Where does my money go?
Straight to the seller. Skill Harbor never processes payments: checkout happens on the seller’s own page, usually Stripe.
What does the ✓ next to a creator’s name mean?
It means we confirmed the identity of the person behind the listing. It says nothing about the code itself — always check a skill before installing it.