Top PostgreSQL Tools

Recommendations: 31 | Last Updated: May 27, 2022 (4ย months, 1ย week)

PostGraphile 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.

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.
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.
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?

๐Ÿ‘ Most people think this is a good recommendation.

dbForge Schema Compare for PostgreSQL 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.

๐Ÿ‘ Most people think this is a good recommendation.

pgAdmin 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.

๐Ÿ‘ Most people think this is a good recommendation.

pgweb pgweb

Web-based PostgreSQL database browser written in Go. Pgweb is a web-based database browser for PostgreSQL, written in Go and works on OSX, Linux and Windows machines.

๐Ÿ‘ Most people think this is a good recommendation.

dbForge Studio for PostgreSQL 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.

๐Ÿ‘ Most people think this is a good recommendation.

Postico 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.

๐Ÿ‘ Most people think this is a good recommendation.

PostgREST PostgREST

PostgREST is a standalone web server and development tool that automatically turns your PostgreSQL database into a RESTful API.

Datazenit Datazenit

Datazenit is a web-based database administration tool for MySQL and PostgreSQ. With Datazenit you can manage databases locally and in the cloud with an intuetive GUI that provides data grids, a schema build and interactive data charts.

Open PostgreSQL Monitoring Open PostgreSQL Monitoring

Oversee and Manage Your PostgreSQL Servers

dbForge Data Compare for PostgreSQL dbForge Data Compare for PostgreSQL

dbForge Data Compare for PostgreSQL is a visual data diffs comparison and deployment tool for PostgreSQL.