Greenplum database development and administration tools

posted Apr 28, 2017, 4:20 PM by Sachchida Ojha

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. The application may be used on Linux, FreeBSD, Solaris, Mac OSX and Windows platforms to manage PostgreSQL 7.3 and above running on any platform, as well as commercial and derived versions of PostgreSQL such as Postgres Plus Advanced Server and Greenplum database.

pgAdmin is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more. Server connection may be made using TCP/IP or Unix Domain Sockets (on *nix platforms), and may be SSL encrypted for security. No additional drivers are required to communicate with the database server.

pgAdmin is developed by a community of PostgreSQL experts around the world and is available in more than a dozen languages. It is Free Software released under the PostgreSQL License.

The current version of pgAdmin is 1.16.1.
Aginity Workbench

Aginity Workbench 4.0 for EMC Greenplum 

“Aginity’s Workbench for Greenplum offers a simple and efficient method of managing a Greenplum database. This tool will give you a single point of access to manage, monitor and develop along with a range of functions that look deep into the Greenplum architecture.”
– “EMC Greenplum Management Enabled by Aginity Workbench” 

Created by – and for – Aginity’s own developers, the Workbench is built on a deep understanding of all that the Greenplum appliance can do. 

Now it’s easy to download and install as a Greenplum development tool, providing an intuitive interface for creating, managing and tracking both individual SQL queries and entire databases.

AQT is a fast and powerful multi-database query tool. 
AQT provides a simple and easy-to-use interface to your many different databases.
With a feature-rich query environment and a wide range of DBA and developer tools, it is the ideal database product irrespective of whether you are a data analyst, DBA or developer.
AQT is FAST. It uses a low-level ODBC interface which runs reliably against the smallest database to the largest enterprise system. 
No other product has AQT's degree of multi-database support. Configured individually for over 20 different database types, AQT is a specialized product for every database. One tool, one price, for all your databases. In addition, AQT has excellent cross-database features. Load data from Oracle into DB2 z/OS! Compare tables between Sybase and MySQL! 

Aqua Data Studio 
Just Released: 13.0

is a complete Integrated Development Environment (IDE) for database query, administration and development. It supports all major database vendors, works on all major operating systems and is localized for 21 languages. Aqua Data Studio scales with your ever growing datasets and can query and manipulate Big Data effortlessly.
Now, natively supports GreenplumVertica and SQLite and includes Chart Enhancements.