@agentplat/workflows-postgres

PostgreSQL durability for Governed Durable Workflows V1. The package persists immutable task/process definitions, revisioned process and task runs, idempotent operations, signals, transition events and delayed outcomes.

Installation (developer preview)

Install the coordinated preview explicitly:

npm install @agentplat/workflows-postgres@next

Keep all @agentplat/* packages on the same release version. npm's default latest tag can point to an older preview. See the release channels for distribution status and version selection.

PostgresWorkflowStoreV1 implements the same WorkflowStoreV1 contract as the in-memory reference. PostgresTaskOutcomeStoreV1 implements the browser-safe outcome port from @agentplat/workflows/outcomes.

import {
  PostgresTaskOutcomeStoreV1,
  PostgresWorkflowStoreV1,
  runMigrations,
} from "@agentplat/workflows-postgres";

await runMigrations(pool);
const workflows = new PostgresWorkflowStoreV1(pool);
const outcomes = new PostgresTaskOutcomeStoreV1(pool);

Repository construction performs no I/O. The host owns the pool, schema, authentication, backups and migration execution. Rollback is destructive and requires the package confirmation plus an explicitly verified external backup.

PostgreSQL provides durable CAS and identity constraints, not an exactly-once external-effect guarantee. Effect sinks must atomically enforce the supplied task idempotency identity or fence.