duckdb/duckdb Alternatives

Choose when you need a distributed server-based columnar store with real-time ingestion.

ClickHouse® is a real-time analytics database management system

Choose when you need a distributed real-time analytics database with hybrid search.

Apache Doris is a real-time analytics and hybrid search database for AI agents.

Choose when you need a high-performance distributed query engine for lakehouse analytics.

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.

Choose when you want analytics and search inside an existing Postgres service.

One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.

Choose when you need a distributed SQL database for near-real-time analytics on large datasets.

CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.

Choose when you need real-time analytics directly on Postgres tables without a separate engine.

Real-time analytics on Postgres tables

Choose when you need a standalone real-time search analytics database rather than an embedded engine.

The First Real-Time Search Analytics Database

Choose when you need a Java OLAP server with MDX for BI.

Mondrian is an Online Analytical Processing (OLAP) server that enables business users to analyze large quantities of data in real-time.

Choose when you need a MySQL-compatible HTAP database with real-time analytics.

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave.

Choose for learning how an OLAP database works, not for production use.

An educational OLAP database system.

Choose for simple experimental in-process file queries where DuckDB's maturity is unnecessary.

An experimental embedded SQL engine in C++20. Query Parquet, CSV, JSON, Arrow, Avro, SQLite, and Excel files directly with SQL, in-process. Early-stage.