firebolt-sdk
Python SDK for Firebolt
Decision gist · record as of 2026-08-14
Yes. Active maintenance, low install friction, permissive license, and no known vulnerabilities make this a solid choice for Python applications needing Firebolt connectivity. The standard DB API 2.0 interface means minimal learning curve for developers familiar with Python database libraries. Install it if you are working with Firebolt; the only caveat is to respect the cursor thread-safety constraint in multi-threaded code.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python >=3.9; Firebolt account credentials (account_name, client_id, client_secret) must be available.
- Low friction install with a pure-Python wheel.
- Active maintenance with recent releases; last commit 2026-08-14.
License · maintenance · safety
Apache-2.0 (permissive) — Apache License 2.0 (permissive) allows use in commercial and open-source projects with minimal restrictions; you must include a copy of the license and note any modifications.
last release 2026-04-16 (120 days) · last repo commit 2026-08-14 · 16 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 298,926 downloads/mo, #7,865 on PyPI
Alternatives
Verify before relying
pip install firebolt-sdk
from firebolt.db import connect
conn = connect(
account_name="your_account",
client_id="your_client_id",
client_secret="your_client_secret",
database="your_database"
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM table")
results = cursor.fetchall()- Performance characteristics and query latency expectations for typical workloads.
- Whether optional ciso8601 dependency is automatically installed or requires explicit opt-in.
- Concurrency model details beyond the stated cursor thread-safety level 2.
What it is and what it does
Firebolt-sdk is a Python database driver that implements the DB API 2.0 specification for connecting to Firebolt, a cloud analytics database. It handles authentication via client credentials, manages connections and cursors, and provides standard SQL execution and result-fetching methods. The package uses async I/O under the hood (httpx, anyio, trio) to support non-blocking operations, though the public API presents a synchronous DB API interface.
The SDK is designed for analytics workloads where you need to execute SQL queries against Firebolt and retrieve results. It supports switching between databases and engines via SQL commands, but enforces restrictions on certain SET parameters to prevent misconfiguration. Cursors are not thread-safe and must not be shared across threads, though connections can be; this aligns with DB API thread-safety level 2. An optional faster datetime parser (ciso8601) can be installed separately for performance-critical applications.
Use it for
- Execute SQL queries against a Firebolt database from a Python application or script.
- Build ETL pipelines that read from or write to Firebolt using standard DB API patterns.
- Integrate Firebolt analytics into Jupyter notebooks or data science workflows.
- Connect multiple Python threads to the same Firebolt database (each with its own cursor).
- Optimize datetime parsing in high-volume query result processing with the ciso8601 extra.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
Active maintenance, low install friction, permissive license, and no known vulnerabilities make this a solid choice for Python applications needing Firebolt connectivity. The standard DB API 2.0 interface means minimal learning curve for developers familiar with Python database libraries. Install it if you are working with Firebolt; the only caveat is to respect the cursor thread-safety constraint in multi-threaded code.
Install
firebolt-sdk on PyPI
Before you install
Low friction install with a pure-Python wheel. Active maintenance with recent releases; last commit 2026-08-14. Requires Python >=3.9 and brings in 15 runtime dependencies including httpx, pydantic, and cryptography for async HTTP and credential handling.
Requires Python >=3.9; Firebolt account credentials (account_name, client_id, client_secret) must be available.
License in practice
Apache License 2.0 (permissive) allows use in commercial and open-source projects with minimal restrictions; you must include a copy of the license and note any modifications.
Quickstart
pip install firebolt-sdk
from firebolt.db import connect
conn = connect(
account_name="your_account",
client_id="your_client_id",
client_secret="your_client_secret",
database="your_database"
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM table")
results = cursor.fetchall()Verify before relying
- Performance characteristics and query latency expectations for typical workloads.
- Whether optional ciso8601 dependency is automatically installed or requires explicit opt-in.
- Concurrency model details beyond the stated cursor thread-safety level 2.
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 15 packagesaiorwlockanyioappdirsappdirs-stubsasync-generatorasync-propertycryptographyhttpcorehttpxpydanticpython-dateutilreaderwriterlocksqlparsetriotruststore |
| Maintenance | Actively maintained 120 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 298,926 / month, #7,865 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3Programming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.9 |
Evidence: firebolt_sdk-1.18.6-py3-none-any.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 › “firebolt database python client”
- firebolt-sdkFirebolt-sdk provides a Python DB API 2.0-compatible interface to…
- ydbYDB Python SDK is the official client library for connecting to and…
- libsql-clientPython SDK for connecting to and querying libSQL databases,…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
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.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
See also mariadb · pymssql · pyodbc · adbc-driver-sqlite · hdbcli · ydb-dbapi · pyhdb · pydynamodb · PyAthena · pykeepass