Best Open-source Data Warehouse & OLAP Databases tools

chDB

In-process SQL OLAP engine powered by ClickHouse

Apache Doris

High-performance real-time analytical database with MPP architecture

YTsaurus

Scalable, fault-tolerant platform for big-data storage and processing

StarRocks

Sub-second ad-hoc analytics across data lakes and warehouses

Databend

AI-native multimodal data warehouse with Snowflake-compatible SQL

DuckDB

High-performance in-process analytical SQL database for fast queries

OceanBase

Distributed relational database delivering high‑availability, linear scalability, and vector search.

LakeSoul

Cloud-native lakehouse with ACID transactions and streaming upserts

ByConity

Cloud-native data warehouse with compute-storage separation for large-scale analytics

BemiDB

Postgres-compatible analytical database with built-in data sync connectors