{"library":"pg-schemata","type":"library","category":null,"description":"A lightweight Postgres-first ORM layer built on pg-promise (v1.3.3) for Node.js 18+. Defines table schemas in code, auto-generates ColumnSets for efficient CRUD, rich WHERE modifiers (like $like, $ilike, $from, $to, $in), cursor-based pagination, multi-schema support, DTO validation via Zod, extensible class inheritance, and migration management. Alternatives like Sequelize or TypeORM offer heavier abstractions; pg-schemata stays close to SQL while reducing boilerplate.","language":"javascript","status":"active","version":"1.3.3","tags":["javascript","postgres","pg-promise","orm","schema","nodejs","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install pg-schemata","imports":["import { TableModel } from 'pg-schemata'","import { SchemaDefinition } from 'pg-schemata'","import { MigrationManager } from 'pg-schemata'","import { DatabaseError } from 'pg-schemata'","import * as pgSchemata from 'pg-schemata'"]},{"cmd":"yarn add pg-schemata","imports":[]},{"cmd":"pnpm add pg-schemata","imports":[]}],"homepage":"https://silverstone-i.github.io/pg-schemata/","github":"https://github.com/silverstone-i/pg-schemata","docs":null,"changelog":null,"pypi":null,"npm":"pg-schemata","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}