duckdb-extension-httpfs
Duckdb httpfs extension
Decision gist · record as of 2026-08-14
Yes, if you use duckdb and need to query remote files over HTTP/HTTPS. The package is actively maintained, has no known vulnerabilities, uses a permissive MIT license, and medium install friction is acceptable for a specialized extension. Install only if you have duckdb already in your environment and a concrete use case for remote file access.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires duckdb as a runtime dependency; platform-specific wheels require a compatible Python version (3.9–3.13) and CPU architecture.
- Medium install friction due to platform-specific wheel distributions (macOS arm64/x86_64, Linux aarch64/x86_64, Windows amd64).
- Active maintenance with a release 4 days old and last commit on 2026-08-10 suggests current support.
License · maintenance · safety
MIT (permissive) — MIT license is permissive; you can use, modify, and distribute this package with minimal restrictions, though you must include the license notice.
last release 2026-08-10 (4 days) · last repo commit 2026-08-10 · 46 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 93,386 downloads/mo, #13,388 on PyPI
Alternatives
Verify before relying
pip install duckdb-extension-httpfs
import duckdb
print(duckdb.sql("SELECT installed FROM duckdb_extensions() WHERE extension_name='httpfs'").fetchone()[0])- Whether the extension supports all remote protocols (HTTP, HTTPS, S3, GCS) or only HTTP/HTTPS.
- Performance characteristics when querying large remote files or high-latency sources.
- Whether authentication (API keys, credentials) for remote sources is supported.
- How to import and activate the extension in practice beyond verification steps shown.
What it is and what it does
This package provides DuckDB's httpfs extension as a Python package, enabling direct SQL queries against data stored on remote servers via HTTP/HTTPS without staging files locally. It installs as a specialized extension for duckdb and integrates with DuckDB's extension system to make remote files queryable as if they were local.
The package is actively maintained and supports Python 3.9 through 3.13 across multiple platforms (macOS, Linux, Windows). Installation requires duckdb as a runtime dependency, and platform-specific wheels are provided to minimize compilation overhead. Once installed, the httpfs extension becomes available for use in DuckDB queries.
Use it for
- Query CSV or Parquet files hosted on a web server without downloading them first.
- Build data pipelines that read from remote HTTP endpoints and transform with SQL.
- Analyze datasets stored remotely without local disk overhead.
- Prototype analytics on remote data sources accessed via HTTP/HTTPS.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you use duckdb and need to query remote files over HTTP/HTTPS.
The package is actively maintained, has no known vulnerabilities, uses a permissive MIT license, and medium install friction is acceptable for a specialized extension. Install only if you have duckdb already in your environment and a concrete use case for remote file access.
Install
duckdb-extension-httpfs on PyPI
Before you install
Medium install friction due to platform-specific wheel distributions (macOS arm64/x86_64, Linux aarch64/x86_64, Windows amd64). Active maintenance with a release 4 days old and last commit on 2026-08-10 suggests current support.
Requires duckdb as a runtime dependency; platform-specific wheels require a compatible Python version (3.9–3.13) and CPU architecture.
License in practice
MIT license is permissive; you can use, modify, and distribute this package with minimal restrictions, though you must include the license notice.
Quickstart
pip install duckdb-extension-httpfs
import duckdb
print(duckdb.sql("SELECT installed FROM duckdb_extensions() WHERE extension_name='httpfs'").fetchone()[0])Verify before relying
- Whether the extension supports all remote protocols (HTTP, HTTPS, S3, GCS) or only HTTP/HTTPS.
- Performance characteristics when querying large remote files or high-latency sources.
- Whether authentication (API keys, credentials) for remote sources is supported.
- How to import and activate the extension in practice beyond verification steps shown.
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Medium. Platform-specific wheel |
| Runtime dependencies | 1 packageduckdb |
| Maintenance | Actively maintained 4 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 93,386 / month, #13,388 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaLicense :: OSI Approved :: MIT LicenseProgramming Language :: PythonProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.9Programming Language :: Python :: Implementation :: CPythonProgramming Language :: Python :: Implementation :: PyPy |
Evidence: duckdb_extension_httpfs-1.5.5-py3-none-macosx_11_0_arm64.whl; duckdb_extension_httpfs-1.5.5-py3-none-macosx_11_0_x86_64.whl; duckdb_extension_httpfs-1.5.5-py3-none-manylinux2014_aarch64.whl; duckdb_extension_httpfs-1.5.5-py3-none-manylinux2014_x86_64.whl; duckdb_extension_httpfs-1.5.5-py3-none-win_amd64.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “duckdb http remote file access”
- duckdb-extension-httpfsEnables DuckDB to query data over HTTP/HTTPS by providing the httpfs…
- remotezipDownload individual files from remote zip archives without fetching…
- duckdbDuckDB is an in-process SQL database engine that executes analytical…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also duckdb-extensions · dbt-duckdb · duckdb · duckdb-engine · substrait · dagster-duckdb · fdb · fakesnow · mad-prefect