@girish I use DBeaver with an SSH tunnel. I just found an option that I forgot to toggle on -- "Show all databases".
Now it shows all the databases!
On a side note, I did first try to configure an SSH tunnel and a post-command to execute "/usr/local/bin/docker exec -ti postgresql bash" and that worked as well.
But, only one tunnel is needed to the cloudron server to login as root that allows access to all databases.
I'm good to go. Thanks for the help!