DuckDB in-process database
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.
1.6.0.dev12
Mar 20, 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.5.2
Apr 13, 2026
1.5.1
Mar 23, 2026
1.5.0
Mar 09, 2026
1.4.5.dev31
May 14, 2026
1.4.5.dev27
Apr 22, 2026
1.4.4
Jan 26, 2026
1.4.3
Dec 09, 2025
1.4.2
Nov 12, 2025
1.4.1
Oct 07, 2025
1.4.0
Sep 16, 2025
1.3.2
Jul 08, 2025
1.3.1
Jun 16, 2025
1.3.0
May 21, 2025
1.2.2
Apr 08, 2025
1.2.1
Mar 05, 2025
1.2.0
Feb 05, 2025
1.1.3
Nov 04, 2024
1.1.2
Oct 14, 2024
1.1.1
Sep 24, 2024
1.1.0
Sep 09, 2024
1.0.0
Jun 03, 2024
0.10.3
May 22, 2024
0.10.2
Apr 17, 2024
0.10.1
Mar 18, 2024
0.10.0
Feb 13, 2024
0.9.2
Nov 14, 2023
0.9.1
Oct 11, 2023
0.9.0
Sep 26, 2023
0.8.1
Jun 13, 2023
0.8.0
May 17, 2023
0.7.1
Feb 27, 2023
0.7.0
Feb 13, 2023
0.6.1
Dec 06, 2022
0.6.0
Nov 14, 2022
0.5.1
Sep 19, 2022
0.5.0
Sep 05, 2022
0.4.0
Jun 20, 2022
0.3.4
Apr 25, 2022
0.3.3
Apr 11, 2022
0.3.2
Feb 07, 2022
0.3.1
Nov 16, 2021
0.3.0
Oct 06, 2021
0.2.9
Sep 06, 2021
0.2.8
Aug 02, 2021
0.2.7
Jun 14, 2021
0.2.6
May 08, 2021
0.2.5
Mar 10, 2021
0.2.4
Feb 02, 2021
0.2.3
Dec 03, 2020
0.2.2
Nov 01, 2020
0.2.1
Aug 29, 2020
0.2.0
Jul 23, 2020
0.1.9
Jun 19, 2020
0.1.8
Jun 05, 2020
0.1.7
May 04, 2020
0.1.6
Apr 08, 2020
0.1.5
Mar 03, 2020
0.1.3
Feb 03, 2020
0.1.2
Jan 06, 2020
0.1.1
Sep 24, 2019
0.1.0
Jun 27, 2019
0.0.3
May 08, 2019
0.0.2
May 08, 2019
0.0.0
Dec 16, 2023
Wheel compatibility matrix
Files in release
duckdb-1.5.3-cp310-cp310-macosx_10_9_universal2.whl (31.1MiB)
duckdb-1.5.3-cp310-cp310-macosx_10_9_x86_64.whl (16.5MiB)
duckdb-1.5.3-cp310-cp310-macosx_11_0_arm64.whl (14.7MiB)
duckdb-1.5.3-cp310-cp310-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl (18.4MiB)
duckdb-1.5.3-cp310-cp310-manylinux_2_26_x86_64.manylinux_2_28_x86_64.whl (20.4MiB)
duckdb-1.5.3-cp310-cp310-win_amd64.whl (12.5MiB)
duckdb-1.5.3-cp311-cp311-macosx_10_9_universal2.whl (31.1MiB)
duckdb-1.5.3-cp311-cp311-macosx_10_9_x86_64.whl (16.5MiB)
duckdb-1.5.3-cp311-cp311-macosx_11_0_arm64.whl (14.7MiB)
duckdb-1.5.3-cp311-cp311-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl (18.4MiB)
duckdb-1.5.3-cp311-cp311-manylinux_2_26_x86_64.manylinux_2_28_x86_64.whl (20.4MiB)
duckdb-1.5.3-cp311-cp311-win_amd64.whl (12.5MiB)
duckdb-1.5.3-cp311-cp311-win_arm64.whl (13.3MiB)
duckdb-1.5.3-cp312-cp312-macosx_10_13_universal2.whl (31.1MiB)
duckdb-1.5.3-cp312-cp312-macosx_10_13_x86_64.whl (16.5MiB)
duckdb-1.5.3-cp312-cp312-macosx_11_0_arm64.whl (14.7MiB)
duckdb-1.5.3-cp312-cp312-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl (18.4MiB)
duckdb-1.5.3-cp312-cp312-manylinux_2_26_x86_64.manylinux_2_28_x86_64.whl (20.5MiB)
duckdb-1.5.3-cp312-cp312-win_amd64.whl (12.5MiB)
duckdb-1.5.3-cp312-cp312-win_arm64.whl (13.3MiB)
duckdb-1.5.3-cp313-cp313-macosx_10_13_universal2.whl (31.1MiB)
duckdb-1.5.3-cp313-cp313-macosx_10_13_x86_64.whl (16.5MiB)
duckdb-1.5.3-cp313-cp313-macosx_11_0_arm64.whl (14.7MiB)
duckdb-1.5.3-cp313-cp313-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl (18.4MiB)
duckdb-1.5.3-cp313-cp313-manylinux_2_26_x86_64.manylinux_2_28_x86_64.whl (20.5MiB)
duckdb-1.5.3-cp313-cp313-win_amd64.whl (12.5MiB)
duckdb-1.5.3-cp313-cp313-win_arm64.whl (13.3MiB)
duckdb-1.5.3-cp314-cp314-macosx_10_15_universal2.whl (31.1MiB)
duckdb-1.5.3-cp314-cp314-macosx_10_15_x86_64.whl (16.5MiB)
duckdb-1.5.3-cp314-cp314-macosx_11_0_arm64.whl (14.7MiB)
duckdb-1.5.3-cp314-cp314-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl (18.4MiB)
duckdb-1.5.3-cp314-cp314-manylinux_2_26_x86_64.manylinux_2_28_x86_64.whl (20.5MiB)
duckdb-1.5.3-cp314-cp314-win_amd64.whl (13.0MiB)
duckdb-1.5.3-cp314-cp314-win_arm64.whl (13.7MiB)
duckdb-1.5.3.tar.gz (17.2MiB)
