Database

PGlite database API for workflow persistence

Database API

The Smithers database provides persistent storage using PGlite (embedded PostgreSQL).

Creating a Database

import { createSmithersDB } from "smithers/smithers-orchestrator/src/db";

const db = await createSmithersDB({
  path: ".smithers/my-workflow"
});

// Always close when done
await db.close();

Database Structure

Namespace	Purpose
db.state	Key-value state storage
db.memories	Long-term knowledge storage
db.execution	Execution tracking
db.phases	Phase tracking
db.steps	Step tracking
db.agents	Agent invocation tracking
db.tools	Tool call tracking
db.artifacts	Artifact tracking
db.vcs	VCS operations (commits, reviews)

Raw Queries

For advanced use cases:

const results = await db.query<{ count: number }>(
  "SELECT COUNT(*) as count FROM agents WHERE model = $1",
  ["sonnet"]
);

Closing

Always close the database to ensure writes are flushed:

await db.close();

Related

State API

Key-value storage

Memories API

Long-term knowledge

Execution API

Execution tracking

VCS API

Version control