clickhouse-io - ClickHouse database patterns and query optimization
Provides patterns for ClickHouse table design, query optimization, data ingestion, materialized views, and performance monitoring.
Tags
Updated: 2026-09-22Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Design ClickHouse table schemas
- Optimize analytical queries
- Ingest data in batches
- Create materialized views
- Monitor query performance
- Perform time series analytics
Inputs
- ClickHouse database credentials
- Analytical datasets
- SQL queries
Outputs
- Optimized SQL queries
- ClickHouse table schema definitions
- Query performance log metrics
- Materialized view definitions
Requirements
- ClickHouse database
- Node.js environment