Have you ever heard about pgmodeler? https://pgmodeler.io/

I have not!

I don't use pgmodeler but I use pgadmin instead :)) But diagrams may also be useful. https://www.pgadmin.org/

The pgmodeler diagrams look fancy

A little too fancy. I don't like it 🤷

PlantUML seems to convince management that Serious Work is getting done, so I'm cool with it