adk-postgres Session Table — Schema Deep Dive

CREATE TABLE adk_sessions (
  id            uuid PRIMARY KEY,
  user_id       text NOT NULL,
  agent_name    text NOT NULL,
  created_at    timestamptz NOT NULL DEFAULT now(),
  updated_at    timestamptz NOT NULL DEFAULT now(),
  status        text NOT NULL DEFAULT 'active',
  metadata      jsonb NOT NULL DEFAULT '{}'::jsonb,
  last_message  text,
  message_count int NOT NULL DEFAULT 0
);

CREATE INDEX ON adk_sessions (user_id, updated_at DESC);
CREATE INDEX ON adk_sessions (status) WHERE status <> 'closed';
CREATE INDEX ON adk_sessions USING GIN (metadata);