Adapters¶
SQLSpec ships adapter packages for each supported database or driver. Each adapter exports a typed config class and a driver implementation.
Async PostgreSQL via asyncpg.
Sync + Async PostgreSQL via psycopg.
Async PostgreSQL via psqlpy (Rust).
Sync SQLite via stdlib sqlite3.
Async SQLite via aiosqlite.
Sync DuckDB with Arrow support.
Sync + Async Oracle via oracledb.
Sync + Async MySQL via mysql-connector-python.
Sync MySQL via PyMySQL.
Async MySQL via asyncmy.
Async MySQL via aiomysql.
Google BigQuery.
Google Cloud Spanner.
Async CockroachDB via asyncpg.
Sync + Async CockroachDB via psycopg.
Arrow Database Connectivity.
Feature Comparison¶
Adapter |
Sync |
Async |
Connection Pool |
Arrow Support |
Native Pipelines |
|---|---|---|---|---|---|
asyncpg |
Yes |
Yes |
Yes |
Yes |
|
psycopg |
Yes |
Yes |
Yes |
Yes |
Yes |
psqlpy |
Yes |
Yes |
Yes |
||
sqlite |
Yes |
Yes |
|||
aiosqlite |
Yes |
Yes |
|||
duckdb |
Yes |
Yes |
Yes |
||
oracledb |
Yes |
Yes |
Yes |
Yes |
|
mysql-connector |
Yes |
Yes |
Yes |
||
pymysql |
Yes |
Yes |
|||
asyncmy |
Yes |
Yes |
|||
aiomysql |
Yes |
Yes |
|||
bigquery |
Yes |
Yes |
|||
spanner |
Yes |
Yes |
|||
cockroach (asyncpg) |
Yes |
Yes |
Yes |
Yes |
|
cockroach (psycopg) |
Yes |
Yes |
Yes |
Yes |
Yes |
adbc |
Yes |
Yes |