to keep the database up to date as a developer I want automated schema migrations

[bionicles]

this isn't easy if the database is in a private subnet. we'd need the ci/cd pipeline to ssh into a bastion host, copy the migrations, install a migration tool, and migrate the database

https://github.com/thomwright/postgres-migrations#readme

https://github.com/appleboy/ssh-action
scp -pr ~/migrations/. $USER@$HOST:/migrations