Installation

Install SQLSpec with the extras that match your databases and tooling.

Install bundles

uv

uv add sqlspec

pip

pip install sqlspec

Poetry

poetry add sqlspec

PDM

pdm add sqlspec

Performance bundle

For production deployments, install the performance extra for Rust-backed hot-path helpers and high-speed serialization, or the mypyc extra for C-compiled internals:

uv

uv add "sqlspec[performance]"

pip

pip install "sqlspec[performance]"

Poetry

poetry add "sqlspec[performance]"

PDM

pdm add "sqlspec[performance]"

Package groups

Extra	Includes	What it is for
adbc	adbc_driver_manager, pyarrow	Arrow Database Connectivity drivers.
adk	google-adk	Google ADK storage extension.
aiomysql	aiomysql	Async MySQL driver.
aiosqlite	aiosqlite	Async SQLite driver.
alloydb	google-cloud-alloydb-connector	AlloyDB connector.
arrow-odbc	arrow-odbc, pyarrow	ODBC Arrow export and ingest.
asyncmy	asyncmy	Async MySQL driver.
asyncpg	asyncpg	Async PostgreSQL driver.
attrs	attrs, cattrs	Result mapping with attrs models.
bigquery	google-cloud-bigquery, google-cloud-bigquery-storage, google-cloud-storage	BigQuery adapter dependencies.
cloud-sql	cloud-sql-python-connector	Google Cloud SQL connector.
cockroachdb	psycopg[binary,pool], asyncpg	CockroachDB drivers.
duckdb	duckdb, pytz	DuckDB adapter.
fastapi	fastapi	FastAPI integration helpers.
flask	flask	Flask integration helpers.
fsspec	fsspec	Storage helpers using fsspec.
litestar	litestar	Litestar integration helpers.
msgspec	msgspec	High-performance result mapping.
mssql-python	mssql-python	Microsoft SQL Server driver.
mypyc	sqlglot[c]	C-compiled sqlglot internals for faster SQL parsing.
mysql-connector	mysql-connector-python	MySQL connector driver.
nanoid	fastnanoid	NanoID utilities.
obstore	obstore	Object storage helpers.
opentelemetry	opentelemetry-instrumentation	OpenTelemetry instrumentation.
oracledb	oracledb	Oracle Database adapter.
orjson	orjson	Fast JSON serialization.
pandas	pandas, pyarrow	Pandas data export.
performance	librt, msgspec	Runtime helpers for compiled hot paths and high-speed serialization.
polars	polars, pyarrow	Polars data export.
prometheus	prometheus-client	Prometheus metrics.
psqlpy	psqlpy	Async PostgreSQL (Rust).
psycopg	psycopg[binary,pool]	Sync/async PostgreSQL driver.
pydantic	pydantic, pydantic-extra-types	Result mapping with Pydantic models.
pymssql	pymssql	MSSQL driver.
pymysql	pymysql	MySQL driver.
sanic	sanic	Sanic integration helpers.
spanner	google-cloud-spanner	Cloud Spanner adapter.
starlette	starlette	Starlette integration helpers.
uuid	uuid-utils	UUID helpers.

Multiple extras

uv

uv add "sqlspec[asyncpg,msgspec,litestar]"

pip

pip install "sqlspec[asyncpg,msgspec,litestar]"

Poetry

poetry add "sqlspec[asyncpg,msgspec,litestar]"

PDM

pdm add "sqlspec[asyncpg,msgspec,litestar]"

Next steps

Head to Quickstart to run your first query.