export

@agentic-db/export

pgpm export wrapper for agentic-db schema. Exports the provisioned agentic-db database as a pgpm-installable SQL module.

Prerequisites

• pgpm installed globally (npm install -g pgpm)
• A provisioned agentic-db database running locally (via pnpm run provision in packages/provision)
• PostgreSQL connection available (pgpm reads from PGHOST, PGPORT, PGUSER, PGPASSWORD env vars, or uses pgpm env)

Usage

Interactive export (prompts for database selection)

pnpm run export:interactive

Non-interactive export

pnpm run export

This runs pgpm export with:

• --extensionName agentic-db — names the output module agentic-db
• --metaExtensionName agentic-db-services — names the services module agentic-db-services

How it works

1. pgpm export connects directly to the PostgreSQL database
2. Reads metadata from collections_public.database, collections_public.schema
3. Reads migration history from db_migrate.sql_actions
4. Uses makeReplacer() to auto-rename schemas (e.g. agentic-db-<timestamp>-public -> agentic_db_public)
5. Outputs a pgpm module with deploy/, revert/, verify/, .control, pgpm.plan

Output

The exported module lands in the pgpm workspace packages/ directory (configured by pgpm.json at repo root). You can then:

# Install the module into another database
pgpm install agentic-db

# Or publish it
pgpm package

Environment

Make sure pgpm env vars are set:

eval "$(pgpm env)"

Or set them manually:

export PGHOST=localhost
export PGPORT=5432
export PGUSER=postgres
export PGPASSWORD=postgres