Search Shortcut cmd + k | ctrl + k

DuckDB is a fast
|

database system

DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs.

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
brew install duckdb

Latest release: DuckDB 1.1.3 | System detected:

Blog

Optimizers: The Low-Key MVP
deep dive

Optimizers: The Low-Key MVP

2024-11-14
Tom Ebergen
Analytics-Optimized Concurrent Transactions
deep dive

Analytics-Optimized Concurrent Transactions

2024-10-30
Mark Raasveldt and Hannes Mühleisen
Blog Archive

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