duckdbduckdb
DuckDB is an analytical in-process SQL database management system
TL;DR · 30-second scan
duckdb (C++) — DuckDB is an analytical in-process SQL database management system
You need fast SQL on flat files, embedded analytics in an app, or local data exploration without infra.
Analytics · Database & ORM
The in-process OLAP engine that replaced "spin up a warehouse" for 80% of analytics work. SQL over Parquet/CSV/JSON without a server. ~22k stars. Reads from S3, runs in WASM, plugs into Python/Node/R. The tradeoff is single-node — once your hot data passes ~500GB you outgrow it. But for dashboards, embedded analytics, and ad-hoc reporting up to that scale, nothing else comes close on price/perf.
You need fast SQL on flat files, embedded analytics in an app, or local data exploration without infra.
You need multi-node concurrent writes or sub-millisecond OLTP — that's Postgres or ClickHouse territory.
Add this badge to your README to show your project is curated on StackPicks. Free, lightweight (180×28 SVG), and gives your visitors a one-click way to see honest take + alternatives.
[](https://stackpicks.dev/repo/duckdb-duckdb)
<a href="https://stackpicks.dev/repo/duckdb-duckdb"><img src="https://stackpicks.dev/api/badge/duckdb-duckdb" alt="Featured on StackPicks" width="180" height="28" /></a>
Are you the maintainer of duckdb/duckdb? Add the badge and we'll feature your project in the weekly curator newsletter.