← back

category

Analytical databases

Columnar SQL engines for analytics over large datasets.

Side by side

Analytical databases
ToolStarsLicenceTermsSelf-hostedLanguageLatestLast push
ClickHouse50kApache-2.0Open sourceYesC++v26.8.19.9-lts2026-10-06
DuckDB42kMITOpen sourceYesC++v1.5.62026-10-06
Presto17kApache-2.0Open sourceYesJava0.2992026-10-06
Apache Doris16kApache-2.0Open sourceYesJava4.1.4.12026-10-05
Apache Druid14kApache-2.0Open sourceYesJavadruid-38.0.02026-10-06
Trino13kApache-2.0Open sourceYesJava4832026-10-06
StarRocks12kApache-2.0Open sourceYesJava4.1.32026-10-06
Databend9.5kOtherOpen coreYesRustv1.2.8812026-10-06
Apache Pinot6.2kApache-2.0Open sourceYesJavarelease-1.5.12026-10-06
Apache Kylin3.8kApache-2.0Open sourceYesJavakylin-5.0.22026-10-06
pg_duckdb3.3kMITOpen sourceYesC++v1.1.12026-07-17
chDB2.9kApache-2.0Open sourceYesPythonv4.4.02026-10-02
Apache Cloudberry1.4kApache-2.0Open sourceYesC2.1.0-incubating2026-10-06

13 tools

DuckDB

DuckDB is an analytical in-process SQL database management system

Language
C++
Licence
MIT
Stars
42k
Latest
v1.5.6
Last push
2026-10-06
Presto

The official home of the Presto distributed SQL query engine for big data

Language
Java
Licence
Apache-2.0
Stars
17k
Latest
0.299
Last push
2026-10-06
Trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

Language
Java
Licence
Apache-2.0
Stars
13k
Latest
483
Last push
2026-10-06
StarRocks

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.

Language
Java
Licence
Apache-2.0
Stars
12k
Latest
4.1.3
Last push
2026-10-06
Databend

Data Agent Ready Warehouse : One for Analytics, Search, AI, Python Sandbox. — rebuilt from scratch. Unified architecture on your S3.

Language
Rust
Licence
Other
Stars
9.5k
Latest
v1.2.881
Last push
2026-10-06
pg_duckdb

DuckDB-powered Postgres for high performance apps & analytics.

Language
C++
Licence
MIT
Stars
3.3k
Latest
v1.1.1
Last push
2026-07-17
chDB

chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse

Language
Python
Licence
Apache-2.0
Stars
2.9k
Latest
v4.4.0
Last push
2026-10-02
Apache Cloudberry

One advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database.

Language
C
Licence
Apache-2.0
Stars
1.4k
Latest
2.1.0-incubating
Last push
2026-10-06

What these tools replace