Azure PostgreSQL GUI

Microsoft Azure has introduced a PostreSQL GUI extension. This is part of the Azure Data Studio. They have created a really nice graphical user interface to manage not just one postgres database, but multiple ones. There is nothing wrong with command line but for getting certain types of tasks or work done, this is a huge improvement.

The GUI provides for a thorough overview and yes, visualization of databases, servers, tables, indexes and more. In addition, the new tool allows for connecting to the database directly or to a local or cloud-based server. The PostgreSQL extension allows for color coding of different servers within the GUI for ease of use, if there is more than one server.

The new tool allows for locating database objects, queries by way of IntelliSense, creating query templates, customizing the editor and Git source control integration.