Skip to main content

adbc-driver-quack - by GizmoData™

CI Supported Python Versions PyPI version PyPI Downloads DuckDB 2.0 ADBC conformance Follows the ADBC driver style guide License Hardcharger

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-manager and pyarrow.
  • 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

Licensed under the MIT License.


GizmoData™
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)

Table of built distributions (wheels) for adbc-driver-quack 1.1.0
File Actions
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 log

Release 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 log

Release 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 log

Release 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 log

Security 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.

Select from 4 files

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 log

A 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.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page