Authoring Database Changes with PGPM

Create safe, reversible database changes using pgpm's three-file pattern. Every change has deploy, revert, and verify scripts.

When to Apply

Use this skill when:

• Adding tables, functions, triggers, or indexes
• Creating database migrations
• Modifying existing schema
• Organizing database changes in a pgpm module

The Three-File Pattern

Every database change consists of three files: