Analytics-grade SQLite
In-process analytical database executing SQL at DataFrame speed: the workhorse of local data crunching.
The in-process analytical database, 'SQLite for OLAP': columnar, vectorized, and fast enough to crunch Parquet/CSV/JSON locally. Extensions (httpfs, spatial, vector similarity) turned it into the data engineer's pocketknife, and MotherDuck clouds it.
Who it's for
Data engineers who want an embedded OLAP database for analytics over local files and dataframes.
Official links
Keep exploring
1 in catalog
DuckDB features
1 in catalog
DuckDB works with
1 in catalog