duckdb-extensions
DuckDB extensions as python package
What it is and what it does
duckdb-extensions wraps DuckDB's core extension ecosystem into pip-installable packages, so you can add cloud storage, format readers, and database connectors directly from Python without managing external binaries. It packages only DuckDB Labs–maintained extensions, not community or nightly builds, to keep the supply chain trust model clear.
The package bundles pre-built extension binaries for linux_amd64, linux_arm64, osx_arm64, osx_amd64, and windows_amd64, verifying them against SHA-256 checksums before publishing. You install the main package, then load extensions into your DuckDB session with a single import call. Releases track DuckDB's version; the current 1.5.5 is compatible with duckdb==1.5.5.
Use it for:
- Query Parquet, Excel, or Avro files directly in DuckDB without writing custom loaders.
- Connect to PostgreSQL, MySQL, or SQLite databases as DuckDB tables for cross-database joins.
- Read data from S3, Azure Blob Storage, or HTTP endpoints using cloud storage extensions.
- Load Delta Lake or Iceberg tables for analytics on cloud data warehouses.
- Add full-text search or spatial query support to DuckDB via specialized extensions.
Worth the install?
AI-flagged interpretation of the facts on this page — verify before relying
Packages DuckDB core extensions as pip-installable Python modules, letting you add functionality like cloud storage, format support, and database connectors to DuckDB without leaving the Python ecosystem.
Yes. Low install friction, active maintenance, no known vulnerabilities, and a permissive MIT license. Install it if you use DuckDB and need any of its core extensions—the pip integration eliminates the friction of managing extension binaries separately. The checksum verification and deliberate scope reduce supply-chain risk.
Install
duckdb-extensions on PyPI
pip
pip install duckdb-extensionsuv
uv add duckdb-extensionspoetry
poetry add duckdb-extensionsInstalling duckdb-extensions
Before you install
Low friction: pure Python wheel with only duckdb and importlib-resources as runtime dependencies. Active maintenance with a release 4 days old and commits current as of 2026-08-10.
License in practice
MIT license on the wrapper code; bundled extension binaries may carry different upstream licenses. See THIRD_PARTY_LICENSES.md for per-extension terms.
Quickstart
pip install duckdb-extensions
from duckdb_extensions import import_extension
import_extension("httpfs")
import duckdb
print(duckdb.sql("SELECT installed FROM duckdb_extensions() WHERE extension_name='httpfs'").fetchone()[0])
Requires Python >=3.10; duckdb must be installed separately.
Verify before relying
- Whether individual extensions are published as separate packages or bundled in duckdb-extensions itself.
- Whether extension binaries are pre-built or compiled on install for your platform.
- Performance or compatibility differences between PyPI-packaged extensions and DuckDB's native extension loading.
Package facts
| License | MIT (permissive) |
| Python support | supports the current Python release (>=3.10) |
| Install friction | low — pure-Python wheel |
| Runtime dependencies | 2 — duckdb, importlib-resources |
| Maintenance | actively maintained — 4 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 105,136/month — #12,717 on PyPI (30-day window, as of 2026-08-14) |
| Known vulnerabilities | none known (OSV.dev, checked 2026-08-14) |
Evidence: duckdb_extensions-1.5.5-py3-none-any.whl
Tags
More Database packages
psycopg2-binary is a PostgreSQL database…
copyleft · top 1,000 on PyPI
redisPython client library for connecting to and…
permissive · top 1,000 on PyPI
ydbYDB Python SDK is the official client library…
permissive · top 1,000 on PyPI
snowflake-connector-pythonConnects Python applications to Snowflake data…
permissive · top 1,000 on PyPI
sqlparsesqlparse tokenizes SQL text into a tree of…
permissive · top 1,000 on PyPI
dbt-adaptersProvides base adapter protocols and shared…
permissive · top 1,000 on PyPI
duckdb-extension-httpfsEnables DuckDB to query data over HTTP/HTTPS by…
permissive · top 15,000 on PyPI
dbt-duckdbdbt-duckdb connects dbt (a SQL/Python…
permissive · top 5,000 on PyPI
duckdbDuckDB is an in-process SQL database engine…
permissive · top 1,000 on PyPI
kedro-datasetsKedro-Datasets provides data connectors for…
permissive · top 5,000 on PyPI
duckdb-engineA SQLAlchemy driver that enables you to use…
permissive · top 5,000 on PyPI
tentaclio-s3Provides S3 storage integration for tentaclio…
unclear · top 5,000 on PyPI
dagster-duckdbIntegrates DuckDB with Dagster's data pipeline…
permissive · top 15,000 on PyPI
pgserverEmbeds a PostgreSQL server with pgvector…
unclear · top 15,000 on PyPI
etcd-distroetcd-distro packages the etcd key-value store…
permissive · top 15,000 on PyPI