postgres-domain-delivery

What problem does it solve?

It prevents fragile PostgreSQL schema and migration work by turning changes into production-safe database slices with explicit evidence, rollback discipline, and operational readiness.

Core Features & Use Cases

• Schema, index, and migration planning with verification evidence: defines data contracts, designs indexes from query shapes, and requires EXPLAIN (ANALYZE, BUFFERS)-style proof for hot-query changes.
• Online, mixed-version compatible deployment sequences: sequences deploy steps using lock-minimizing patterns like CONCURRENTLY indexes, NOT VALID constraints, batched backfills, and validation phases.
• Operational and rollback concrete requirements: budgets lock impact and WAL/replica-lag effects, names restore points/PITR feasibility, and specifies rollback triggers and observability for locks, deadlocks, and replication lag.

Quick Start

Use postgres-domain-delivery to implement or review the Postgres migration for your target change while capturing the smallest scoped evidence and a reversible rollback path.