Postgres UI tools 2021
In the spirit of the freely available enterprise database, this article examines tools offering a blend of features at no cost. We cover software for beginners, administrators, developers, analysts, and everyone between.
Released by EnterpriseDB alongside Postgres, PGAdmin is a widely known tool. This UI tool is perfect when first dipping your toes into PostgreSQL.
PGAdmin includes straightforward query tools and a database explorer. Setup is simple with options to run natively or within a Docker container.
SSH tunneling allows you to securely connect to remote databases. This feature is necessary for organizations adhering to strict security guidelines and privacy laws.
The included monitoring tools are useful for system administrators as well. PGAdmin4 displays statistics related to I/O, sessions, and usage while allowing you to browse through recent transactions.
It is possible to backup and restore data, set permissions, and create properties without SQL, however, more advanced procedures such as killing stale connections still require running queries.
