Postgres safety review

Purpose

Recommend best practices for a PlanetScale Postgres database. Focus on availability protection, application isolation, recovery, safe automation, and observability. Do not apply changes.

Branch and schema workflow

PlanetScale Postgres branches do not use Vitess-style deploy requests. Schema changes are made directly to each branch, and production schema changes should be managed through the application’s normal migration workflow with a branch validation step.

Check:

• Whether a development or test branch exists.
• Whether branches are empty or restored from backup.
• Whether migrations are tested against a branch before production.
• Whether application migrations are reversible or have a documented rollback strategy.
• Whether production DDL is manually reviewed.

Recommend: