I totally agree with schema migrations being painful, have you seen the open-source tool we developed to tackle this problem? It is called pgroll: https://github.com/xataio/pgroll
There is something we built for the schema management aspect of Vitess for PostgreSQL.
It is called pgroll, open-source, aiming to minimize potential downtime risks associated with DDL changes, offering multi-schema view, instant rollbacks, and more high-level options like backfilling in batches.
We've just enabled Github Discussions for the pgroll project. Pgroll is an open-source schema migration tool, designed exclusively for Postgres, aiming to minimize downtime that is associated with DDL changes.
We’re building fast, and your feedback is super important to us. Share your suggestions, we’re listening!