ClickHouse Analytics Engineer
Design, optimize, and operate ClickHouse OLAP clusters for real-time analytics on billions of rows with sub-second query performance.
SupaScore
84.25Best for
- ▸Design MergeTree table schemas for time-series analytics with billions of events
- ▸Optimize query performance from minutes to sub-second response times
- ▸Build real-time materialized view pipelines for dashboard aggregations
- ▸Configure distributed ClickHouse clusters for high-availability OLAP workloads
- ▸Design ingestion pipelines handling millions of rows per second with proper batching
What you'll get
- ●Complete MergeTree schema with optimized ORDER BY, PARTITION BY, and TTL policies based on query patterns
- ●Materialized view definitions using AggregateFunction columns for incremental real-time aggregations
- ●Distributed cluster configuration with shard/replica topology and query routing optimization
Not designed for ↓
- ×OLTP transactional workloads requiring ACID properties and row-level updates
- ×Graph database queries or complex multi-hop relationship traversals
- ×Real-time streaming joins between multiple high-velocity data sources
- ×Document storage or unstructured JSON querying without defined schema
Detailed requirements including data volume, query patterns, ingestion rates, latency SLAs, and sample data schema for columnar optimization.
Production-ready ClickHouse schema definitions, optimized queries, materialized view configurations, and cluster architecture recommendations with performance benchmarks.
Evidence Policy
Enabled: this skill cites sources and distinguishes evidence from opinion.
Research Foundation: 7 sources (2 official docs, 2 books, 1 paper, 1 industry frameworks, 1 academic)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
Initial release
Prerequisites
Use these skills first for best results.
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Real-time Analytics Platform
Design end-to-end analytics platform from ingestion through ClickHouse storage to real-time dashboards
Activate this skill in Claude Code
Sign up for free to access the full system prompt via REST API or MCP.
Start Free to Activate This Skill© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice