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
- Use "ClickHouse Patterns" with your Muse.
- 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:
Install
Copy the install package below, then paste it into MuseThe install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
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://github.com/affaan-m/ECC/blob/main/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.
Questions
How do I install a build?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the build 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 build before installing it.