pgmt Documentation
pgmt lets you manage your PostgreSQL schema like code — edit database objects directly, see changes instantly, and generate explicit migrations when you’re ready to deploy.
Status: Alpha — Core features are functional, but the API may evolve.
Start here
Section titled “Start here”Quick Start Guide — Install pgmt, set up a project, and apply your first schema change in under 10 minutes.
Already have a database? See Adopt Existing Database to import your schema.
What’s in these docs
Section titled “What’s in these docs”Using pgmt — How to organize schema files, the day-to-day migration workflow, and managing roles and permissions.
Going to Production — Multi-section migrations with per-section timeouts and retries, CI/CD integration, and baseline management.
Under the Hood — How the schema diffing engine works, shadow database validation, and automatic dependency tracking.
Reference — CLI commands, configuration options, and the full list of supported PostgreSQL features.
Get help
Section titled “Get help”- Troubleshooting — Common issues and solutions
- GitHub Discussions — Ask questions
- GitHub Issues — Report bugs