{"library":"pg-differ","type":"library","category":null,"description":"pg-differ is a Node.js migration tool for PostgreSQL that compares database schemas (tables and sequences) against a metadata definition and generates SQL migration scripts. It supports updating columns without data loss, synchronizing indexes/constraints, and auto-generating schemas from existing database objects. The current stable version is 3.5.1, with releases following semantic versioning. Ships TypeScript types. Requires Node >=10.4.0. Key differentiator: declarative schema definition rather than imperative migration steps, offering both a CLI and programmatic API for safe, reversible database migrations.","language":"javascript","status":"active","version":"3.5.1","tags":["javascript","node","pg","database","postgres","postgresql","migration","typescript"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install pg-differ","imports":["import { differ } from 'pg-differ'","import { Schema } from 'pg-differ'","import type { SyncOptions } from 'pg-differ'"]},{"cmd":"yarn add pg-differ","imports":[]},{"cmd":"pnpm add pg-differ","imports":[]}],"homepage":"https://multum.github.io/pg-differ","github":"https://github.com/multum/pg-differ","docs":null,"changelog":null,"pypi":null,"npm":"pg-differ","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}