Installation¶
Install SQLSpec with a database adapter and the Google ADK SDK.
uv add "sqlspec[asyncpg,adk]"
pip install "sqlspec[asyncpg,adk]"
poetry add "sqlspec[asyncpg,adk]"
pdm add "sqlspec[asyncpg,adk]"
uv add "sqlspec[aiosqlite,adk]"
pip install "sqlspec[aiosqlite,adk]"
poetry add "sqlspec[aiosqlite,adk]"
pdm add "sqlspec[aiosqlite,adk]"
asyncmy is the recommended async MySQL extra. aiomysql is also
supported via sqlspec[aiomysql,adk] when an application already uses
that driver.
uv add "sqlspec[asyncmy,adk]"
pip install "sqlspec[asyncmy,adk]"
poetry add "sqlspec[asyncmy,adk]"
pdm add "sqlspec[asyncmy,adk]"
uv add "sqlspec[cockroach-asyncpg,adk]"
pip install "sqlspec[cockroach-asyncpg,adk]"
poetry add "sqlspec[cockroach-asyncpg,adk]"
pdm add "sqlspec[cockroach-asyncpg,adk]"
uv add "sqlspec[duckdb,adk]"
pip install "sqlspec[duckdb,adk]"
poetry add "sqlspec[duckdb,adk]"
pdm add "sqlspec[duckdb,adk]"
What This Provides¶
The adk extra includes the Google ADK SDK (google-genai). SQLSpec provides:
Session Service -- Persist ADK agent sessions and events to your database with atomic
append_event_and_update_state()writes.Memory Service -- Store agent memory with database-native full-text search for context retrieval across conversations.
Artifact Service contracts -- Compose a concrete metadata store with pluggable object storage backends when your deployment needs ADK artifacts.
Event Storage -- Full-event JSON storage (EventRecord) that captures the entire ADK Event without schema drift.
Next Steps¶
Proceed to Quickstart to set up stores for your ADK agent, or see Backends for the full support matrix.