ClickHouse® is a real-time analytics database management system
Columnar SQL analytics on your own servers or object storage.
- Language
- C++
- Licence
- Apache-2.0
- Stars
- 50k
- Latest
- v26.8.19.9-lts
- Last push
- 2026-10-06
alternatives to
Hosted data warehouse with separate storage and compute. A closed product from Snowflake.
| Tool | Fit | Stars | Licence | Terms | Self-hosted | Language | Latest | Last push |
|---|---|---|---|---|---|---|---|---|
| ClickHouse | Full replacement | 50k | Apache-2.0 | Open source | Yes | C++ | v26.8.19.9-lts | 2026-10-06 |
| Apache Doris | Full replacement | 16k | Apache-2.0 | Open source | Yes | Java | 4.1.4.1 | 2026-10-05 |
| StarRocks | Full replacement | 12k | Apache-2.0 | Open source | Yes | Java | 4.1.3 | 2026-10-06 |
| Databend | Full replacement | 9.5k | Other | Open core | Yes | Rust | v1.2.881 | 2026-10-06 |
| DuckDB | Partial | 42k | MIT | Open source | Yes | C++ | v1.5.6 | 2026-10-06 |
5 alternatives
ClickHouse® is a real-time analytics database management system
Columnar SQL analytics on your own servers or object storage.
Apache Doris is a real-time analytics and hybrid search database for AI agents.
MPP analytical database with a MySQL-compatible protocol and lakehouse queries.
The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
MPP analytics on local or lake data, with a MySQL-compatible protocol.
Data Agent Ready Warehouse : One for Analytics, Search, AI, Python Sandbox. — rebuilt from scratch. Unified architecture on your S3.
A warehouse on object storage with compute separated from storage, on your own servers.
DuckDB is an analytical in-process SQL database management system
In-process analytical SQL over local files, Parquet and object storage, on one machine.