I use DBeaver to query my Postgres database across various environments. I find it solves the problem of having to save queries explicitly, and I'm impressed with the connection manager. I really like how I can define a database connection based on the environment and customize it with different configurations, such as enabling auto commit or selecting IDE colors. I also like that the query editor files auto-save. Another reason I switched to DBeaver from pgAdmin is the auto commit feature and the reliability and ease of maintaining different environment connections, which was a big reason for the switch.

An open-source DB management tool that works with different databases, including SQL and Postgres.

The ability to access different types of DB's in one unified view