Database

Most of our SaaS environments have a database. It’s useful to have a graphical view on them to investigate issues.

Connecting

If you’re connecting to a SQL database hosted in a cloud, you most probably need to whitelist your IP, or (in case of Google), install and use a proxy to connect through a Unix socket as documented at gcloud.

PGAdmin4

PGAdmin4 can be used to connect to PostgresSQL databases.

pgadmin can be installed as:

sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add
sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
sudo apt install pgadmin4-desktop