github-mirror/n8n
1
0
Fork 0
mirror of https://github.com/n8n-io/n8n.git synced 2026-10-18 23:09:03 +02:00
Code Issues Actions 15 Packages Projects Releases Wiki Activity Graph
agent-messaging-queue
n8n/docs/generated/postgres-schema/public.agent_session_lease.md
Robin Braumann 04805d2203
feat(core): Add agent session lease table (no-changelog) 
Add the agent_session_lease table with one row for each agent session.
A turn will take the lease in the transaction that records its execution,
so that only one turn runs on a session at a time.

The row keeps its epoch after release and after session deletion, so the
epoch of a thread ID only increases.

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
2026-09-23 11:56:07 +02:00

2.8 KiB
Generated
Raw Permalink Blame History

public.agent_session_lease

Columns

Name Type Default Nullable Children Parents Comment
agentId varchar(36) false public.agents
createdAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false
epoch integer 0 false Incremented on each acquisition and never reset
executionId varchar(36) true Execution that holds the lease; no foreign key, the lease outlives it
expiresAt timestamp(3) with time zone true Database-clock time after which another main can take over; NULL when free
ownerHostId varchar(255) true Host ID of the main that holds the lease; NULL when free
ownerToken uuid true Token of the current holder, new for each acquisition; NULL when free
threadId varchar(128) false
updatedAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false

Constraints

Name Type Definition
FK_d638dff52c334190c7407c22d9b FOREIGN KEY FOREIGN KEY ("agentId") REFERENCES agents(id) ON DELETE CASCADE
PK_0bf734bd7afb9d81f91ddf6c667 PRIMARY KEY PRIMARY KEY ("threadId")
agent_session_lease_agentId_not_null n NOT NULL "agentId"
agent_session_lease_createdAt_not_null n NOT NULL "createdAt"
agent_session_lease_epoch_not_null n NOT NULL epoch
agent_session_lease_threadId_not_null n NOT NULL "threadId"
agent_session_lease_updatedAt_not_null n NOT NULL "updatedAt"

Indexes

Name Definition
IDX_d638dff52c334190c7407c22d9 CREATE INDEX "IDX_d638dff52c334190c7407c22d9" ON public.agent_session_lease USING btree ("agentId")
PK_0bf734bd7afb9d81f91ddf6c667 CREATE UNIQUE INDEX "PK_0bf734bd7afb9d81f91ddf6c667" ON public.agent_session_lease USING btree ("threadId")

Relations

erDiagram

"public.agent_session_lease" }o--|| "public.agents" : "FOREIGN KEY (#quot;agentId#quot;) REFERENCES agents(id) ON DELETE CASCADE"

"public.agent_session_lease" {
  varchar_36_ agentId FK
  timestamp_3__with_time_zone createdAt
  integer epoch
  varchar_36_ executionId
  timestamp_3__with_time_zone expiresAt
  varchar_255_ ownerHostId
  uuid ownerToken
  varchar_128_ threadId
  timestamp_3__with_time_zone updatedAt
}
"public.agents" {
  varchar_36_ activeVersionId FK
  boolean availableInMCP
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  json integrations
  varchar_128_ name
  varchar_255_ projectId FK
  integer revision
  json schema
  timestamp_3__with_time_zone setupCompletedAt
  json skills
  json tools
  timestamp_3__with_time_zone updatedAt
  varchar_36_ versionId
}

Generated by tbls