clickhouse-io - ClickHouse Analytics and Data Engineering Patterns
High-performance analytical query patterns and data engineering best practices for ClickHouse database
Tags
Updated: 2026-06-30Capabilities
Typical Inputs
Typical Outputs
What this skill does
- create tables
- insert data
- optimize queries
- stream inserts
- create views
- monitor performance
- aggregate data
- calculate windows
- filter results
- analyze time series
- execute funnels
- analyze cohorts
- build pipelines
- capture changes
Inputs
- ClickHouse database
- connection credentials
- raw data
- PostgreSQL database
- data source
Outputs
- query results
- materialized views
- performance metrics
- table statistics
- aggregated metrics
Requirements
- ClickHouse server
- Node.js runtime