Project Links

Meta

Author: DuckDB Foundation

Maintainer: DuckDB Foundation

Requires Python: >=3.10.0

Classifiers

Development Status

5 - Production/Stable

License

OSI Approved :: MIT License

Operating System

OS Independent

Topic

Database
Database :: Database Engines/Servers
Scientific/Engineering

Intended Audience

Developers
Education
Information Technology
Science/Research

Programming Language

Python
Python :: 3
Python :: 3 :: Only
Python :: 3.10
Python :: 3.11
Python :: 3.12
Python :: 3.13
Python :: 3.14
C++

DuckDB.org | User Guide (Python) - API Docs (Python)

DuckDB: A Fast, In-Process, Portable, Open Source, Analytical Database System

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.
Portable: DuckDB runs on Linux, macOS, Windows, Android, iOS and all popular hardware architectures. It has idiomatic client APIs for major programming languages.
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.
Fast: DuckDB runs analytical queries at blazing speed thanks to its columnar engine, which supports parallel execution and can process larger-than-memory workloads.
Extensible: DuckDB is extensible by third-party features such as new data types, functions, file formats and new SQL syntax. User contributions are available as community extensions.
Free: DuckDB and its core extensions are open-source under the permissive MIT License. The intellectual property of the project is held by the DuckDB Foundation.

Installation

Install the latest release of DuckDB directly from PyPI:

pip install duckdb

Install with all optional dependencies:

pip install 'duckdb[all]'

Contributing

See the CONTRIBUTING.md for instructions on how to set up a development environment.

2.0.0.dev2609250715 Sep 25, 2026

2.0.0.dev2609242139 Sep 25, 2026

2.0.0.dev2609222040 Sep 23, 2026

2.0.0.dev2609221243 Sep 22, 2026

2.0.0.dev2609121639 Sep 12, 2026

1.6.0.dev379 Sep 02, 2026

1.6.0.dev365 Aug 20, 2026

1.6.0.dev360 Aug 19, 2026

1.6.0.dev358 Aug 18, 2026

1.6.0.dev343 Jul 28, 2026

1.6.0.dev341 Jul 26, 2026

1.6.0.dev339 Jul 25, 2026

1.6.0.dev337 Jul 24, 2026

1.6.0.dev291 Jul 19, 2026

1.6.0.dev289 Jul 18, 2026

1.6.0.dev287 Jul 17, 2026

1.6.0.dev285 Jul 16, 2026

1.6.0.dev284 Jul 15, 2026

1.6.0.dev280 Jul 05, 2026

1.6.0.dev278 Jul 04, 2026

1.6.0.dev276 Jul 02, 2026

1.6.0.dev265 Jul 02, 2026

1.6.0.dev214 Jul 01, 2026

1.6.0.dev211 Jun 27, 2026

1.6.0.dev203 Jun 26, 2026

1.6.0.dev72 Jun 22, 2026

1.6.0.dev68 Jun 26, 2026

1.6.0.dev66 Jun 19, 2026

1.6.0.dev64 Jun 18, 2026

1.6.0.dev12 Mar 20, 2026

1.5.6.dev48 Sep 23, 2026

1.5.6.dev46 Sep 19, 2026

1.5.6.dev44 Sep 18, 2026

1.5.6.dev42 Sep 17, 2026

1.5.6.dev40 Sep 16, 2026

1.5.6.dev36 Sep 10, 2026

1.5.6.dev34 Sep 07, 2026

1.5.6.dev32 Sep 02, 2026

1.5.6.dev30 Aug 29, 2026

1.5.6.dev25 Aug 20, 2026

1.5.6.dev22 Aug 19, 2026

1.5.6.dev20 Aug 18, 2026

1.5.6.dev11 Jul 29, 2026

1.5.6.dev9 Jul 28, 2026

1.5.6.dev7 Jul 26, 2026

1.5.6.dev5 Jul 25, 2026

1.5.5 Jul 22, 2026

1.5.5.dev31 Jul 19, 2026

1.5.5.dev29 Jul 18, 2026

1.5.5.dev27 Jul 17, 2026

1.5.5.dev25 Jul 16, 2026

1.5.5.dev23 Jul 15, 2026

1.5.5.dev21 Jul 10, 2026

1.5.5.dev19 Jul 04, 2026

1.5.5.dev17 Jul 02, 2026

1.5.5.dev13 Jun 28, 2026

1.5.5.dev11 Jun 27, 2026

1.5.5.dev9 Jun 26, 2026

1.5.5.dev3 Jun 19, 2026

1.5.4 Jun 17, 2026

1.5.4.dev25 Jun 16, 2026

1.5.4.dev18 Jun 11, 2026

1.5.4.dev8 Jun 06, 2026

1.5.4.dev6 May 30, 2026

1.5.4.dev2 May 27, 2026

1.5.3 May 20, 2026

1.5.3.dev26 May 16, 2026

1.5.3.dev24 May 14, 2026

1.5.3.dev22 May 13, 2026

1.5.3.dev19 May 11, 2026

1.5.3.dev17 May 09, 2026

1.5.3.dev13 May 06, 2026

1.5.3.dev7 Apr 23, 2026

1.4.5.dev46 Jun 13, 2026

1.4.5.dev39 Jun 10, 2026

1.4.5.dev37 Jun 09, 2026

1.4.5.dev35 May 30, 2026

1.4.5.dev33 May 29, 2026

1.4.5.dev31 May 14, 2026

1.4.5.dev27 Apr 22, 2026

Wheel compatibility matrix

Platform	CPython 3.10	CPython 3.11	CPython 3.12	CPython 3.13	CPython 3.14
macosx_10_13_universal2
macosx_10_13_x86_64
macosx_10_15_universal2
macosx_10_15_x86_64
macosx_10_9_universal2
macosx_10_9_x86_64
macosx_11_0_arm64
manylinux_2_26_aarch64
manylinux_2_26_x86_64
manylinux_2_28_aarch64
manylinux_2_28_x86_64
win_amd64
win_arm64