ClickHouse
Planned
ClickHouse support is on our roadmap. Contact us if this is a priority for your team.
Overview
ClickHouse is an open-source columnar OLAP database designed for real-time analytical queries. It excels at aggregations over billions of rows with sub-second response times.
┌─────────────────┐ ┌──────────────────┐
│ GradientHarbor │────▶│ ClickHouse │
│ │ SQL │ │
│ AI Agent │◀────│ Columnar OLAP │
│ Dashboards │ │ (MergeTree) │
└─────────────────┘ └──────────────────┘Why ClickHouse
- Extreme speed — Billions of rows aggregated in milliseconds
- Columnar storage — Only scans columns referenced in queries
- Compression — 10-40x data compression reduces storage costs
- Real-time ingestion — Handles high-throughput INSERT with analytical queries simultaneously
- Open source — Self-hosted or managed via ClickHouse Cloud
Ideal Use Cases
- Event analytics — Clickstream, product analytics, user behavior
- Log analysis — Application logs, access logs, infrastructure metrics
- Time-series — IoT sensor data, financial market data
- Real-time dashboards — Sub-second aggregations for live monitoring