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 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

Portable

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

Read more

Feature-rich

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

Fast

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

Extensible

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

Read more

Free

DuckDB and its core extensions 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 20 seconds on most platforms.

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

Latest release: DuckDB 1.1.3 | System detected:

Blog

The DuckDB Avro Extension
extensions

The DuckDB Avro Extension

2024-12-09
Hannes Mühleisen
DuckDB: Running TPC-H SF100 on Mobile Phones
benchmark

DuckDB: Running TPC-H SF100 on Mobile Phones

2024-12-06
Gabor Szarnyas, Laurens Kuiper, Hannes Mühleisen
All blog posts

Upcoming events

DuckCon #6 in Amsterdam
2025-01-31 DuckCon

DuckCon #6 in Amsterdam

Pakhuis de Zwijger, Amsterdam
Mark Raasveldt, Hannes Mühleisen, Gabor Szarnyas, Kelly de Smit
All events