DuckDB
The warehouse you did not need — analytics in a single file, on your laptop.
97
sovereigntyDuckDB is an in-process analytical database: no server, no cluster, no account. It queries Parquet and CSV directly, runs inside Python or R, and handles hundreds of gigabytes on a normal machine. MIT, around 40k stars. Its real contribution is the uncomfortable question it poses to this whole category — a very large number of Snowflake deployments hold data that DuckDB would answer instantly, for nothing, without anyone provisioning a warehouse. Ask how much data you actually have before you shop for infrastructure to hold it.
OPEN SOURCEMITSELF-HOSTLOCAL-FIRST
LicenseMIT
PricingFree and open source. No server, so no hosting cost either.
Open sourceYes
Self-hostableYes
Local-first dataYes
What it does well
- +No infrastructure at all — it is a library, not a service
- +Queries Parquet and CSV in place with no loading step
- +Handles hundreds of gigabytes on ordinary hardware
- +MIT, tiny, and embeds anywhere
Where it falls short
- −Single-machine — there is no cluster and no horizontal scale
- −Not built for many concurrent users
- −No built-in governance, access control or sharing
- −Wrong tool once you genuinely have warehouse-scale data
DuckDB as an alternative to
Where DuckDB shows up in our comparisons, and how it ranked.
DuckDB head-to-head
Straight comparisons against the tools people weigh it against.