@eidentic/postgres

PostgreSQL store adapter for Eidentic — durable agent memory, session records, temporal knowledge graph facts, and durable-execution checkpoints over a pg.Pool or PGlite. Implements StorePort, GraphPort, and DurablePort from @eidentic/types. Runs migrations automatically on first use.

Install

pnpm add @eidentic/postgres pg

Usage

import { PostgresStore } from "@eidentic/postgres";
import pg from "pg";
import { Agent, AIModel } from "eidentic";
import { anthropic } from "@ai-sdk/anthropic";

const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL });
const store = await PostgresStore.create({ client: pool });

const agent = new Agent({
  id: "support",
  instructions: "You are a helpful support assistant.",
  model: new AIModel(anthropic("claude-sonnet-4-5")),
  store,
});

for await (const ev of agent.query("Hello", { sessionId: "s-1" })) {
  if (ev.type === "stream.delta") process.stdout.write(ev.delta.text);
}

When given a pg.Pool, migrations check out one dedicated connection for the complete transaction and take a transaction-scoped advisory lock. This prevents concurrent application instances from interleaving schema-version checks and DDL on different pool sockets. PGlite uses its single connection transaction path.

Links

• GitHub
• Issue tracker
• Root README

Apache-2.0