Agent Eval Result · SQLite Schema · n8n-io/n8n · Skills Docs

Agent Eval Result · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "agent_eval_result" ("id" varchar(36) PRIMARY KEY NOT NULL, "runId" varchar(36) NOT NULL, "sourceRowId" varchar(255), "runIndex" integer, "status" varchar NOT NULL, "input" text, "output" text, "toolCalls" text, "metrics" text, "runAt" datetime(3), "completedAt" datetime(3), "errorCode" varchar(255), "errorDetails" text, "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "verdict" JSON, CONSTRAINT "CHK_agent_eval_result_status" CHECK ("status" IN ('new', 'running', 'success', 'error', 'cancelled')), CONSTRAINT "FK_40a2d1248a6d984f442de2fac1b" FOREIGN KEY ("runId") REFERENCES "agent_eval_run" ("id") ON DELETE CASCADE)

Name	Type	Default	Nullable	Children	Parents	Comment
completedAt	datetime(3)		true
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
errorCode	varchar(255)		true
errorDetails	TEXT		true
id	varchar(36)		false	agent_eval_rating
input	TEXT		true
metrics	TEXT		true
output	TEXT		true
runAt	datetime(3)		true
runId	varchar(36)		false		agent_eval_run
runIndex	INTEGER		true
sourceRowId	varchar(255)		true
status	varchar		false
toolCalls	TEXT		true
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
verdict	JSON		true

Name	Type	Definition
-	CHECK	CHECK (“status” IN (‘new’, ‘running’, ‘success’, ‘error’, ‘cancelled’))
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (runId) REFERENCES agent_eval_run (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_agent_eval_result_1	PRIMARY KEY	PRIMARY KEY (id)

erDiagram

"agent_eval_rating" }o--|| "agent_eval_result" : "FOREIGN KEY (resultId) REFERENCES agent_eval_result (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_eval_result" }o--|| "agent_eval_run" : "FOREIGN KEY (runId) REFERENCES agent_eval_run (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"agent_eval_result" {
  datetime_3_ completedAt
  datetime_3_ createdAt
  varchar_255_ errorCode
  TEXT errorDetails
  varchar_36_ id PK
  TEXT input
  TEXT metrics
  TEXT output
  datetime_3_ runAt
  varchar_36_ runId FK
  INTEGER runIndex
  varchar_255_ sourceRowId
  varchar status
  TEXT toolCalls
  datetime_3_ updatedAt
  JSON verdict
}
"agent_eval_rating" {
  TEXT comment
  TEXT correction
  datetime_3_ createdAt
  varchar_36_ id PK
  varchar ratedById FK
  varchar_36_ resultId FK
  datetime_3_ updatedAt
  varchar_8_ vote
}
"agent_eval_run" {
  varchar_36_ agentVersionId
  boolean cancelRequested
  datetime_3_ completedAt
  datetime_3_ createdAt
  varchar createdById FK
  varchar_36_ datasetId FK
  varchar_255_ errorCode
  TEXT errorDetails
  varchar_36_ id PK
  TEXT metrics
  datetime_3_ runAt
  varchar_255_ runningInstanceId
  varchar status
  datetime_3_ updatedAt
}