Postgres client

The PostgreSQL client with the highest user ratings

Tested for PostgreSQL version 8-11
Postgres client
Postgres client
DbVisualizer has a long history of being a top-performing PostgreSQL editor.
Postgresql G2 badge
Postgresql client

A powerful PostgreSQL client

Use DbVisualizer to connect and manage your Postgres databases. With extended support for pgSQL specific object types you can enjoy the full suite of smart features that DbVisualizer has to offer.

Support for PostgreSQL object types

Object types

PostgreSQL includes many different object types. There are object types commonly found in several databases, like Schemas and Tables. Other object types are unique, such as Sequences, Domains and Aggregates. In DbVisualizer, you’ll easily find and manage all objects in your database.

Object type actions

Each object type has a unique purpose and supported actions. As a powerful PostgreSQL Client, DbVisualizer supports the unique actions of every object type in pgSQL. You can write custom SQL to perform the actions, or simply right-click on the object and select the preferred action.

Learn more about what object types are supported for PostgreSQL.

Postgresql object types

Simple, yet powerful PostgreSQL editor

Auto-complete

Writing SQL for pgSQL is similar, but not exactly the same as for any other database. DbVisualizer understands these differences and will make relevant suggestions, so that you can create SQL queries more efficiently.

SQL formatting

Copy-paste long unformatted SQL queries for into DbVisualizer, and automatically format it in the way you prefer directly in the PostgreSQL client.

Variables

Once you’ve created a beautiful and complex query you might need to execute it several times, only changing small details. DbVisualizer supports the use of client-side variables, which will help you simplify this processes significantly.

Learn more about the supported features for PostgreSQL.

Postgresql autocomplete

Automatic visualizations for your PostgreSQL databases

Entity relationship diagrams (ERDs)

Postgres is a relational database, and as such the relations between tables and data is crucial to understand. DbVisualizer will help you automatically generate visual ERDs so that you can better understand dependencies and opportunitites, directly in the client.

ERD Postresql
See the ERD feature
Postgresql ERD illustration

Explain plans

DbVisualizer can present a visual explain plan from the database to help guide you in writing queries that the database can handle more efficiently.

Postgresql ERD illustration
Postgresql scheduling pgagent

Scheduling with pgAgent

DbVisualizer supports the use of pgAgent for scheduling of tasks.

Jobs can also be automatically scheduled outside of the PostgreSQL client, using the command-line interface and the pre-built scheduling tools of your OS.

Try DbVisualizer Pro

Start your free 21 day evaluation of DbVisualizer Pro
Maven Postgresql driver

JDBC driver management via Maven

DbVisualizer has the most up-to-date PostgreSQL JDBC driver included, and historical version. In fact, it has full JDBC driver management built right in. It connects you to your databases using JDBC drivers hosted on Maven, and supports different version of each JDBC driver.

Maven Postgresql driver
Postgresql driver manager

PostgreSQL specific properties

DbVisualizer allows you to specify properties specifically for your pgSQL database, so that you can make it the best PostgreSQL client matching your preferences. Do you want User ID and password to be prompted to the user? Do you want scripts to be pre-processed? Do you want to disable auto-commit? These proporties and many more can be configured directly in the PostgreSQL manager to match how you want to work.

Postgresql properties

Users love using DbVisualizer
with PostgreSQL

  • Tim S
    Teamlead

    DbVisualizer is everyday software for working with Postgresql and Mysql servers. It's easy to connect, create, delete DBs, tables, construct and debug SQL queries.
    Verified PostgreSQL user.
    Review from G2.
    g2 review
  • Stephen A
    Software Engineer

    When you are a developer you need decent access to multiple databases and vendor databases. Having that in one tool is also excellent. I go between PostgreSQL, SQLServer, and Oracle all the time simultaneously.
    Verified PostgreSQL user.
    Review from G2.
    g2 review
  • Josh M
    VP of Engineering

    I use DBVisualizer for all sorts of tasks, from managing and maintaining production Postgres databases to connecting and managing local and containerized databases. I love the ability to manage many different RDBMSs from the same interface, as well as the ability to generate diagrams and models from existing databases.
    Verified PostgreSQL user.
    Review from G2.
    g2 review
  • Charles C
    Senior DB Engineer

    Ideal if you need to deal with different RDBMS The fact of using a single tool to access all the database types I had to deal with (PostgreSQL, MySQL, Oracle and MSSQL Server).
    Verified PostgreSQL user.
    Review from Capterra.
    capterra review
  • Mauri S
    Development Manager

    I can access Microsoft SQL server, Postgresql and Mariadb/mysql with the same tool. It can found the metadata and data definitions of all of them. I can't even remember how many years I've used it but I use it for my hobby projects at home and my work projects at work. It is awesome.
    Verified PostgreSQL user.
    Review from Capterra.
    capterra review
  • Tim S
    Teamlead

    DbVisualizer is everyday software for working with Postgresql and Mysql servers. It's easy to connect, create, delete DBs, tables, construct and debug SQL queries.
    Verified PostgreSQL user.
    Review from G2.
    g2 review
  • Stephen A
    Software Engineer

    When you are a developer you need decent access to multiple databases and vendor databases. Having that in one tool is also excellent. I go between PostgreSQL, SQLServer, and Oracle all the time simultaneously.
    Verified PostgreSQL user.
    Review from G2.
    g2 review
  • Josh M
    VP of Engineering

    I use DBVisualizer for all sorts of tasks, from managing and maintaining production Postgres databases to connecting and managing local and containerized databases. I love the ability to manage many different RDBMSs from the same interface, as well as the ability to generate diagrams and models from existing databases.
    Verified PostgreSQL user.
    Review from G2.
    g2 review
  • Charles C
    Senior DB Engineer

    Ideal if you need to deal with different RDBMS The fact of using a single tool to access all the database types I had to deal with (PostgreSQL, MySQL, Oracle and MSSQL Server).
    Verified PostgreSQL user.
    Review from Capterra.
    capterra review
  • Mauri S
    Development Manager

    I can access Microsoft SQL server, Postgresql and Mariadb/mysql with the same tool. It can found the metadata and data definitions of all of them. I can't even remember how many years I've used it but I use it for my hobby projects at home and my work projects at work. It is awesome.
    Verified PostgreSQL user.
    Review from Capterra.
    capterra review

DbVisualizer is a G2 Leader among
database management software

Frequently asked questions