I prefer the model of event triggers writing to a DDL audit table and calling NOTIFY. Then your script can just LISTEN for changes after you run your idempotent scripts. Then you're capturing all changes to the DB, not just the ones you're expecting.

Because it's always that guy making manual DDL updates that screws everything up, isn't it Mr. Hosick. ;)

Big fan of retool too. I also like to throw FastApi in front of Postgres on lambdas or cloud runs.

What are some other frontend tools you've found to be effective?

I've quickly looked at a few but for admin applications, retool seems to be a good choice. I don't have a lot of insight into other tools.