DuckDB is an in-process analytical database designed by CWI Amsterdam and now developed by DuckDB Labs. It is often described as the SQLite for analytics: a single binary with no server process, a rich SQL dialect, and a column-oriented execution engine optimized for OLAP workloads over Parquet, CSV, JSON and Arrow.
By 2026 DuckDB downloads cross 25 million a month across pip, npm, Rust, Go, C, R, Java and the native CLI. It is the engine inside many modern data tools, the default local engine for notebook analytics, and increasingly the way CI pipelines validate data without paying for a warehouse. Its extension system brings geospatial, JSON path, httpfs, iceberg and full-text search into the same binary.