Metagration (https://github.com/michelp/metagration) is a full featured PostgreSQL migration tool written entirely in PostgreSQL's native PL/pgSQL scripting language. No external tools or languages are required to migrate your database and all these features are available using any PostgreSQL client:
- Up/Down scripts are stored procedures in any pl language. - No external tools, any PostgreSQL client can manage migration. - Cloud-friendly single ~400 line SQL file for any PostgreSQL >= 11. - One simple function for new SQL scripts. - Procedures can be transactional, and transaction aware. - Generates Point In Time Recovery restore points before migration. - Metagration can export/import to/from SQL files. - Metagrations are just rows so `pg_dump/pg_restore` them. - Can use pgTAP for powerful migration verification. - Postgres docker container entrypoint friendly. Check it out! https://github.com/michelp/metagration
