Top PostgreSQL Tools (31 Recommendations)

1

dbForge Studio for PostgreSQL

dbForge Studio for PostgreSQL is a GUI client and universal tool for PostgreSQL database development and management. This PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface. It also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables and master-detail relations.

Database Management Data Management Development & DevOps Proprietary Windows Commercial

👍 Most people think this is a good recommendation.

Metaphase

Login to Comment

1

PostGraphile

PostGraphile (previously known as PostGraphQL) is a free an open-source software project that lets you spin up GraphQL APIs on top of an existing PostgreSQL database, instantly. PostGraphile automatically detects tables, columns, indexes, relationships, views, types, functions and comments in your database. Based on that information it generates a GraphQL server and API which is automatically updated when changes are made to the database or its data.

Pro

PostGraphile automatically generates a GraphQL API from your PostgreSQL database schema

1

I love the fact that PostGraphile automatically detects tables, columns, indexes, relationships, views, types, functions and comments from my PostgreSQL database schema and instantly creates a GraphQL server and GraphiQL interface. With PostGraphile I can focus on what's important, making my idea come to reality, instead of fiddling with tooling.

Freddie

Pro

Database-Driven Development

1

Everything in PostGraphile revolves around your database schema. You write SQL, and PostGraphile automatically generates your GraphQL API. At first I was sceptical towards the model of database-driven development, but it has taught me how powerful our relational databases really are. As of late, the trend has been to move further and further away from database layer, with the introduction of ORMs, NoSQL, Serverless etc.. maybe these ideas are misguided?

Freddie

Pro

Makes use of PostgreSQL's row-level security

1

PostGraphile is built around features native to PostgreSQL. One such feature is PostgreSQL's row-level security, which can be utilized to build application authentication, authorization and role-based access systems right into your database.

Freddie

Development & DevOps Open Source Windows macOS Linux Web Self-Hosted Free

👍 Most people think this is a good recommendation.

Metaphase

Login to Comment

1

Postico

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.

Development & DevOps Proprietary macOS Free

👍 Most people think this is a good recommendation.

Metaphase

Login to Comment

1

dbForge Schema Compare for PostgreSQL

dbForge Schema Compare is a tool for easy and effective comparison and synchronization of Amazon Redshift and PostgreSQL database structure differences. It helps compare database schemas, gives comprehensive information on all differences, and generates clear and accurate SQL synchronization scripts to deploy database changes.

Database Management Development & DevOps IDE Proprietary Windows Free Commercial

👍 Most people think this is a good recommendation.

Metaphase

Login to Comment

1

pgAdmin

The software pgAdmin is the most popular free and open-source administration panel for PostgreSQL. With pgAdmin developers can manage their database and also use it as a tool that is part of the development process. The software is released under the PostgreSQL/Artistic licence and can be used on macOS, Linux, Unix and Windows to manage PostgreSQL 9.2 and above.

Development & DevOps Open Source Windows macOS Linux Free

👍 Most people think this is a good recommendation.

Metaphase

Login to Comment