Build ClickHouse tables with sub-second queries, 10x compression, and zero full table scans.
npx skills add obsessiondb/clickhouse-skills| Skill | Rules | Trigger |
|---|---|---|
| clickhouse-schema-design | 15+ | Creating/modifying tables, ORDER BY, PARTITION BY, TTL |
| clickhouse-query-optimization | 20+ | Writing/debugging queries, slow queries, JOINs, memory errors |
| clickhouse-materialized-views | 10+ | Creating MVs, real-time aggregation, pre-aggregation |
Skills load automatically when relevant tasks are detected:
- Mention "CREATE TABLE" or "schema" → loads schema-design
- Mention "slow query", "JOIN", or "optimize" → loads query-optimization
- Mention "materialized view" or "MV" → loads materialized-views
Each skill contains a SKILL.md file with:
- Goals - Measurable outcomes (e.g., "10x compression")
- Critical Rules - Prioritized as CRITICAL, HIGH, MEDIUM
- Patterns - Good vs Bad code examples
- Troubleshooting - Common problems and solutions
Contributions welcome! See AGENTS.md for skill authoring guidelines.
MIT + Commons Clause (free to use, not for resale)
Sponsored by ObsessionDB — ClickHouse® infrastructure as a service that decouples processing from storage for high-volume event data.