DuckDB

DuckDB is an open-source, in-process columnar SQL database engine designed for analytical queries (OLAP). Often described as the “SQLite for analytics,” DuckDB requires no server setup or external dependencies; it runs embedded inside Python, R, Node.js, command-line shells, or directly in web browsers via WebAssembly.

For data journalists, academic researchers, and civic analysts working with large open datasets (such as multi-gigabyte government census releases, procurement logs, or satellite-derived datasets), DuckDB allows blazing-fast SQL queries directly on remote or local CSV, Parquet, and JSON files without needing a dedicated database server.