Updated

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.

Open sourceFree tier

Profile checked

Works with AI agents:llms.txt
Ask your AI about this, with this page as the source:ChatGPT ↗Claude ↗Perplexity ↗

How makers use DuckDB

Makers' products we track use DuckDB for database (12).

What DuckDB is used for

Database · Analytics (OLAP) →Analytical SQL inside your app or script over local or S3-hosted CSV and Parquet files, with no server to run.Trade-off: An embedded library, so it doesn't serve many concurrent writers like a database server does.

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%).

OptionMakers' products2026 launchesFree forAt 10,000 usersOpen source
Supabase573 45%63%~500 users$25/mo · ProYes
Firebase187 15%9%~2,000 users$9.66/mo · Blaze (pay as you go)No
MongoDB128 10%5%~500 users$58/mo · Atlas Dedicated M10No
PostgreSQL98 8%1%——Yes
Neon96 8%11%None$22/mo · LaunchYes
Convex50 4%7%~630 users$29/mo · ProfessionalYes
DuckDB12 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.
From each decision's guide, written from what makers' products chose and why.

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

Product Hunt review tags
fast performance6
in-process SQL engine5
WebAssembly support4
interactive apps2
local analytical workloads2
5.0★ from 16 reviews on Product Hunt ↗

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

YearComments choosing it, per monthNet praise
20235.7+28%
20245.4+8%
20257.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

Open on 2026-10-04 in duckdb/duckdb, with activity in the last year — issues and feature requests by 👍.

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).

The maker says so 12Declared in code 54How evidence is collected →
Databox
DataboxAgentic analytics platform for you and your agents.

“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 ↗
Evidence
EvidenceBusiness intelligence as code

“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 ↗
CamelAI
CamelAIAI Data Analyst - Chat with your data

“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 ↗
marimo
marimoThe next-generation Python notebook

“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 ↗
MotherDuck
MotherDuckThe ducking simple data warehouse for analytics

“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 ↗
Summer
SummerThe first end to end DuckDB powered data stack

“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 ↗
datajoi
datajoiData Agents Managing Your Data Analytics

“We appreciate DuckDB and its innovative approach to the database ecosystem for analytics.”

DatabaseMaker says so · source ↗
Preswald
PreswaldAI agent for building data apps, dashboards and reports

“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 ↗
Aix-DB
Aix-DBAix-DB 基于 LangChain/LangGraph 框架,结合 MCP Skills 多智能体协作架构,实现自然语言到数据洞察的端到端转换。DatabaseIn its code · source ↗

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.

795words in the median file
uvthe package manager most named, in 9 of 24 files
63%say how to test a change
Named more in these files than in other projects' — in how many of the 24:
What AGENTS.md files say about other tools →What open-source products tell their coding agents →

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 ↗