DuckDB
Embedded analytical databaseOpen source
A columnar SQL engine that runs in-process, like SQLite but built for analytics. Queries CSV and Parquet files directly and handles large local datasets quickly.
Official siteReach for it when
- Local data analysis
- Querying CSV/Parquet without loading a warehouse
- Data pipelines