Skip to content

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