Skip to main content

adbc-driver-warpsql

A Python ADBC driver for the Warp SQL protocol: SQL over plain HTTP, with results, parameters and bulk uploads as Arrow IPC streams. It is generic: it talks to any Warp SQL server.

The driver itself is a native Go library (libadbc_driver_warpsql) bundled in the platform wheel; this package adds a DB-API 2.0 connect().

Usage

from adbc_driver_warpsql import dbapi

with dbapi.connect(
    uri="warp://db.example.com:31337",  # HTTPS; add ?tls=false for plain HTTP
    username="joe",
    password="…",
) as conn:
    with conn.cursor() as cur:
        cur.execute(operation="SELECT n_name FROM nation WHERE n_nationkey = ?", parameters=[24])
        print(cur.fetch_arrow_table())

        cur.execute(operation="CREATE TABLE t (id INTEGER)")  # runs right away
        cur.adbc_ingest(table_name="t", data=my_arrow_table, mode="append")

connect() takes:

Argument Meaning
uri warp://host:port[/base-path] (TLS), ?tls=false for plain HTTP; https:// and http:// URLs work too. profile://name names a connection profile.
username, password Password sign-in (any characters, : included).
access_token A Warp SQL access token obtained elsewhere, instead of a password.
auth_type "password" (default), "client_certificate" ("mtls"): sign in with tls_client_cert/tls_client_key alone, no password (the server binds the token to the certificate), or "oauth_browser": sign in through a browser with the server's identity provider (servers with capability oauth_browser).
open_browser Browser sign-in: True (default) opens the system's browser, False prints the sign-in URL to stderr, a string is the command that opens it.
oauth_timeout_seconds Browser sign-in: how long the person has to sign in (default 300).
tls_root_certs CA certificates to trust (PEM text or file path).
tls_client_cert, tls_client_key Client certificate for mutual TLS (PEM text or path).
tls_skip_verify Skip certificate verification (development only; off unless set).
catalog, db_schema Make these current for the session.
autocommit True by default; False starts a transaction (conn.commit(), conn.rollback()).
profile An ADBC connection profile.
db_kwargs, conn_kwargs Any other driver option, e.g. adbc.warp.statement.async.

Driver options are in adbc_driver_warpsql.DatabaseOptions, ConnectionOptions and StatementOptions; the repository README lists them all.

By default, on a server that offers it, a large result is read over up to 8 connections at once (StatementOptions.RESULT_PARTITIONS), and an adbc_ingest of two batches or more is sent as up to 8 parts at once and committed as one, all or nothing (StatementOptions.INGEST_PARTS). Set either to "1" for one stream; a partitioned ingest's rows land in no defined order.

Errors are adbc_driver_manager exceptions whose details carry the server's error code (b"warp.code", e.g. b"sql_error") and request id (b"warp.request_id").

Development

See the repository: build the library with make -C go lib, then pip install -e "python[test]". Unit tests need no server; the integration tests start the server named by WARP_SQL_ADBC_TEST_SERVER_BINARY and fail without it.

Metadata

Release files for adbc-driver-warpsql 1.0.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-warpsql 1.0.0
File
adbc_driver_warpsql-1.0.0-py3-none-win_amd64.whl Python 3 none Windows x86-64 Details
adbc_driver_warpsql-1.0.0-py3-none-manylinux2014_aarch64.manylinux_2_17_aarch64.whl Python 3 none Linux glibc 2.17+ ARM64 Details
adbc_driver_warpsql-1.0.0-py3-none-manylinux1_x86_64.manylinux_2_5_x86_64.whl Python 3 none Linux glibc 2.5+ x86-64 Details
adbc_driver_warpsql-1.0.0-py3-none-macosx_11_0_x86_64.whl Python 3 none macOS 11.0+ x86-64 Details
adbc_driver_warpsql-1.0.0-py3-none-macosx_11_0_arm64.whl Python 3 none macOS 11.0+ ARM64 Details

Total release size: 54.3 MB

Release files / adbc_driver_warpsql-1.0.0-py3-none-win_amd64.whl

Download URL adbc_driver_warpsql-1.0.0-py3-none-win_amd64.whl
Size 11.1 MB
Tags Python 3 Windows x86-64
SHA-256 checksum
How to use checksums
f511f0640a8d38338ef80af17142786ee199c871b7d015559eb555534f221da9
BLAKE2b-256 checksum
How to use checksums
d2f1d77a689426c81656d4d46acfb4a47d4419b2609a91f4d93376f21efa3c08
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 log

Release files / adbc_driver_warpsql-1.0.0-py3-none-manylinux2014_aarch64.manylinux_2_17_aarch64.whl

Download URL adbc_driver_warpsql-1.0.0-py3-none-manylinux2014_aarch64.manylinux_2_17_aarch64.whl
Size 10.6 MB
Tags Linux glibc 2.17+ ARM64 Python 3
SHA-256 checksum
How to use checksums
5318943404ec668cd69bbf02a6cc9cf4093fb71bc73b3464dda725d861dd5189
BLAKE2b-256 checksum
How to use checksums
7807e29cbcecfe1c0d48acb53266e871b737ad1229c464c552bfd2dcca79fca2
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 log

Release files / adbc_driver_warpsql-1.0.0-py3-none-manylinux1_x86_64.manylinux_2_5_x86_64.whl

Download URL adbc_driver_warpsql-1.0.0-py3-none-manylinux1_x86_64.manylinux_2_5_x86_64.whl
Size 12.0 MB
Tags Linux glibc 2.5+ x86-64 Python 3
SHA-256 checksum
How to use checksums
c5c0017ff8a3a842ff01ba7a3056cd27b49822b468447e23bff54610856720db
BLAKE2b-256 checksum
How to use checksums
dd9c7bf5f8579828dbf12d7526034bfddbaa8959ec7be6072bbd833911b169f0
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 log

Release files / adbc_driver_warpsql-1.0.0-py3-none-macosx_11_0_x86_64.whl

Download URL adbc_driver_warpsql-1.0.0-py3-none-macosx_11_0_x86_64.whl
Size 10.9 MB
Tags Python 3 macOS 11.0+ x86-64
SHA-256 checksum
How to use checksums
bffc09a3d2b9b8b7ff1c4062b9ff0beae2c188d0b8c1cb84b3e44c4c6c1b2169
BLAKE2b-256 checksum
How to use checksums
fe47867f13f75ab8747f78193ad68cec77a71d2040bb28a738df3701d0a44439
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 log

Release files / adbc_driver_warpsql-1.0.0-py3-none-macosx_11_0_arm64.whl

Download URL adbc_driver_warpsql-1.0.0-py3-none-macosx_11_0_arm64.whl
Size 9.7 MB
Tags Python 3 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
088a457b7c7e205f7d175877b49825f62f718d874aae242b379edf17b6fce899
BLAKE2b-256 checksum
How to use checksums
30a5553e7e5edc49286c7f5c3282ceb973475531f6cb0d7ab2ca96255dc57c0f
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 log

Security for adbc-driver-warpsql 1.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 5 files in this release have been uploaded with provenance metadata.

Select from 5 files

Attestation for adbc_driver_warpsql-1.0.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 Oct 21, 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.

Release history Release notifications | RSS feed

This release

1.0.0 This release

5 release files Full provenance

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