ClickHouse
Open-source columnar database for real-time analytics
ClickHouse is profiled here as a Data Warehouse tool for engineering teams. Read about features, pricing, and how it compares to related options in the tools directory.
Description
ClickHouse is an open-source columnar OLAP database created by Alexey Milovidov at Yandex and spun into ClickHouse, Inc. in 2021. Vectorized execution over compressed columns returns aggregations across billions of rows in milliseconds, which is why observability platforms and LLM analytics products run on it. ClickHouse Cloud offers a serverless managed version, and ClickStack packages the database as a full observability stack. The company acquired HyperDX in 2025 and packaged the result as ClickStack, an open-source observability stack with logs, traces, and metrics on one database.
Key Capabilities:
Columnar storage with vectorized query execution
Real-time inserts with materialized views for continuous aggregation
SQL interface with extensive analytical functions
Integrations for Kafka, S3, Iceberg, and Postgres change data capture
Vector search functions for embedding workloads
Apache 2.0 license with ClickHouse Cloud as the managed option
Alternative tools
- Tinybird
Managed ClickHouse for building real-time analytics APIs
- Apache Druid
Real-time analytics database for sub-second queries
- Amazon Redshift
Cloud data warehouse for large-scale analytics on AWS
- Databricks
Lakehouse platform unifying data engineering and AI
- BigQuery
Serverless, petabyte-scale cloud data warehouse
- DuckDB
In-process analytical database for fast local queries