DuckDB
Embedded analytical databaseOpen source· verified Sep 2026
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 site
Reach for it when
- Local data analysis
- Querying CSV/Parquet without loading a warehouse
- Data pipelines