pg-schemataPostgreSQL-first ORM for Node.js

Define your schema once. Get CRUD, migrations, validation, and multi-tenancy — all built on pg-promise.

Schema-driven

Define tables, columns, constraints, and behavior in a single JavaScript object. pg-schemata generates DDL, ColumnSets, and Zod validators from it.

Full CRUD + bulk ops

insert, update, delete, upsert, bulkInsert, bulkUpdate, bulkUpsert — all with automatic validation, audit fields, and soft delete awareness.

Flexible WHERE builder

Query with $like, $in, $from/$to, $and/$or, and more. Compose conditions as plain objects — no query DSL to learn.

Cursor pagination

Keyset-based pagination via findAfterCursor with multi-column cursor support, ascending and descending order.

Soft delete

Enable per-table soft delete with a single flag. All queries automatically exclude deactivated rows unless you opt in.

Migrations

MigrationManager discovers, applies, and tracks versioned migration scripts with SHA-256 integrity verification and advisory locking.

Multi-schema tenancy

Switch PostgreSQL schemas at runtime with callDb or setSchemaName for per-tenant data isolation.

Audit fields

Automatic created_at, updated_at, created_by, updated_by tracking with a pluggable actor resolver for dynamic user injection.

Why pg-schemata

pg-schemata is designed for Node.js applications that use PostgreSQL directly and want structured table access without a heavy ORM. You define your schema as a JavaScript object, extend TableModel, and get a fully featured repository with validation, audit trails, and safe query building — all backed by pg-promise.

Documentation map

Start with Getting Started for installation and your first model.
Read Schema Definition to understand the schema object.
See Models for QueryModel vs TableModel and extending them.
Use CRUD Operations for day-to-day insert, update, delete, and bulk ops.
See WHERE Modifiers for the full query operator reference.
Browse the API Reference for method signatures and parameters.