Search Shortcut cmd + k | ctrl + k

DuckDB is a fast
|

database system

Query and transform your data anywhere
using DuckDB's feature-rich SQL dialect

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
GROUP BY ALL
ORDER BY num_services DESC
LIMIT 3;
Live demo

DuckDB at a glance

Simple

DuckDB was designed to be simple to use. It has zero dependencies, so it can be installed in seconds and deployed in milliseconds.

Read more

Portable

DuckDB runs on all popular operating systems and hardware architectures. It has idiomatic client APIs for major programming languages.

Read more

Feature-rich

DuckDB supports multiple file formats (CSV, Parquet, and JSON), data lake formats. It can also connect to network and cloud storage.

Read more

Fast

DuckDB runs queries at blazing speed. It uses parallel execution and can process larger-than-memory workloads.

Read more

Extensible

DuckDB is extensible by third-party features. User contributions are available as community extensions.

Read more

Free

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

Read more

Installation

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

More installation options
  • Command line
  • Python
  • R
  • Java
  • Node.js
  • ODBC
  • Rust
  • Go
curl https://install.duckdb.org | sh

Latest release: DuckDB 1.3.2 | System detected:

Blog

Big Data on the Move: DuckDB on the Framework Laptop 13
benchmark

Big Data on the Move: DuckDB on the Framework Laptop 13

2025-09-08
Gábor Szárnyas
Basic Feature Engineering with DuckDB
using DuckDB

Basic Feature Engineering with DuckDB

2025-08-15
Petrica Leuca
All blog posts