Work with ClickHouse: merge tree engines, materialized views, batch inserts, partitioning strategies, and query optimization for analytical workloads.
When to use this skill
- Setting up a ClickHouse table
- Creating a materialized view
- Optimizing an analytical query
Core concepts
This skill provides guidance on clickhouse patterns best practices, patterns, and common pitfalls. It is designed to be loaded on demand when a relevant task is detected.
Installation
curl -LO https://opencode-skills.example/downloads/databases/clickhouse-patterns.zip
unzip clickhouse-patterns.zip -d ~/.config/opencode/skills/Restart OpenCode — the skill loads automatically.
When it triggers
- setting up a ClickHouse table
- creating a materialized view
- optimizing an analytical query