ADK Ex Ecto

Ecto-backed session persistence for the Elixir ADK (adk_ex).

Implements ADK.Session.Service using Ecto, providing database-backed session storage with support for SQLite3 (dev/test) and PostgreSQL (production).

Installation

Add adk_ex_ecto to your dependencies:

def deps do
  [
    {:adk_ex, "~> 0.1"},
    {:adk_ex_ecto, "~> 1.0"},
    {:ecto_sqlite3, "~> 0.17"},   # or {:postgrex, "~> 0.19"} for PostgreSQL
  ]
end

Setup

1. Create a migration

Add a migration to your project that creates the 4 ADK tables:

defmodule MyApp.Repo.Migrations.CreateADKTables do
  use Ecto.Migration

  def change do
    ADKExEcto.Migration.up()
  end
end

2. Run the migration

mix ecto.migrate

3. Configure your Runner

Pass session_module: ADKExEcto.SessionService and your Repo as session_service to the Runner:

{:ok, runner} = ADK.Runner.new(
  app_name: "my_app",
  root_agent: agent,
  session_service: MyApp.Repo,
  session_module: ADKExEcto.SessionService
)

Database Schema

The migration creates 4 tables matching the Go ADK's database session schema:

Table	Primary Key	Purpose
adk_sessions	(app_name, user_id, id)	Session records with state
adk_events	(id, app_name, user_id, session_id)	Event history with content and actions
adk_app_states	(app_name)	Cross-session app-level state
adk_user_states	(app_name, user_id)	Cross-session user-level state

State Routing

State keys are routed by prefix (matching ADK.Session.InMemory behaviour):

Prefix	Storage	Shared?
(none)	adk_sessions.state	Session-local
app:	adk_app_states.state	All users/sessions for app
user:	adk_user_states.state	All sessions for user
temp:	Not persisted	Current invocation only

Modules

Module	Purpose
ADKExEcto.SessionService	Implements ADK.Session.Service via Ecto
ADKExEcto.Migration	Migration helper (up/0, down/0)
ADKExEcto.Schemas.Session	Ecto schema for adk_sessions
ADKExEcto.Schemas.Event	Ecto schema for adk_events
ADKExEcto.Schemas.AppState	Ecto schema for adk_app_states
ADKExEcto.Schemas.UserState	Ecto schema for adk_user_states

Development

mix deps.get
mix test          # 21 tests
mix credo         # Static analysis
mix dialyzer      # Type checking

License

MIT