Click any tag below to further narrow down your results
Links
This is a free, searchable directory of 575 open-source projects and companies built on DuckDB, the embedded analytics database. It's rebuilt from the awesome-duckdb GitHub list and updated as of October 2026.
- The map covers 516 open-source projects and 59 companies that publicly say they build on DuckDB, each linked to its source.
- The most-starred projects include PyGWalker (16K stars), Kepler.gl (12.1K), and Lance (7.2K), and the top UIs are Preswald and Online DuckDB Shell.
- Snowflake's own Snowset data shows 96.2% of queries scanned under 10 GB, a size one DuckDB instance can handle, so many workloads could move off a warehouse.
The author shares a year of experience using AI for data work, arguing that copying someone else's workflow is pointless — what matters is learning specific techniques. He's settled on DuckDB CLI + Claude as his stack because it reduces hallucinations and keeps agents focused on actual tools instead of generating buggy code.
- AI workflows are creative, not formulaic — tips and tricks transfer better than full process replication, similar to how watching a music producer's exact steps won't let you recreate their song
- DuckDB CLI commands paired with AI agents dramatically cut hallucinations because agents understand the tool's actual capabilities rather than inventing Python code that doesn't work
- Working in a modern terminal (Ghostty) with multiple windows beats IDEs for analytics work — it's faster, gives you exactly the tools you need, and agents are already built to work with CLI tools
xlDuckDb is an Excel add-in that lets you write DuckDB SQL queries directly in spreadsheet cells and get results back as normal Excel data. You can query Excel ranges, JSON files, CSV files, Parquet files, and even remote data on HTTPS or AWS S3.
- The add-in works with Excel ranges, named ranges, and tables using simple syntax like =DuckDbQuery(A27,,A1:E25), plus you can query multiple ranges in a single query by passing them as separate arguments.
- DuckDB handles messy data formats automatically—it auto-detects CSV delimiters and data types, extracts nested JSON with JSONPath syntax, and efficiently queries large Parquet files that don't fit in memory.
- You can join data across multiple file types in one SQL query (e.g., combining JSON and CSV data with a CTE and INNER JOIN), making it possible to correlate disparate datasets without leaving Excel.
AWS acquired DuckLabs—the team behind the fast-growing DuckDB analytics database—to control the roadmap of a key data infrastructure technology and build an S3-powered alternative to Databricks and Snowflake. The deal doesn't include the open-source DuckDB foundation or MotherDuck, just the core engineering team and their vision.
- DuckDB, DuckLake, and Quack form a free, composable data stack that runs on AWS's S3 storage; AWS profits from increased compute and storage usage even when customers skip the vendor tax of proprietary platforms.
- AI agents need lightweight, embeddable databases for managing state and telemetry at scale, and DuckDB's architecture—small, fast-starting, process-embedded—makes it ideal for this emerging workload.
- AWS likely paid hundreds of millions or close to $1 billion, similar to Databricks's $1B+ acquisition of Tabular; the value lies in Hannes Mühleisen and Mark Raasveldt's vision and ability to shape DuckDB's evolution toward becoming a general-purpose distributed database.
AWS bought DuckLabs (the team behind DuckDB) to control the roadmap of a fast-growing analytics database that's becoming foundational to modern data infrastructure. The deal is really about acquiring talented engineers and influence over DuckDB's evolution toward becoming a distributed, server-based system that competes with Databricks and Snowflake.
- DuckDB + DuckLake + Quack form an open, S3-powered data stack that lets AWS compete with Databricks and Snowflake while making money on cloud primitives (compute, storage, networking) rather than vendor markup.
- DuckDB is well-suited for AI agents because it's lightweight, embeddable, starts instantly, and handles analytics on telemetry streams—exactly what agents need for self-optimization and parallel task exploration.
- AWS likely paid hundreds of millions to over $1 billion (comparable to Databricks' $1B+ Tabular deal) because even modest improvements to AWS's competitive position in data infrastructure justify massive payouts.