Installation

Install SQLSpec with a database adapter and the Google ADK SDK.

PostgreSQL (recommended)

uv

uv add "sqlspec[asyncpg,adk]"

pip

pip install "sqlspec[asyncpg,adk]"

Poetry

poetry add "sqlspec[asyncpg,adk]"

PDM

pdm add "sqlspec[asyncpg,adk]"

SQLite

uv

uv add "sqlspec[aiosqlite,adk]"

pip

pip install "sqlspec[aiosqlite,adk]"

Poetry

poetry add "sqlspec[aiosqlite,adk]"

PDM

pdm add "sqlspec[aiosqlite,adk]"

MySQL

asyncmy is the recommended async MySQL extra. aiomysql is also supported via sqlspec[aiomysql,adk] when an application already uses that driver.

uv

uv add "sqlspec[asyncmy,adk]"

pip

pip install "sqlspec[asyncmy,adk]"

Poetry

poetry add "sqlspec[asyncmy,adk]"

PDM

pdm add "sqlspec[asyncmy,adk]"

CockroachDB

uv

uv add "sqlspec[cockroach-asyncpg,adk]"

pip

pip install "sqlspec[cockroach-asyncpg,adk]"

Poetry

poetry add "sqlspec[cockroach-asyncpg,adk]"

PDM

pdm add "sqlspec[cockroach-asyncpg,adk]"

DuckDB

uv

uv add "sqlspec[duckdb,adk]"

pip

pip install "sqlspec[duckdb,adk]"

Poetry

poetry add "sqlspec[duckdb,adk]"

PDM

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 (StoredEvent) 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.