“DuckDB does the heavy lifting for dataset preparation. It lets us process and structure large API responses efficiently, so users get clean, query-ready datasets without the overhead of a heavier database.”
DatabaseMaker says so · source ↗
DuckDB
In-process analytical SQL database that queries CSV, Parquet, JSON and Iceberg files locally or in object storage, with no server.
12 makers' products we track use DuckDB. For database it's 13th most chosen of 23 options: 12 of the 1,263 makers' products we know the database of (1%). Among the 397 launched in 2026, 0% chose it, against 1% of those launched in 2024 or earlier. 54 open-source projects also declare it in their code.
Profile checked
Works with AI agents:llms.txtHow makers use DuckDB
Makers' products we track use DuckDB for database (12).
What DuckDB is used for
DuckDB vs the alternatives makers chose
For database, 12 of the 1,263 makers' products we know the choice of picked DuckDB (1%), behind Supabase (45%).
| Option | Makers' products | 2026 launches | Free for | At 10,000 users | Open source | |
|---|---|---|---|---|---|---|
| 573 45% | 63% | ~500 users | $25/mo · Pro | Yes | ||
| 187 15% | 9% | ~2,000 users | $9.66/mo · Blaze (pay as you go) | No | ||
| 128 10% | 5% | ~500 users | $58/mo · Atlas Dedicated M10 | No | ||
| 98 8% | 1% | — | — | Yes | ||
| 96 8% | 11% | None | $22/mo · Launch | Yes | ||
| 50 4% | 7% | ~630 users | $29/mo · Professional | Yes | ||
| 12 1% | 0% | — | — | Yes |
For database: how many of the 1,263 makers' products we know the database of chose each option, and the share among the 397 launched in 2026, since a tool that came first has products from every year, and what each costs at 10,000 users.
Costs are the cheapest plan that fits, from each vendor's pricing page, at the usage our stack planner assumes for a product with that many users. Free for: the users its cheapest plan a business can use stays free for.
Markets that build with it most
Product Hunt markets where DuckDB is in far more of the stacks we know than across every market (0%).
When to use DuckDB, and when not
Something else fits better if
- You want the database, auth and file storage in one project, and plain SQL you can take elsewhere: Supabase.
- You're building a live, collaborative app entirely in TypeScript: Convex.
- Your traffic is bursty or you run many preview deploys, and idle hours shouldn't cost much: Neon.
- You already run your own server and want a flat monthly cost: PostgreSQL.
How DuckDB itself is built
1 tools, from its own code, website and Product Hunt page.
DuckDB pros and cons
Themes that recur in makers' words and Hacker News comments, each linked to what it summarises, with how Product Hunt tags its reviews.
Pros
What Hacker News says about DuckDB
On Hacker News, 31% of comments about DuckDB recommend it and 5% criticize it: net praise +27%, 3rd best liked of 16 tools HN discusses for database.
By year
| Year | Comments choosing it, per month | Net praise |
|---|---|---|
| 2023 | 5.7 | +28% |
| 2024 | 5.4 | +8% |
| 2025 | 7.0 | +24% |
| 2026 (8 mo) | 10 | +48% |
In their words
- “major OSS projects(PG, Cassandra, RockDb, duckdb, ClickHouse, etc) have all/most important data structures and algorithms implemented and described way better.” HN, Aug 2026
- “We use DuckDB WASM with parquet to build dashboards in-browser. It's cool to be able to write SQL directly in a browser” HN, Aug 2026
- “At first we used duckdb but memory became an issue there” HN, May 2024
Hacker News comments January 2023 to August 2026 that name DuckDB in a sentence like "I use" or "we moved to", Claude read a sample of 100 and the counts scale it to all of them; net praise is comments recommending it minus comments criticizing it, as a share of all comments about it. How it's counted, and how HN compares with makers.
Reliability and open issues
The most wanted open issue on GitHub has 26 👍.
Most wanted on GitHub
- [Feature Request] Context Managers in Python API👍 26 · opened Feb 2022 · active Mar 2026
- Query with hive partitioning much slower than hardcoded path👍 22 · opened Jul 2024 · active Jun 2026
- Add support for SERIAL and BIGSERIAL type👍 20 · opened May 2021 · active Jan 2026
- ALTER TABLE support for adding foreign key constraints👍 15 · opened Dec 2018 · active Sep 2026
- DuckDB does not follow XDG Base Directory Spec👍 12 · opened Apr 2024 · active Apr 2026
Who uses it
12 makers' products, each linked to the source that shows it, and 54 open-source projects that declare it in their code. The best known on Product Hunt: Databox (2,312 followers), Preswald (786 followers), Evidence (566 followers), MotherDuck (403 followers), CamelAI (296 followers).
“We use DuckDB WebAssembly as the core of Universal SQL and it has made it possible to deliver incredibly fast, interactive apps. The DuckDB team and community are phenomenal.”
DatabaseMaker says so · source ↗“Enabled lightweight, high-performance local querying for structured data analysis.”
DatabaseMaker says so · source ↗“Provides low latency, high scalability for data caching and analysis.”
DatabaseMaker says so · source ↗“DuckDB powers our analytics engine for SQLite, CSV, Excel files and more. We couldn't have built CamelAI without DuckDB. It's enabled us to execute SQL queries that used to take minutes in seconds.”
DatabaseMaker says so · source ↗“Our built-in SQL cells are powered by duckdb, which makes it possible to execute blazingly fast queries against Python dataframes as well as external databases like SQLite and Postgres.”
DatabaseMaker says so · source ↗“DuckDB is an in-process SQL OLAP database management system. It’s the fastest-improving in-process SQL OLAP database on the planet. At MotherDuck, we are grateful to be part of the broader DuckDB ‘flock’ and to give back to this community by developing thoughtful, accessible projects like the DuckDB UI. To Hannes and Mark, the creators of DuckDB: We are deeply grateful for the strength of our partnership, and we look forward to co-creating the future of analytics with you. Onward!”
DatabaseMaker says so · source ↗“DuckDB is at every layer of the Summer platform. Its light weight executable, high performance, and operational ergonomics make it the perfect for moving, querying, and visualizing data.”
DatabaseMaker says so · source ↗“We appreciate DuckDB and its innovative approach to the database ecosystem for analytics.”
DatabaseMaker says so · source ↗“Fast SQL queries directly on Parquet catalog.”
DatabaseMaker says so · source ↗“It’s insanely fast for local analytical workloads, and integrates beautifully with Pandas. Perfect for CSVs and Parquet files in browser-based workflows. It also doesn’t need a server or setup which is a huge win for interactive demos. DuckDB + Pyodide works surprisingly well. You can compile DuckDB to WebAssembly and run SQL queries in-browser with zero backend.”
DatabaseMaker says so · source ↗“DuckDB WASM is used as database engine in the browser.”
DatabaseMaker says so · source ↗None of these in makers' own words.
Open source: a project that declares DuckDB as a dependency in its public code — verifiable, but not necessarily a live product.
What its projects tell coding agents
28 of the 40 open-source products built with DuckDB that were worked on in the last 180 days keep instruction files for coding agents — 70%, against 53% of all the projects we read. AGENTS.md is in 21, CLAUDE.md in 15.
Alternatives to DuckDB
All alternatives by situation →Further reading
Questions makers ask about DuckDB
Is DuckDB good for production?
12 makers' products we track run on it.
What is DuckDB used for?
In-process analytical SQL database that queries CSV, Parquet, JSON and Iceberg files locally or in object storage, with no server. Makers' products we track use it for database (12).
What are the alternatives to DuckDB?
For database, the other options makers' products we track chose most are Supabase (573), Firebase (187), MongoDB (128), PostgreSQL (98), Neon (96), Convex (50). Open source or self-hostable among them: Supabase, MongoDB, PostgreSQL, Neon, Convex. Each alternative, with the situation it fits, is on the DuckDB alternatives page.
Is DuckDB free?
Yes — it is free, open-source software.
Is DuckDB open source or self-hostable?
Open source. source ↗
Can AI coding agents work with DuckDB?
It serves an llms.txt docs index.
Who uses DuckDB?
12 makers' products we track, each with a source, and 54 open-source projects declare it in their code. The best known of them on Product Hunt: Databox (2,312 followers), Preswald (786 followers), Evidence (566 followers), MotherDuck (403 followers), CamelAI (296 followers). source ↗