pgmt Documentation

Edit SQL files. Let pgmt figure out the dependencies, generate the migrations, and keep your environments in sync.

Most people start with the Quick Start — you’ll have automatic dependency tracking working in under 10 minutes. Already have a database? See Adopt Existing Database to import your schema.

What’s in these docs

Using pgmt: Organize schema files like code, iterate instantly with pgmt apply, and manage roles and permissions.

Going to Production: Handle the hard stuff. Concurrent indexes, data backfills, per-section timeouts, CI/CD integration, and baseline management.

How It Works: Why pgmt can handle complex dependency chains that break other tools, and why explicit migrations matter.

Reference: CLI commands, configuration options, and the full list of supported PostgreSQL features.

Get help

• Troubleshooting — Common issues and solutions
• GitHub Discussions — Ask questions
• GitHub Issues — Report bugs

Note

Status: Alpha — Core features are functional, but the API may evolve.