adbc-driver-quack - by GizmoData™
Python package for adbc-driver-quack, an Apache Arrow ADBC driver for DuckDB's Quack remote protocol, by GizmoData™: Arrow straight from a remote DuckDB 2.0.
A pure-Go client for Quack, the remote protocol DuckDB 2.0 serves with quack_serve. It returns
Apache Arrow record batches from the server's results, streams large results in batches and
bulk-loads Arrow data into DuckDB tables. No DuckDB library on the client: the driver is a shared
library inside the wheel.
An independent, open-source project. Not affiliated with, endorsed by, or sponsored by the DuckDB Foundation or DuckDB Labs. "DuckDB" is a trademark of the DuckDB Foundation, used here only to describe compatibility.
This page covers the Python package. For other languages (C, C++, Go, Rust, R, DuckDB's
adbc_scanner), the one-line installer of the shared library
(curl https://install.adbc.gizmodata.com/quack | sh), TLS, every connection option, type mapping
and conformance, see the project README on GitHub.
Install
pip install adbc-driver-quack
- Python 3.11 or later.
- Wheels for Linux x86_64 and aarch64 (glibc 2.17 or later), macOS arm64 (13 or later) and Windows x64.
- Depends on
adbc-driver-managerandpyarrow. - A DuckDB 2.0 server (Quack protocol version 3). DuckDB 1.5's preview Quack is not compatible.
Start a server in any DuckDB 2.0 session (quack is a core extension):
INSTALL quack;
LOAD quack;
CALL quack_serve('quack:localhost:9494', token => 'my-secret-token');
Connect and query
from adbc_driver_quack import dbapi as quack
with quack.connect(
uri="quack://localhost:9494",
db_kwargs={"quack.auth.token": "my-secret-token"},
) as conn, conn.cursor() as cur:
cur.execute("SELECT 42 AS answer, 'hello duckdb' AS greeting")
table = cur.fetch_arrow_table() # a pyarrow.Table
print(table)
The result is a pyarrow.Table: pass it to Polars, pandas, DuckDB or anything else that reads
Arrow.
Stream large results
fetch_record_batch() returns a pyarrow.RecordBatchReader that pulls one server batch at a
time, so memory stays bounded by the batch size, not the result size:
from adbc_driver_quack import dbapi as quack
with quack.connect(
uri="quack://localhost:9494",
db_kwargs={"quack.auth.token": "my-secret-token"},
) as conn, conn.cursor() as cur:
cur.execute("SELECT range AS n FROM range(1000000)")
rows = 0
for batch in cur.fetch_record_batch():
rows += batch.num_rows
print(rows)
Bulk ingest (Arrow to DuckDB)
import pyarrow as pa
from adbc_driver_quack import dbapi as quack
data = pa.table({"id": [1, 2, 3], "name": ["a", "b", "c"]})
with quack.connect(
uri="quack://localhost:9494",
db_kwargs={"quack.auth.token": "my-secret-token"},
autocommit=True,
) as conn, conn.cursor() as cur:
cur.adbc_ingest(table_name="pypi_example_people", data=data, mode="replace")
cur.execute("SELECT count(*) AS n FROM pypi_example_people")
print(cur.fetchone())
Load the driver by name (driver manifest)
ADBC driver manifests let the ADBC driver manager, and connection profiles, find a driver by name. The package writes one for its own library:
$ python -m adbc_driver_quack install-manifest
Wrote ADBC driver manifest: .../etc/adbc/drivers/quack.toml
Then the driver manager resolves quack:// URLs with no import of adbc_driver_quack:
from adbc_driver_manager import dbapi
with dbapi.connect(
uri="quack://localhost:9494",
db_kwargs={"quack.auth.token": "my-secret-token"},
) as conn, conn.cursor() as cur:
cur.execute("SELECT 1 AS one")
print(cur.fetch_arrow_table())
Options
Database options are named quack.<group>.<option>, following the
ADBC driver style guide:
quack.auth.token, quack.tls.enabled, quack.tls.certificate_fingerprint,
quack.session.client_id and the others in the
project README
(adbc_driver_quack.DatabaseOptions holds them). Errors read [quack] message. The
adbc.quack.* names from before 1.1 still work, but print a one-line deprecation notice to
stderr the first time each is used in a process.
More
- Project README: every option and feature, other languages, and the one-line installer for the shared library
- Changelog
- Issues
Licensed under the MIT License.
Built by GizmoData™, makers of Hardcharger™. Free and open source.
Hardcharger™ and GizmoData™ are trademarks of GizmoData LLC.
Metadata
Release files for adbc-driver-quack 1.1.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distributions (wheels)
| File | Actions Reset | |||
|---|---|---|---|---|
| adbc_driver_quack-1.1.0-py3-none-win_amd64.whl | Python 3 | none | Windows x86-64 | Details for adbc_driver_quack-1.1.0-py3-none-win_amd64.whl |
| adbc_driver_quack-1.1.0-py3-none-manylinux2014_x86_64.whl | Python 3 | none | Linux glibc 2.17+ x86-64 | Details for adbc_driver_quack-1.1.0-py3-none-manylinux2014_x86_64.whl |
| adbc_driver_quack-1.1.0-py3-none-manylinux2014_aarch64.whl | Python 3 | none | Linux glibc 2.17+ ARM64 | Details for adbc_driver_quack-1.1.0-py3-none-manylinux2014_aarch64.whl |
| adbc_driver_quack-1.1.0-py3-none-macosx_13_0_arm64.whl | Python 3 | none | macOS 13.0+ ARM64 | Details for adbc_driver_quack-1.1.0-py3-none-macosx_13_0_arm64.whl |
Total release size: 37.7 MB
Release files / adbc_driver_quack-1.1.0-py3-none-win_amd64.whl
| Download URL | adbc_driver_quack-1.1.0-py3-none-win_amd64.whl |
|---|---|
| Size | 11.3 MB |
| Tags | Python 3 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
4cb4d47579b08e9d40f1556f17a5954e396a914c9760b11a19d05652d5150df5
|
|
BLAKE2b-256 checksum How to use checksums |
3f2af47ea4a76e471b587389f0312440ca26763d2a897e4b0bc33212b392470d
|
| 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 Nov 20, 2026.
Transparency logRelease files / adbc_driver_quack-1.1.0-py3-none-manylinux2014_x86_64.whl
| Download URL | adbc_driver_quack-1.1.0-py3-none-manylinux2014_x86_64.whl |
|---|---|
| Size | 11.0 MB |
| Tags | Linux glibc 2.17+ x86-64 Python 3 |
|
SHA-256 checksum How to use checksums |
5139c914c427f50d48eb3d506ce62f754beabb36dcfe7ce3a8224840761110b3
|
|
BLAKE2b-256 checksum How to use checksums |
c129b232cdd657c3af35824ee2ed213ad14c5f7e03d3141eb86e952f990e98b6
|
| 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 Nov 20, 2026.
Transparency logRelease files / adbc_driver_quack-1.1.0-py3-none-manylinux2014_aarch64.whl
| Download URL | adbc_driver_quack-1.1.0-py3-none-manylinux2014_aarch64.whl |
|---|---|
| Size | 10.0 MB |
| Tags | Linux glibc 2.17+ ARM64 Python 3 |
|
SHA-256 checksum How to use checksums |
79697e1e7a92c27fc1d7d83382cf60079ce7303bba314f52125470c0fa163d4f
|
|
BLAKE2b-256 checksum How to use checksums |
c4d3801dd231dd3c5650a520f5f92d7eab5ac52dc033324b61e85175580ddb4b
|
| 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 Nov 20, 2026.
Transparency logRelease files / adbc_driver_quack-1.1.0-py3-none-macosx_13_0_arm64.whl
| Download URL | adbc_driver_quack-1.1.0-py3-none-macosx_13_0_arm64.whl |
|---|---|
| Size | 5.4 MB |
| Tags | Python 3 macOS 13.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
d3bf97b5f8d745bcede0784546ff9e12e390d76c36c181f39c4c0acfe06549ce
|
|
BLAKE2b-256 checksum How to use checksums |
236bfbadb88890c25e79483fe98340d2c1ce34a781f9bc0e13279b1abe4caa55
|
| 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 Nov 20, 2026.
Transparency logSecurity for adbc-driver-quack 1.1.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 4 files in this release have been uploaded with provenance metadata.
Attestation for adbc_driver_quack-1.1.0-py3-none-win_amd64.whl
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 Nov 20, 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.
To learn more about protecting yourself from malicious actors, visit our package security documentation.