pg-migrations

What problem does it solve?

Efficiently orchestrate and apply schema-per-tenant PostgreSQL migrations across all active tenants with zero downtime, robust rollback, and auditing.

Core Features & Use Cases

• Migration conventions: standardized 6-digit numbering, up/down pairing, and :schema placeholder usage to target each tenant schema.
• Zero-downtime strategies: phases for adding columns, safe renames, and non-blocking index creation outside transactions.
• Bounded worker migrations: parallel application of migrations across tenant schemas with a configurable concurrency cap.
• Audit and observability: audit trigger setup and partitioned logs for change tracking across all tables.
• Deployment readiness: supports rolling back migrations and ensuring all tenants are kept in sync during deploys.

Quick Start

Use the pg-migrations skill to scaffold and apply a new migration across all active tenant schemas.