DuckDB
In-process OLAP database
Databases / Data · OSS/MIT · 42.3k
Reviewed 2026-08-19 · last push 2026-10-20 · repo checked 2026-10-21
What's Good
Analytics queries run locally without a server. Parquet, CSV, and JSON import just works. The SQL dialect is comprehensive. Integration with Python and R is seamless.
The Catch
Not for OLTP workloads—it is analytics-focused. Single-node limits apply. Less ecosystem than traditional databases.
Verdict
Local analytics that just works.
Embed
Maintainer? Add the badge to your README. It is free, links to this review, and there is no paid version.
Markdown
[](https://stackgems.com/gems/duckdb)
HTML
<a href="https://stackgems.com/gems/duckdb"><img src="https://stackgems.com/badge/duckdb.svg" alt="DuckDB reviewed on Stack Gems" height="20"></a>
Related
Databases →- ClickHouseColumn-oriented database for analytics
- DuckLakeMIT lakehouse table format on SQL + Parquet — a DuckDB extension
- QuestDBApache-2.0 low-latency time-series database with SQL
- TrinoApache-2.0 distributed SQL query engine for data lakes
- DatabendApache-2.0 Rust cloud data warehouse on object storage