We are heavy database users at Uniregisty, but I'm no professional Database Administrator.
pgcli is a major improvement over the stock
pshell. Queries are auto-completed as you type and it's especially useful to complete complex joins.
If you're writing complex stored procedures - maybe involving the JSON(B) field types with a lot of new operators - it can be helpful to debug your stored procedures.
pgclishell than from your client code, but I have written
Pythontests just to test a specific SQL query and hooked up a "test watcher" to also watch the SQL files, replace the functions/procedures and run the corresponding tests.