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.
3 maintainers
Metadata
3 maintainers
Release files for duckdb 2.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| duckdb-2.0.0.tar.gz | 16.8 MB | With provenance | Details |
Built distributions (wheels)
Total release size: 319.6 MB
Release files / duckdb-2.0.0.tar.gz
| Download URL | duckdb-2.0.0.tar.gz |
|---|---|
| Size | 16.8 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
09de511ef0dc76a5213e8d3d87a8b89bb4d3e8a6fe73a9f60dc001269946b44f
|
|
BLAKE2b-256 checksum How to use checksums |
c27cdfdf5e9cebefd032f57f09b224993e861ecb55f61e36c709544b04b44f70
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp312-abi3-win_arm64.whl
| Download URL | duckdb-2.0.0-cp312-abi3-win_arm64.whl |
|---|---|
| Size | 15.7 MB |
| Tags | CPython 3.12 Windows ARM64 abi3 |
|
SHA-256 checksum How to use checksums |
c5e6708efaa8647e0914a16f1914354419e529a1925929950e7d610418e45873
|
|
BLAKE2b-256 checksum How to use checksums |
37816ea5dc1050f86ec4dd038a2774766b42247ba6104e7785f13a0c600e2b33
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp312-abi3-win_amd64.whl
| Download URL | duckdb-2.0.0-cp312-abi3-win_amd64.whl |
|---|---|
| Size | 15.4 MB |
| Tags | CPython 3.12 Windows x86-64 abi3 |
|
SHA-256 checksum How to use checksums |
f61c96547ed432f54dae42a717fd88563eda55cb47549715fac9f61f770c205a
|
|
BLAKE2b-256 checksum How to use checksums |
09d39e8ca1242b98f04041bef09686ecfe098b41f820aa23240f63f360b64eaf
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp312-abi3-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl
| Download URL | duckdb-2.0.0-cp312-abi3-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl |
|---|---|
| Size | 24.4 MB |
| Tags | CPython 3.12 Linux glibc 2.27+ x86-64 Linux glibc 2.28+ x86-64 abi3 |
|
SHA-256 checksum How to use checksums |
ab51ec57d329d6f3df37c0287b55d71c3fc07bb54b61d1afed09104f953b1431
|
|
BLAKE2b-256 checksum How to use checksums |
cc3301ad2535ee897db2bad70cbc800655167c53afd0b955eed84f0759c2f417
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp312-abi3-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl
| Download URL | duckdb-2.0.0-cp312-abi3-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl |
|---|---|
| Size | 21.7 MB |
| Tags | CPython 3.12 Linux glibc 2.26+ ARM64 Linux glibc 2.28+ ARM64 abi3 |
|
SHA-256 checksum How to use checksums |
e38daf0acbad9de7ce892d402b68409519291ee16af3c2cba85ace3b085c7eaa
|
|
BLAKE2b-256 checksum How to use checksums |
924a985fb9d93d7f9f8e82092ddfe05ec8c9a1d0df7bdb0f562a10ced30e3e8f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp312-abi3-macosx_11_0_arm64.whl
| Download URL | duckdb-2.0.0-cp312-abi3-macosx_11_0_arm64.whl |
|---|---|
| Size | 17.6 MB |
| Tags | CPython 3.12 abi3 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
b5d758b53751c930e09d371230241005ea5203c8edc65a1e1fafca83fcc906ef
|
|
BLAKE2b-256 checksum How to use checksums |
8fa34d23938223626980cdcf18fd6b0dbf040823b5cf15beabbf4ab7ee276631
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp312-abi3-macosx_10_15_x86_64.whl
| Download URL | duckdb-2.0.0-cp312-abi3-macosx_10_15_x86_64.whl |
|---|---|
| Size | 19.7 MB |
| Tags | CPython 3.12 abi3 macOS 10.15+ x86-64 |
|
SHA-256 checksum How to use checksums |
46c7a299ff5f45be9068cfc0ceecb3fd574af9535de8cb6908ae8b52d2846cbd
|
|
BLAKE2b-256 checksum How to use checksums |
075bfbe92644709fb9162cc51753f92f892b1f333658079d1f11efaed43341d2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp312-abi3-macosx_10_15_universal2.whl
| Download URL | duckdb-2.0.0-cp312-abi3-macosx_10_15_universal2.whl |
|---|---|
| Size | 37.0 MB |
| Tags | CPython 3.12 abi3 macOS 10.15+ universal2 (ARM64, x86-64) |
|
SHA-256 checksum How to use checksums |
cb1cc30318397c3bcffa6b683196293698052588de3c1ba1e144ba0c72560ce9
|
|
BLAKE2b-256 checksum How to use checksums |
41281fb52f9ea10205a55a07c32e37cd4fd68fa9d1dc2520a12405ec9bb59cac
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp311-cp311-win_arm64.whl
| Download URL | duckdb-2.0.0-cp311-cp311-win_arm64.whl |
|---|---|
| Size | 15.7 MB |
| Tags | CPython 3.11 Windows ARM64 |
|
SHA-256 checksum How to use checksums |
62bea9a1786be98d2906197c67a4089cc8b34d66d19e87e5543d8201e81323ad
|
|
BLAKE2b-256 checksum How to use checksums |
0913392991ec9dcb22811c7029009184a910bd5cb69fbb7a626f36f151215535
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp311-cp311-win_amd64.whl
| Download URL | duckdb-2.0.0-cp311-cp311-win_amd64.whl |
|---|---|
| Size | 15.4 MB |
| Tags | CPython 3.11 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
a387d4907b535a4bd82ba8aede6809d0bf023dfbb21362832f3c9848aea7743c
|
|
BLAKE2b-256 checksum How to use checksums |
b5010729ac5d9857e5f0bde7262961f80e578a29945a444169886094cc9c69f4
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp311-cp311-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl
| Download URL | duckdb-2.0.0-cp311-cp311-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl |
|---|---|
| Size | 24.4 MB |
| Tags | CPython 3.11 Linux glibc 2.27+ x86-64 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
5a3601121c7cc50d0b70412995634682fafcb58a0156d5d663dfd0b3bbe30a33
|
|
BLAKE2b-256 checksum How to use checksums |
e4a19c3780faada6e6a3edc5f9364cf19810e6e1ea90a7d5fd8fffc48b42c269
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp311-cp311-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl
| Download URL | duckdb-2.0.0-cp311-cp311-manylinux_2_26_aarch64.manylinux_2_28_aarch64.whl |
|---|---|
| Size | 21.6 MB |
| Tags | CPython 3.11 Linux glibc 2.26+ ARM64 Linux glibc 2.28+ ARM64 |
|
SHA-256 checksum How to use checksums |
bcdf10dfbc2c1a6bdc5b2a94bba5b15481e552c5745c2af1994617b0eb6bc750
|
|
BLAKE2b-256 checksum How to use checksums |
04950c8b5b95ac9e14ee83090a78048fbb23fb9f8abacd63e11a5eee7fcb31e1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp311-cp311-macosx_11_0_arm64.whl
| Download URL | duckdb-2.0.0-cp311-cp311-macosx_11_0_arm64.whl |
|---|---|
| Size | 17.6 MB |
| Tags | CPython 3.11 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
61a244faae9fd787e30f4c76888769ec49e79736c434f698e8178a00af8348f0
|
|
BLAKE2b-256 checksum How to use checksums |
4b812895b9ee3858dae7a57f791d7dbd4f116e9fa8fd3c71b9a377dbd4d292a7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp311-cp311-macosx_10_15_x86_64.whl
| Download URL | duckdb-2.0.0-cp311-cp311-macosx_10_15_x86_64.whl |
|---|---|
| Size | 19.7 MB |
| Tags | CPython 3.11 macOS 10.15+ x86-64 |
|
SHA-256 checksum How to use checksums |
9bcc9921be0e1b2404b96a7fb447a8b80fe2f3a919cdc976ca6c39951cc8f2f5
|
|
BLAKE2b-256 checksum How to use checksums |
8436e1ea89acd74917ca654d5adc278765f0116e07540abf4134d5cf9f527363
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logRelease files / duckdb-2.0.0-cp311-cp311-macosx_10_15_universal2.whl
| Download URL | duckdb-2.0.0-cp311-cp311-macosx_10_15_universal2.whl |
|---|---|
| Size | 37.0 MB |
| Tags | CPython 3.11 macOS 10.15+ universal2 (ARM64, x86-64) |
|
SHA-256 checksum How to use checksums |
a3b38d8cdbef10007c64b65efc4087f799c4dc606785aa5f2a425ed13658ca01
|
|
BLAKE2b-256 checksum How to use checksums |
7357ec7c1a01ab43fc13c55c17cc54a5740886e04ae830aa420ac00614b1420a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.16
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logSecurity for duckdb 2.0.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
Full provenance
All 15 files in this release have been uploaded with provenance metadata.
Attestation for duckdb-2.0.0.tar.gz
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 21, 2026.
Transparency logA note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
