Top PostgreSQL Tools

Recommendations: 31 | Last Updated: Feb. 15, 2024 (2 weeks)

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.

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

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

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.

Postgres.app Postgres.app

The easiest way to run PostgreSQL on the Mac.

PostgREST PostgREST

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

Database Designer for PostgreSQL Database Designer for PostgreSQL

The MicroOLAP Database Designer for PostgreSQL is an comprehensive CASE tool with intuitive...

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.