PostgreSQL Maestro

With a name that clearly states its true purpose, PostgreSQL Maestro is a full-featured and advanced piece of software designed to make the lives of PostgreSQL database administrators easier by offering them powerful management tools within a well-organized environment.

Regarding the app's typical installation there's not much to be said, except the fact that it should not pose any kind of difficulties for you, regardless of your computer skills.

When you fire up the application for the first time, you are welcome by a useful Home screen that provides you with a set of useful information such as the app's version and some other license-related facts and, more importantly, direct access to some of the app's main tools.

It is worth mentioning that this Home screen also allows you to quickly create a new database or connect to an already existing one. This is the best time to point out that the app supports all version of PostgreSQL server up to version 7.3, at the time at which this review was written.

Also noteworthy is the fact that this utility is perfectly capable of working with PostgreSQL servers via SSH and HTTP tunnel.

The app's interface is quite similar with those of other tools of this kind. As expected, all of the app's features are neatly organized in convenient, drop-down menus located in the upper part of the main window, with an emphasis on the Tools menu that bundles most of them.

There's also a customizable top toolbar that allows you to add or remove buttons and a useful Database Explorer on the left side.

Going a bit more into depth about what makes this app useful, we should point out that it allows you to build and execute queries and SQL scripts, build visual diagrams for numeric data,  as well as create, edit and manage database objects such as schemas, tables, views, functions, rules and operators.

The powerful SQL Editor with code folding and multi-threading support, the PL/pgSQL debugger, the advanced BLOB viewer/editor and the comprehensive database designer are also part of PostgreSQL Maestro's repertoire.

To conclude, if you are looking for a comprehensive PostgreSQL database administration tool that offers tons of features without hogging your computer's resources, then PostgreSQL Maestro definitely deserves your attention.