pg-tenant-provisioning

What problem does it solve?

Provisioning a new tenant in a multi-tenant PostgreSQL 18 environment by creating a dedicated per-tenant schema, applying migrations, and registering the tenant in the management registry to ensure isolation and lifecycle control.

Core Features & Use Cases

• Create tenant schemas deterministically with the t_{8hex} pattern and a dedicated _mgmt schema to store the registry and migrations.
• Apply migrations to a specific tenant schema using a :schema placeholder and a shared pool, then register the tenant as active in _mgmt.tenant_registry.
• Manage tenant lifecycle: onboarding (provision), deprovisioning, and archival of registry records with status transitions.

Quick Start

Provision a new tenant by supplying the tenant UUID and app DB name to create the schema, run migrations, and register the tenant in the registry.