# ORM Client
## Setup
```typescript
import { createClient } from './orm';
const db = createClient({
endpoint: 'https://api.example.com/graphql',
headers: { Authorization: 'Bearer ' },
});
```
## Models
| Model | Operations |
|-------|------------|
| `agent` | findMany, findOne, create, update, delete |
| `agentEvent` | findMany, findOne, create, update, delete |
| `agentMessage` | findMany, findOne, create, update, delete |
| `agentPersona` | findMany, findOne, create, update, delete |
| `agentPlan` | findMany, findOne, create, update, delete |
| `agentPrompt` | findMany, findOne, create, update, delete |
| `agentResourceChunk` | findMany, findOne, create, update, delete |
| `agentResource` | findMany, findOne, create, update, delete |
| `agentRun` | findMany, findOne, create, update, delete |
| `agentRunWorkspace` | findMany, findOne, create, update, delete |
| `agentTask` | findMany, findOne, create, update, delete |
| `agentThread` | findMany, findOne, create, update, delete |
| `platformAgent` | findMany, findOne, create, update, delete |
| `platformAgentEvent` | findMany, findOne, create, update, delete |
| `platformAgentMessage` | findMany, findOne, create, update, delete |
| `platformAgentPersona` | findMany, findOne, create, update, delete |
| `platformAgentPlan` | findMany, findOne, create, update, delete |
| `platformAgentPrompt` | findMany, findOne, create, update, delete |
| `platformAgentResourceChunk` | findMany, findOne, create, update, delete |
| `platformAgentResource` | findMany, findOne, create, update, delete |
| `platformAgentRun` | findMany, findOne, create, update, delete |
| `platformAgentRunWorkspace` | findMany, findOne, create, update, delete |
| `platformAgentTask` | findMany, findOne, create, update, delete |
| `platformAgentThread` | findMany, findOne, create, update, delete |
## Table Operations
### `db.agent`
CRUD operations for Agent records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `config` | JSON | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `id` | UUID | No |
| `isEphemeral` | Boolean | Yes |
| `name` | String | Yes |
| `ownerId` | UUID | Yes |
| `parentId` | UUID | Yes |
| `personaId` | UUID | Yes |
| `status` | String | Yes |
| `systemPrompt` | String | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all agent records
const items = await db.agent.findMany({ select: { config: true, createdAt: true, databaseId: true, id: true, isEphemeral: true, name: true, ownerId: true, parentId: true, personaId: true, status: true, systemPrompt: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.agent.findOne({ id: '', select: { config: true, createdAt: true, databaseId: true, id: true, isEphemeral: true, name: true, ownerId: true, parentId: true, personaId: true, status: true, systemPrompt: true, updatedAt: true } }).execute();
// Create
const created = await db.agent.create({ data: { config: '', databaseId: '', isEphemeral: '', name: '', ownerId: '', parentId: '', personaId: '', status: '', systemPrompt: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agent.update({ where: { id: '' }, data: { config: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agent.delete({ where: { id: '' } }).execute();
```
### `db.agentEvent`
CRUD operations for AgentEvent records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `entry` | JSON | Yes |
| `id` | UUID | No |
| `recordedAt` | Datetime | Yes |
| `runId` | UUID | Yes |
| `seq` | Int | Yes |
| `transcriptFormat` | String | Yes |
| `transcriptVersion` | Int | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all agentEvent records
const items = await db.agentEvent.findMany({ select: { actorId: true, createdAt: true, databaseId: true, entry: true, id: true, recordedAt: true, runId: true, seq: true, transcriptFormat: true, transcriptVersion: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.agentEvent.findOne({ id: '', select: { actorId: true, createdAt: true, databaseId: true, entry: true, id: true, recordedAt: true, runId: true, seq: true, transcriptFormat: true, transcriptVersion: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.agentEvent.create({ data: { actorId: '', databaseId: '', entry: '', recordedAt: '', runId: '', seq: '', transcriptFormat: '', transcriptVersion: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentEvent.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentEvent.delete({ where: { id: '' } }).execute();
```
### `db.agentMessage`
CRUD operations for AgentMessage records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `agentId` | UUID | Yes |
| `authorRole` | String | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `deliveredRunId` | UUID | Yes |
| `id` | UUID | No |
| `kind` | String | Yes |
| `model` | String | Yes |
| `parts` | JSON | Yes |
| `threadId` | UUID | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all agentMessage records
const items = await db.agentMessage.findMany({ select: { actorId: true, agentId: true, authorRole: true, createdAt: true, databaseId: true, deliveredRunId: true, id: true, kind: true, model: true, parts: true, threadId: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.agentMessage.findOne({ id: '', select: { actorId: true, agentId: true, authorRole: true, createdAt: true, databaseId: true, deliveredRunId: true, id: true, kind: true, model: true, parts: true, threadId: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.agentMessage.create({ data: { actorId: '', agentId: '', authorRole: '', databaseId: '', deliveredRunId: '', kind: '', model: '', parts: '', threadId: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentMessage.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentMessage.delete({ where: { id: '' } }).execute();
```
### `db.agentPersona`
CRUD operations for AgentPersona records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `config` | JSON | Yes |
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `databaseId` | UUID | Yes |
| `description` | String | Yes |
| `id` | UUID | No |
| `isActive` | Boolean | Yes |
| `name` | String | Yes |
| `resources` | String | Yes |
| `slug` | String | Yes |
| `systemPrompt` | String | Yes |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all agentPersona records
const items = await db.agentPersona.findMany({ select: { config: true, createdAt: true, createdBy: true, createdByPrincipal: true, databaseId: true, description: true, id: true, isActive: true, name: true, resources: true, slug: true, systemPrompt: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.agentPersona.findOne({ id: '', select: { config: true, createdAt: true, createdBy: true, createdByPrincipal: true, databaseId: true, description: true, id: true, isActive: true, name: true, resources: true, slug: true, systemPrompt: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.agentPersona.create({ data: { config: '', createdBy: '', createdByPrincipal: '', databaseId: '', description: '', isActive: '', name: '', resources: '', slug: '', systemPrompt: '', updatedBy: '', updatedByPrincipal: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentPersona.update({ where: { id: '' }, data: { config: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentPersona.delete({ where: { id: '' } }).execute();
```
### `db.agentPlan`
CRUD operations for AgentPlan records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `description` | String | Yes |
| `id` | UUID | No |
| `ownerId` | UUID | Yes |
| `status` | String | Yes |
| `threadId` | UUID | Yes |
| `title` | String | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all agentPlan records
const items = await db.agentPlan.findMany({ select: { createdAt: true, databaseId: true, description: true, id: true, ownerId: true, status: true, threadId: true, title: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.agentPlan.findOne({ id: '', select: { createdAt: true, databaseId: true, description: true, id: true, ownerId: true, status: true, threadId: true, title: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.agentPlan.create({ data: { databaseId: '', description: '', ownerId: '', status: '', threadId: '', title: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentPlan.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentPlan.delete({ where: { id: '' } }).execute();
```
### `db.agentPrompt`
CRUD operations for AgentPrompt records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `content` | String | Yes |
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `databaseId` | UUID | Yes |
| `description` | String | Yes |
| `id` | UUID | No |
| `isDefault` | Boolean | Yes |
| `metadata` | JSON | Yes |
| `name` | String | Yes |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all agentPrompt records
const items = await db.agentPrompt.findMany({ select: { content: true, createdAt: true, createdBy: true, createdByPrincipal: true, databaseId: true, description: true, id: true, isDefault: true, metadata: true, name: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.agentPrompt.findOne({ id: '', select: { content: true, createdAt: true, createdBy: true, createdByPrincipal: true, databaseId: true, description: true, id: true, isDefault: true, metadata: true, name: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.agentPrompt.create({ data: { content: '', createdBy: '', createdByPrincipal: '', databaseId: '', description: '', isDefault: '', metadata: '', name: '', updatedBy: '', updatedByPrincipal: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentPrompt.update({ where: { id: '' }, data: { content: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentPrompt.delete({ where: { id: '' } }).execute();
```
### `db.agentResourceChunk`
CRUD operations for AgentResourceChunk records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `agentResourceId` | UUID | Yes |
| `body` | String | Yes |
| `chunkIndex` | Int | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `embedding` | Vector | Yes |
| `embeddingVectorDistance` | Float | No |
| `id` | UUID | No |
| `metadata` | JSON | Yes |
| `searchScore` | Float | No |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all agentResourceChunk records
const items = await db.agentResourceChunk.findMany({ select: { agentResourceId: true, body: true, chunkIndex: true, createdAt: true, databaseId: true, embedding: true, embeddingVectorDistance: true, id: true, metadata: true, searchScore: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.agentResourceChunk.findOne({ id: '', select: { agentResourceId: true, body: true, chunkIndex: true, createdAt: true, databaseId: true, embedding: true, embeddingVectorDistance: true, id: true, metadata: true, searchScore: true, updatedAt: true } }).execute();
// Create
const created = await db.agentResourceChunk.create({ data: { agentResourceId: '', body: '', chunkIndex: '', databaseId: '', embedding: '', metadata: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentResourceChunk.update({ where: { id: '' }, data: { agentResourceId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentResourceChunk.delete({ where: { id: '' } }).execute();
```
> **pgvector embedding fields:** `embedding`
> High-dimensional vector columns for semantic similarity search. Query via the Unified Search API pgvector adapter using cosine, L2, or inner-product distance.
### `db.agentResource`
CRUD operations for AgentResource records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `archivedAt` | Datetime | Yes |
| `body` | String | Yes |
| `bodyTrgmSimilarity` | Float | No |
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `databaseId` | UUID | Yes |
| `description` | String | Yes |
| `descriptionTrgmSimilarity` | Float | No |
| `embedding` | Vector | Yes |
| `embeddingModel` | String | No |
| `embeddingModelTrgmSimilarity` | Float | No |
| `embeddingUpdatedAt` | Datetime | No |
| `embeddingVectorDistance` | Float | No |
| `id` | UUID | No |
| `isActive` | Boolean | Yes |
| `isArchived` | Boolean | Yes |
| `keywords` | String | Yes |
| `kind` | String | Yes |
| `kindTrgmSimilarity` | Float | No |
| `metadata` | JSON | Yes |
| `search` | FullText | No |
| `searchScore` | Float | No |
| `searchTsvRank` | Float | No |
| `slug` | String | Yes |
| `title` | String | Yes |
| `titleTrgmSimilarity` | Float | No |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all agentResource records
const items = await db.agentResource.findMany({ select: { archivedAt: true, body: true, bodyTrgmSimilarity: true, createdAt: true, createdBy: true, createdByPrincipal: true, databaseId: true, description: true, descriptionTrgmSimilarity: true, embedding: true, embeddingModel: true, embeddingModelTrgmSimilarity: true, embeddingUpdatedAt: true, embeddingVectorDistance: true, id: true, isActive: true, isArchived: true, keywords: true, kind: true, kindTrgmSimilarity: true, metadata: true, search: true, searchScore: true, searchTsvRank: true, slug: true, title: true, titleTrgmSimilarity: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.agentResource.findOne({ id: '', select: { archivedAt: true, body: true, bodyTrgmSimilarity: true, createdAt: true, createdBy: true, createdByPrincipal: true, databaseId: true, description: true, descriptionTrgmSimilarity: true, embedding: true, embeddingModel: true, embeddingModelTrgmSimilarity: true, embeddingUpdatedAt: true, embeddingVectorDistance: true, id: true, isActive: true, isArchived: true, keywords: true, kind: true, kindTrgmSimilarity: true, metadata: true, search: true, searchScore: true, searchTsvRank: true, slug: true, title: true, titleTrgmSimilarity: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.agentResource.create({ data: { archivedAt: '', body: '', createdBy: '', createdByPrincipal: '', databaseId: '', description: '', embedding: '', isActive: '', isArchived: '', keywords: '', kind: '', metadata: '', slug: '', title: '', updatedBy: '', updatedByPrincipal: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentResource.update({ where: { id: '' }, data: { archivedAt: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentResource.delete({ where: { id: '' } }).execute();
```
> **pgvector embedding fields:** `embedding`
> High-dimensional vector columns for semantic similarity search. Query via the Unified Search API pgvector adapter using cosine, L2, or inner-product distance.
> **Unified Search API fields:** `search`
> Fields provided by the Unified Search plugin. Includes full-text search (tsvector/BM25), trigram similarity scores, and the combined searchScore. Computed fields are read-only and cannot be set in create/update operations.
### `db.agentRun`
CRUD operations for AgentRun records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `artifacts` | JSON | Yes |
| `attempt` | Int | Yes |
| `baseCommit` | String | Yes |
| `branch` | String | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `deadlineAt` | Datetime | Yes |
| `entityId` | UUID | Yes |
| `error` | String | Yes |
| `executionId` | UUID | Yes |
| `finishedAt` | Datetime | Yes |
| `headCommit` | String | Yes |
| `id` | UUID | No |
| `lastEventSeq` | Int | Yes |
| `parentRunId` | UUID | Yes |
| `placement` | String | Yes |
| `principalId` | UUID | Yes |
| `repoUrl` | String | Yes |
| `startedAt` | Datetime | Yes |
| `status` | String | Yes |
| `threadId` | UUID | Yes |
| `tokenUsage` | JSON | Yes |
| `totalCost` | BigFloat | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all agentRun records
const items = await db.agentRun.findMany({ select: { actorId: true, artifacts: true, attempt: true, baseCommit: true, branch: true, createdAt: true, databaseId: true, deadlineAt: true, entityId: true, error: true, executionId: true, finishedAt: true, headCommit: true, id: true, lastEventSeq: true, parentRunId: true, placement: true, principalId: true, repoUrl: true, startedAt: true, status: true, threadId: true, tokenUsage: true, totalCost: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.agentRun.findOne({ id: '', select: { actorId: true, artifacts: true, attempt: true, baseCommit: true, branch: true, createdAt: true, databaseId: true, deadlineAt: true, entityId: true, error: true, executionId: true, finishedAt: true, headCommit: true, id: true, lastEventSeq: true, parentRunId: true, placement: true, principalId: true, repoUrl: true, startedAt: true, status: true, threadId: true, tokenUsage: true, totalCost: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.agentRun.create({ data: { actorId: '', artifacts: '', attempt: '', baseCommit: '', branch: '', databaseId: '', deadlineAt: '', entityId: '', error: '', executionId: '', finishedAt: '', headCommit: '', lastEventSeq: '', parentRunId: '', placement: '', principalId: '', repoUrl: '', startedAt: '', status: '', threadId: '', tokenUsage: '', totalCost: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentRun.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentRun.delete({ where: { id: '' } }).execute();
```
### `db.agentRunWorkspace`
CRUD operations for AgentRunWorkspace records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `artifacts` | JSON | Yes |
| `baseBranch` | String | Yes |
| `baseCommit` | String | Yes |
| `branch` | String | Yes |
| `clonedAt` | Datetime | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `headCommit` | String | Yes |
| `id` | UUID | No |
| `lastUsedAt` | Datetime | Yes |
| `ordinal` | Int | Yes |
| `provider` | String | Yes |
| `publication` | String | Yes |
| `repo` | String | Yes |
| `repositoryId` | UUID | Yes |
| `runId` | UUID | Yes |
| `state` | String | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all agentRunWorkspace records
const items = await db.agentRunWorkspace.findMany({ select: { actorId: true, artifacts: true, baseBranch: true, baseCommit: true, branch: true, clonedAt: true, createdAt: true, databaseId: true, headCommit: true, id: true, lastUsedAt: true, ordinal: true, provider: true, publication: true, repo: true, repositoryId: true, runId: true, state: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.agentRunWorkspace.findOne({ id: '', select: { actorId: true, artifacts: true, baseBranch: true, baseCommit: true, branch: true, clonedAt: true, createdAt: true, databaseId: true, headCommit: true, id: true, lastUsedAt: true, ordinal: true, provider: true, publication: true, repo: true, repositoryId: true, runId: true, state: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.agentRunWorkspace.create({ data: { actorId: '', artifacts: '', baseBranch: '', baseCommit: '', branch: '', clonedAt: '', databaseId: '', headCommit: '', lastUsedAt: '', ordinal: '', provider: '', publication: '', repo: '', repositoryId: '', runId: '', state: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentRunWorkspace.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentRunWorkspace.delete({ where: { id: '' } }).execute();
```
### `db.agentTask`
CRUD operations for AgentTask records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `approvalFeedback` | String | Yes |
| `approvalStatus` | String | Yes |
| `approvedAt` | Datetime | Yes |
| `approvedBy` | UUID | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `description` | String | Yes |
| `error` | String | Yes |
| `id` | UUID | No |
| `orderIndex` | Int | Yes |
| `planId` | UUID | Yes |
| `requiresApproval` | Boolean | Yes |
| `source` | String | Yes |
| `status` | String | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all agentTask records
const items = await db.agentTask.findMany({ select: { actorId: true, approvalFeedback: true, approvalStatus: true, approvedAt: true, approvedBy: true, createdAt: true, databaseId: true, description: true, error: true, id: true, orderIndex: true, planId: true, requiresApproval: true, source: true, status: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.agentTask.findOne({ id: '', select: { actorId: true, approvalFeedback: true, approvalStatus: true, approvedAt: true, approvedBy: true, createdAt: true, databaseId: true, description: true, error: true, id: true, orderIndex: true, planId: true, requiresApproval: true, source: true, status: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.agentTask.create({ data: { actorId: '', approvalFeedback: '', approvalStatus: '', approvedAt: '', approvedBy: '', databaseId: '', description: '', error: '', orderIndex: '', planId: '', requiresApproval: '', source: '', status: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentTask.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentTask.delete({ where: { id: '' } }).execute();
```
### `db.agentThread`
CRUD operations for AgentThread records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `agentId` | UUID | Yes |
| `archivedAt` | Datetime | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `id` | UUID | No |
| `isArchived` | Boolean | Yes |
| `mode` | String | Yes |
| `model` | String | Yes |
| `ownerId` | UUID | Yes |
| `parentThreadId` | UUID | Yes |
| `promptTemplateId` | UUID | Yes |
| `status` | String | Yes |
| `systemPrompt` | String | Yes |
| `tags` | String | Yes |
| `title` | String | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all agentThread records
const items = await db.agentThread.findMany({ select: { agentId: true, archivedAt: true, createdAt: true, databaseId: true, id: true, isArchived: true, mode: true, model: true, ownerId: true, parentThreadId: true, promptTemplateId: true, status: true, systemPrompt: true, tags: true, title: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.agentThread.findOne({ id: '', select: { agentId: true, archivedAt: true, createdAt: true, databaseId: true, id: true, isArchived: true, mode: true, model: true, ownerId: true, parentThreadId: true, promptTemplateId: true, status: true, systemPrompt: true, tags: true, title: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.agentThread.create({ data: { agentId: '', archivedAt: '', databaseId: '', isArchived: '', mode: '', model: '', ownerId: '', parentThreadId: '', promptTemplateId: '', status: '', systemPrompt: '', tags: '', title: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.agentThread.update({ where: { id: '' }, data: { agentId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.agentThread.delete({ where: { id: '' } }).execute();
```
### `db.platformAgent`
CRUD operations for PlatformAgent records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `config` | JSON | Yes |
| `createdAt` | Datetime | No |
| `id` | UUID | No |
| `isEphemeral` | Boolean | Yes |
| `name` | String | Yes |
| `ownerId` | UUID | Yes |
| `parentId` | UUID | Yes |
| `personaId` | UUID | Yes |
| `status` | String | Yes |
| `systemPrompt` | String | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all platformAgent records
const items = await db.platformAgent.findMany({ select: { config: true, createdAt: true, id: true, isEphemeral: true, name: true, ownerId: true, parentId: true, personaId: true, status: true, systemPrompt: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.platformAgent.findOne({ id: '', select: { config: true, createdAt: true, id: true, isEphemeral: true, name: true, ownerId: true, parentId: true, personaId: true, status: true, systemPrompt: true, updatedAt: true } }).execute();
// Create
const created = await db.platformAgent.create({ data: { config: '', isEphemeral: '', name: '', ownerId: '', parentId: '', personaId: '', status: '', systemPrompt: '' }, select: { id: true } }).execute();
// Update
const updated = await db.platformAgent.update({ where: { id: '' }, data: { config: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.platformAgent.delete({ where: { id: '' } }).execute();
```
### `db.platformAgentEvent`
CRUD operations for PlatformAgentEvent records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `entry` | JSON | Yes |
| `id` | UUID | No |
| `recordedAt` | Datetime | Yes |
| `runId` | UUID | Yes |
| `seq` | Int | Yes |
| `transcriptFormat` | String | Yes |
| `transcriptVersion` | Int | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all platformAgentEvent records
const items = await db.platformAgentEvent.findMany({ select: { actorId: true, createdAt: true, entry: true, id: true, recordedAt: true, runId: true, seq: true, transcriptFormat: true, transcriptVersion: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.platformAgentEvent.findOne({ id: '', select: { actorId: true, createdAt: true, entry: true, id: true, recordedAt: true, runId: true, seq: true, transcriptFormat: true, transcriptVersion: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.platformAgentEvent.create({ data: { actorId: '', entry: '', recordedAt: '', runId: '', seq: '', transcriptFormat: '', transcriptVersion: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.platformAgentEvent.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.platformAgentEvent.delete({ where: { id: '' } }).execute();
```
### `db.platformAgentMessage`
CRUD operations for PlatformAgentMessage records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `agentId` | UUID | Yes |
| `authorRole` | String | Yes |
| `createdAt` | Datetime | No |
| `deliveredRunId` | UUID | Yes |
| `id` | UUID | No |
| `kind` | String | Yes |
| `model` | String | Yes |
| `parts` | JSON | Yes |
| `threadId` | UUID | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all platformAgentMessage records
const items = await db.platformAgentMessage.findMany({ select: { actorId: true, agentId: true, authorRole: true, createdAt: true, deliveredRunId: true, id: true, kind: true, model: true, parts: true, threadId: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.platformAgentMessage.findOne({ id: '', select: { actorId: true, agentId: true, authorRole: true, createdAt: true, deliveredRunId: true, id: true, kind: true, model: true, parts: true, threadId: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.platformAgentMessage.create({ data: { actorId: '', agentId: '', authorRole: '', deliveredRunId: '', kind: '', model: '', parts: '', threadId: '', visibility: '' }, select: { id: true } }).execute();
// Update
const updated = await db.platformAgentMessage.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.platformAgentMessage.delete({ where: { id: '' } }).execute();
```
### `db.platformAgentPersona`
CRUD operations for PlatformAgentPersona records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `config` | JSON | Yes |
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `description` | String | Yes |
| `id` | UUID | No |
| `isActive` | Boolean | Yes |
| `name` | String | Yes |
| `resources` | String | Yes |
| `slug` | String | Yes |
| `systemPrompt` | String | Yes |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all platformAgentPersona records
const items = await db.platformAgentPersona.findMany({ select: { config: true, createdAt: true, createdBy: true, createdByPrincipal: true, description: true, id: true, isActive: true, name: true, resources: true, slug: true, systemPrompt: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.platformAgentPersona.findOne({ id: '', select: { config: true, createdAt: true, createdBy: true, createdByPrincipal: true, description: true, id: true, isActive: true, name: true, resources: true, slug: true, systemPrompt: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.platformAgentPersona.create({ data: { config: '', createdBy: '', createdByPrincipal: '', description: '', isActive: '', name: '', resources: '', slug: '', systemPrompt: '', updatedBy: '', updatedByPrincipal: '' }, select: { id: true } }).execute();
// Update
const updated = await db.platformAgentPersona.update({ where: { id: '' }, data: { config: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.platformAgentPersona.delete({ where: { id: '' } }).execute();
```
### `db.platformAgentPlan`
CRUD operations for PlatformAgentPlan records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `description` | String | Yes |
| `id` | UUID | No |
| `ownerId` | UUID | Yes |
| `status` | String | Yes |
| `threadId` | UUID | Yes |
| `title` | String | Yes |
| `updatedAt` | Datetime | No |
| `visibility` | String | Yes |
**Operations:**
```typescript
// List all platformAgentPlan records
const items = await db.platformAgentPlan.findMany({ select: { createdAt: true, description: true, id: true, ownerId: true, status: true, threadId: true, title: true, updatedAt: true, visibility: true } }).execute();
// Get one by id
const item = await db.platformAgentPlan.findOne({ id: '', select: { createdAt: true, description: true, id: true, ownerId: true, status: true, threadId: true, title: true, updatedAt: true, visibility: true } }).execute();
// Create
const created = await db.platformAgentPlan.create({ data: { description: '', ownerId: '', status: '', threadId: '', title: '', visibility: '