Search Shortcut cmd + k | ctrl + k

DuckDB is a fast in-process analytical database

DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs.
DuckDB v1.0.0 was released in June 2024.

Installation Documentation
  • SQL
  • Python
  • R
  • Java
  • Node.js
-- Get the top-3 busiest train stations
SELECT station_name, count(*) AS num_services
FROM train_services
ORDER BY num_services DESC
Live demo

DuckDB at a glance


DuckDB is easy to install and deploy. It has zero external dependencies and runs in-process in its host application or as a single binary.

Read more


DuckDB runs on Linux, macOS, Windows, and all popular hardware architectures. It has idiomatic client APIs for major programming languages.

Read more


DuckDB offers a rich SQL dialect. It can read and write file formats such as CSV, Parquet, and JSON, to and from the local file system and remote endpoints such as S3 buckets.

Read more


DuckDB runs analytical queries at blazing speed thanks to its columnar engine, which supports parallel execution and can process larger-than-memory workloads.

Read more


DuckDB is extensible by third-party features such as new data types, functions, file formats and new SQL syntax.

Read more


DuckDB and its core extensions are open-source under the permissive MIT License.

Read more


DuckDB is seamlessly integrated with major programming languages. It can be installed in less than 20 seconds on most platforms.

More installation options
  • Command line
  • Python
  • R
  • Java
  • Node.js
  • ODBC
brew install duckdb

Latest release: DuckDB 1.0.0 | System detected: