What are the best PostgreSQL management tools?

Question

17

Options
Considered

100

User
Recs.

Oct 12, 2022

Last
Updated

Here’s the Deal

13 Options Considered

Best PostgreSQL management tools	Price	Platforms	Technology
-- DbVisualizer	-	Windows, Linux, Mac	Java
-- DBeaver	Free / paid	Windows, Linux, MacOS	Java
-- Postico	-	Mac	-
-- pgModeler	Free / paid	Windows, Linux, Mac	C++, Qt
-- DataDog	Free / paid	Windows, Linux, Mac	-

See Full List

I Recommend...

Built By the Slant team

Find the best product instantly.

4.7 star rating

Try it now - it's free

score 1 · Answer 1

DbVisualizer

Top Pro

In-line editing

Allows you to edit and save db rows through a spread-sheet like editor. See More

Specs

Platforms:Windows, Linux, Mac

Technology:Java

Top Pro

Wildcard finder

Has a search box that will highlight any matching row, regardless of what field is matched (spans multiple columns). See More

Top Pro

Professional tool

This is a good and stable tool with really good and useful functionality: import/export, SSH tunnelling, fast searching, duplication, DDL visualization etc. If you are a professional, don't complain about the pricing. If you're an amateur, maybe this isn't for you. See More

Top Pro

Duplicate row button

Makes it really easy to stub out example data while developing, just change the values with unique constraints and you have extra data ready to go. See More

See All

score 2 · Answer 2

DBeaver

Top Pro

Free

It is licensed under GPL v2. See More

Specs

Platforms:Windows, Linux, MacOS

Technology:Java

Database management:PostgreSQL, MySQL, Oracle, IBM DB2, SQL Server, Access, Sybase, Firebird, Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source

Top Pro

Works for many types of databases

MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source. See More

Top Pro

Cross-platform

Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86). See More

See All

score 2 · Answer 3

Postico

score 1 · Answer 4

pgModeler

Top Pro

Diff scripts

Can generate scripts to synchronize a database. See More

Top Con

Compiling

Can't be compiled in Microsoft Visual Studio because of gcc/clang extensions. Instructions on how to compile for Windows. See More

RickZeeland's Experience

Open source PostgreSQL database modeler, the binaries can be purchased for a small price. See More

Specs

Platforms:Windows, Linux, Mac

Technology:C++, Qt

Database management:PostgreSQL

Top Pro

Reverse engineering

Can generate diagrams from an existing database. See More

Top Pro

Export formats

Can export to SQL script file, PNG, SVG or directly to PostgreSQL. See More

See All

score 1 · Answer 5

DataDog

Platforms:Windows, Linux, Mac

score 1 · Answer 6

DB Lens

Top Con

Still in Beta

Top Pro

Free

RickZeeland's Experience

DB Lens is an open-source database client written in TypeScript (still in Beta) that allows to explore the database and relations with automatic ER diagrams and visualise DB metrics. See More

Specs

Platforms:Windows, Linux, Mac

See All

Answer 7

DbSchema

Platforms:Windows, Linux, Mac

Technology:Java

score 1 · Answer 8

pg_catcheck

Add Video or Image

score 1 · Answer 9

pg_activity

score 1 · Answer 10

PostgreSQL Dashboard

Top Pro

No need to go through logs

RickZeeland's Experience

Simple monitoring tool based on Dashing and Sinatra that provides a live activity report of a PostgreSQL instance. See More

Specs

Technology:Ruby

Top Pro

Free

See All

score 1 · Answer 11

SQLBackupAndFTP

Top Pro

Free version

The free version can backup 2 databases to a network or FTP on schedule. See More

RickZeeland's Experience

Run scheduled backup of PostgreSQL databases as well as local files and folders and receive email notifications. See More

Specs

Platforms:Windows, Linux

See All

Answer 12

PSequel

Answer 13

Open PostgreSQL Monitoring

score 84 · Answer 14

dbForge Studio for PostgreSQL

score 2 · Answer 15

DbForge Studio for PostgreSQL

score 1 · Answer 16

13 Options Considered

My Recommendation for DbVisualizer

My Recommendation for DbVisualizer

In-line editing

Wildcard finder

Professional tool

Duplicate row button

My Recommendation for DBeaver

My Recommendation for DBeaver

Free

Works for many types of databases

Cross-platform

My Recommendation for Postico

My Recommendation for Postico

My Recommendation for pgModeler

My Recommendation for pgModeler

Diff scripts

Compiling

Reverse engineering

Export formats

My Recommendation for DataDog

My Recommendation for DataDog

My Recommendation for DB Lens

My Recommendation for DB Lens

Still in Beta

Free

My Recommendation for DbSchema

My Recommendation for DbSchema

My Recommendation for pg_catcheck

My Recommendation for pg_catcheck

My Recommendation for pg_activity

My Recommendation for pg_activity

My Recommendation for PostgreSQL Dashboard

My Recommendation for PostgreSQL Dashboard

No need to go through logs

Free

My Recommendation for SQLBackupAndFTP

My Recommendation for SQLBackupAndFTP

Free version

My Recommendation for PSequel

My Recommendation for PSequel

My Recommendation for Open PostgreSQL Monitoring

My Recommendation for Open PostgreSQL Monitoring

Don't see your favorite option? Add it.

My Recommendation for dbForge Studio for PostgreSQL

My Recommendation for dbForge Studio for PostgreSQL

My Recommendation for DataGrip

My Recommendation for DataGrip

My Recommendation for DbForge Studio for PostgreSQL

My Recommendation for DbForge Studio for PostgreSQL

My Recommendation for Valentina Studio

My Recommendation for Valentina Studio

One sec!