DuckDB

In-process analytical SQL database; the SQLite of OLAP.

DuckDB is an open-source in-process analytical (OLAP) SQL database that runs embedded inside an application with no separate server. It executes vectorized columnar queries directly over Parquet, CSV, JSON, and Arrow data and ships clients for Python, R, Node.js, and the CLI. It is notable for bringing fast local analytical querying to data science and ETL workflows with zero setup.