DuckDB
An in-process SQL OLAP database management system
★ 4.6
In-process SQL OLAP database. 'SQLite for analytics' - fast analytical queries on local data. Perfect for data science, ETL, and embedded analytics.
free
Pricing
Yes
Self-Hostable
Features
- ✓ In-process (no server needed)
- ✓ Columnar storage for analytics
- ✓ Full SQL support
- ✓ Direct Parquet/CSV/JSON querying
- ✓ Parallel query execution
- ✓ Zero dependencies
- ✓ Python/R deep integration
- ✓ Cross-platform
Pros
- + Blazing fast analytical queries
- + No server setup needed
- + Query files directly (Parquet, CSV)
- + Excellent Python integration
- + Modern SQL features
Cons
- − Not for OLTP workloads
- − Single-machine only
- − Newer project (less battle-tested)
- − No built-in replication