I’ve recently discovered DBeaver. It automatically detects relations between tables in a visual manner. You can move tables around, change colors, see foreign keys, etc. It’s extremely good. Fully compatible with PostgreSQL
Querying and manipulating data using the GUI is extremely easy.
Not only that you can use it with all major SQL and noSQL databases, so all your data can be managed in just one place.