pgAdmin

vs

DbVisualizer

DataGrip is a commercial IDE for databases and SQL developed by JetBrains. With DataGrip users can write SQL code faster and safer due to context-sensitive code completion that is aware of tables structure, foreign keys and pivot tables. DataGrip PostgreSQL, MySQL, Oracle Database, SQL Server, Azure, Amazon Redshift, SQLite, MariaDB, MongoDB, Cassandra, Apache Hive and many more databases.

Postico is a free, modern PostgreSQL client for macOS. The client makes PostgreSQL more approachable by providing an easy to use interface that is liked by beginners and specialists alike. With Postico you can leverage the power of Postgres databases without using the CLI.

With pgRITA you can analyzes your database schema against common rules to easily adhere to best practises. pgRITA provides a interactive report that can be used to improve your PostgreSQL schema and minimize errors.

PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly. PSequel PostgreSQL GUI tool specifically developed for macOS. While offical tools like pgAdmin are great and provide a wide range of features, they lack the simplicity of PSequel.

pgModeler is an open source software for modeling PostgreSQL databases. It merges the classical concepts of modeling using entity-relationship diagrams with specific features that only PostgreSQL implements. With pgModeler you can create and edit database models easily with a simple and intuitive interface. pgModeler allows you to design your database once with dynamic code generation, and export to multiple versions of PostgreSQL ranging from 9.x to 13.x.