Top PostgreSQL Tools

Software
Database
Database Management
Recommendations: 31 | Last Updated: May 27, 2022 (8 months)
1

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

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
Freddie
Pro

Makes use of PostgreSQL's row-level security

2
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
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
Freddie

👍 Most people think this is a good recommendation.

Metaphase
Metaphase
1

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.

Metaphase
Metaphase
1

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.

Metaphase
Metaphase
1

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.

Metaphase
Metaphase
1

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.

Metaphase
Metaphase
1

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

Metaphase
Metaphase
0

PostgREST PostgREST

PostgREST

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

Metaphase
Metaphase
0

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

Metaphase
Metaphase
0

Open PostgreSQL Monitoring Open PostgreSQL Monitoring

Open PostgreSQL Monitoring
Oversee and Manage Your PostgreSQL Servers
Metaphase
Metaphase
0

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.
Metaphase
Metaphase
Top PostgreSQL Tools Best Content Management System Best Web Browsers Best Dating Applications Best GUI Tools for MySQL on macOS
Login to Recommend