DuckDB

An in-process analytical SQL database.

Stars
43k
Forks
4.2k
Licence
MIT
Language
C++
Version
2.0.0
Updated

At a glance

  • Runs inside your process, with no server to manage
  • Queries Parquet, CSV and JSON files in place
  • Columnar, vectorised execution for analytical queries

Get started

Pythonpip install duckdb
Homebrewbrew install duckdb

What it is

DuckDB is to analytics what SQLite is to transactions: a database that lives inside your application. Point it at files and query them with SQL.

Why it stands out

Its columnar engine handles analytical queries over large datasets on a laptop, often removing the need for a data warehouse in early work.

Who it is for

Data analysts and engineers working with local or file-based data.