Backends

ADK stores are implemented per adapter. Use the backend config helpers when connecting to multiple databases or configuring advanced options.

Example

adk backend config
from sqlspec.adapters.adbc import AdbcConfig

adk_config = {
    "session_table": "adk_sessions",
    "events_table": "adk_events",
    "memory_table": "adk_memory_entries",
    "memory_use_fts": True,
}

gizmo = AdbcConfig(
    connection_config={"driver_name": "gizmosql", "gizmosql_backend": "duckdb"},
    extension_config={"adk": adk_config},
)

Supported Backends

Adapter

Status

asyncpg

Production

psycopg

Production

psqlpy

Production

asyncmy

Production

sqlite

Production

aiosqlite

Production

oracledb

Production

duckdb

Production (analytics)

bigquery

Production

adbc

Production

Notes

  • Use async backends for ADK runners; sync backends can be wrapped with anyio.

  • Backend stores expose create_tables to bootstrap schema.