Over the years, the PostgreSQL community has come up with many high-quality open-source GUI tools for manipulating, visualizing and sharing the data living in Postgres servers. Here is a round up of various types of useful GUI tools that can help you and your team manage and share your data.

pgAdmin

• Home Page: https://www.pgadmin.org
• Type: Browser-based desktop GUI

pgAdmin is the venerable quasi-official feature-rich GUI for PostgreSQL. It lets you run queries as well as explore and examine every bit of your server and databases.

OmniDB

• Home Page: https://omnidb.org/index.php/en/
• Type: Browser-based desktop GUI

OmniDB also lets you run queries and explore and edit database objects. It also supports servers other than Postgres, including MySQL and Oracle. Supports debugging of user-defined functions (stored functions) written in PL/pgSQL.

DBeaver

• Home Page: https://dbeaver.io/
• Type: Java/Eclipse-based Desktop GUI

DBeaver is similar to pgAdmin and OmniDB, with support for more RDBMS servers. Can generate ER diagrams from the schema automatically.

pgweb

• Home Page: http://sosedoff.github.io/pgweb/
• Type: Single-binary Go-based web server

pgweb is a simple, easy-to-deploy tool that runs as a web server. You can view data, run queries and examine tables and indexes.

Metabase

• Home Page: https://www.metabase.com/
• Type: BI tool, server install

Metabase is a business intelligence tool, that can help your team setup, run and visualize queries. Knowledge of SQL is optional. Supports RDBMS (and data sources) other than PostgreSQL also.

Redash

• Home Page: https://redash.io/
• Type: BI tool, server install

Redash is also a business intelligence tool for teams, with a more hands-on approach. It lets you write SQL queries directly and setup visualizations and dashboard with more options and customizations.

Blazer

• Home Page: https://github.com/ankane/blazer
• Type: Basic BI queries, dashboards; server install

Blazer is a Ruby-on-Rails gem that let’s users define queries, visualizations and dashboards, and share them with their team. You’ll need to know your way around RoR to make use of this.

Apache Superset

• Home Page: https://superset.incubator.apache.org/
• Type: BI tool, server install, Python-based

Apache Superset is an incubating (pre-release) BI tool of the Apache Software Foundation. It has a rich set of visualizations and support for many data sources.

Apache Zeppelin

• Home Page: https://zeppelin.apache.org/
• Type: Notebook, server install, Java-based

Zeppelin is a web-based notebook (like Jupyter for Python) from the Apache Software Foundation. It lets you interactive explore the data from many sources (including PostgreSQL of course) with visualizations.

franchise

• Home Page: https://franchise.cloud/
• Type: Notebook, Online

Franchise is a web-based notebook that can connect to your local database using a bridge tool, thus requiring no server installation. Supports data sources like MySQL and BigQuery also.

More..

You can find even more links on the PostgreSQL Wiki, including commercial software, tools for ER diagrams, IDEs and more.

About pgDash

pgDash is a modern, in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics. pgDash provides core reporting and visualization functionality, including collecting and displaying PostgreSQL information and providing time-series graphs, detailed reports, alerting, teams and more.

The Diagnostics feature in pgDash examines your PostgreSQL server and databases scanning for potential issues that can impact the health and performance of the deployment. No additional setup is required for Diagnostics - you just need to be actively sending in data to pgDash. Learn more here or signup today for a free trial.