Google ADK Extension¶
SQLSpec provides a full-featured backend for Google Agent Development Kit, covering session, event, memory, and artifact storage with SQL-backed persistence across 14 database adapters.
Key capabilities:
Session and event storage with atomic
append_event_and_update_state()ensuring events and state are always consistent.Full-event JSON storage (EventRecord) that captures the entire ADK Event in a single column, eliminating schema drift with upstream ADK releases.
Scoped state semantics (
app:,user:,temp:) for controlling state visibility and persistence across sessions.Memory service with database-native full-text search (tsvector, FTS5, InnoDB FT) for long-term agent context.
Artifact service with append-only versioning, SQL metadata, and pluggable object storage backends.
Choose a guide¶
Install the extension and configure the service.
Persist sessions, memory, and artifacts with minimal setup.
See which backends are recommended, supported, or reduced-scope.
Configure supported SQLSpec adapters for ADK.
Table layouts, EventRecord, scoped state, and artifact metadata.
Services, stores, and record types.
Apply schema changes safely over time.