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.
DuckDB 2.0 Alpha adds dynamic attach statements that let you pull credentials from environment variables instead of hardcoding them, solving a major friction point when working across multiple data lakes. Early production testing shows less than 1% failure rates, and the release bundles this with Quack and official DuckLake support to make local-first lakehouse workflows actually practical.
- Dynamic attach statements now accept environment variables for credentials (usernames, passwords, account numbers), eliminating the need to hardcode sensitive data or switch to Python for multi-catalog federation
- Production pilot running hourly jobs showed <1% failure rate over 10 days, reading Parquet from S3 and writing to Iceberg tables via RDS-DMS
- Release combines dynamic attach with Quack and official DuckLake support, completing the local-first lakehouse story but raising open questions about concurrent writer behavior on shared Iceberg tables
The author shares their shift from using Excel and Google Sheets to DuckDB and SQL for handling CSV files, highlighting the efficiency of querying data directly. They discuss the benefits of using SQL for data manipulation and invite readers to share their own CSV handling tips.
- DuckDB lets you run SQL directly on CSV files (joins, window functions, dedup queries) without importing them into Excel/Sheets first
- You can query CSVs from URLs or cloud storage like S3 directly, and export results straight back to CSV
- Several users find SQL queries more intuitive than replicating the same logic with spreadsheet formulas or pivot tables
- Some commenters mix in Parquet files and other extensions alongside DuckDB to further speed up ad-hoc analysis