POSTGRESQL

The PostgreSQL client with the highest user ratings.

Club
Box
+31
* EXTENDED SUPPORT
SUPPORT FOR RULES, TRIGGERS, SEQUENCES & 16 MORE POSTGRESQL SPECIFIC OBJECTS.
postgresql editor
g2 logo

*****
4.6 (100+ REVIEWS)
#1 HIGHEST RATED
IN DATABASE MANAGEMENT SYSTEMS

g2 logo

*****
4.6 (100+ REVIEWS)
#1 HIGHEST RATED
IN DATABASE MANAGEMENT SYSTEMS

A TOP-PERFORMING POSTGRESQL EDITOR

A Powerful PostgreSQL client.

Download for free ↓
Recommended Installer
windows
Windows 64bit With Java
windows
Windows Arm64 With Java
linux
Linux Without Java
mac
macOS Intel With Java
mac
macOS Apple Silicon With Java

DbVisualizer has a long history of being a top-performing PostgreSQL editor.

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.

OBJECT TYPES AND ACTIONS

PostgreSQL object specific support.

DbVisualizer has been built to provide you with maximum control over your PostgreSQL database. That’s why we offer custom support for all specific object types and actions

Triggers

Called automatically whenever an edit event occurs in the database.

Sequences

User-defined schema-bound object that yields a sequence of integers.

Rules

Causes additional commands to be executed on triggering of an action.

Rules Causes additional commands to be executed on triggering of an action.
Rules Causes additional commands to be executed on triggering of an action.

PROPERTIES

Specific properties for PostgreSQL.

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? Scripts to be pre-processed? Disable auto-commit?

The properties below and many more can be configured directly in the PostgreSQL manager to match how you want to work.

authentication
AUTHENTICATION
Delimited identifiers
DELIMITED IDENTIFIERS
Qualifiers
QUALIFIERS
Physical connection
PHYSICAL CONNECTION
Transaction
TRANSACTION
Encoding
ENCODING
sql statements
SQL STATEMENTS
Connection hooks
CONNECTION HOOKS
COLOR AND BORDER
sql commander
SQL COMMANDER
query builder
QUERY BUILDER
Explain plan
EXPLAIN PLAN

SQL EDITOR

The universal
database tool.

DbVisualizer is meticulously engineered to handle objects and properties specific to PostgreSQL - but our out-of-the-box features work across almost any data source.

VISUALIZATION

Automatic visualizations.

Postgres is a relational database and DbVisualizer will help you automatically generate visual Entity Relationship Diagrams so that you can understand dependencies and opportunities, directly in the client.

Automatic visualizations

EDITOR

A powerful editor for PostgreSQL.

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 queries

SCHEDULING

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.

FREE TRIAL

Try DbVisualizer Pro
for free.

Start your free 21 day evaluation of DbVisualizer Pro

Download for free ↓
Recommended Installer
windows
Windows 64bit With Java
windows
Windows Arm64 With Java
linux
Linux Without Java
mac
macOS Intel With Java
mac
macOS Apple Silicon With Java

MAVEN

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.

Postgresql driver manager
Maven
Maven

reviews

Our users love our product.

Don’t take just our word for it. Our users are vocal fans of our product.

Name:

Tim S

Role:

Teamlead of Back-end Golang command

*****

I love the fact that DbVisualizer works with all the database systems that I have databases in. It makes life VERY easy for me to go back and forth from MS SQL Server to MariaDB to PostgreSQL to MySQL. AND, I also have options if I have to work with others too!

I love the fact that DbVisualizer works with all the database systems that I have databases in. It makes life VERY easy for me to go back and forth from MS SQL Server to MariaDB to PostgreSQL to MySQL. AND, I also have options if I have to work with others too! show less

G2 logo

Verified user.

Review from G2.com

Name:

Michael L

Role:

Owner, Director of Managed Services

*****

If you dig into Oracle, Postgres, SQL Server, DB2, MySQL and other databases regurarly, this tool is for you!

If you dig into Oracle, Postgres, SQL Server, DB2, MySQL and other databases regurarly, this tool is for you! show less

G2 logo

Verified user.

Review from G2.com

Name:

Education Management

Role:

Administrator

*****

I use it for MSSQL, MySQL, Pg and sometime sqlite. Its great to have the same tool for all those different database engines. I really like that i can ssh tunnel into my servers and then connect to the database. Its cross-platform support is very nice, my co worker uses windows and i use linux so being able to use the same software helps us.

I use it for MSSQL, MySQL, Pg and sometime sqlite. Its great to have the same tool for all those different database engines. I really like that i can ssh tunnel into my servers and then connect to the database. Its cross-platform support is very nice, my co worker uses windows and i use linux so being able to use the same software helps us. show less

G2 logo

Verified user.

Review from G2.com

Name:

Raymond J

Role:

Small-Business(50 or fewer emp.)

*****

What I like best is the easy way to explore data and see the links between data sets. I have used it against sql server, Oracle, Postgresql.

What I like best is the easy way to explore data and see the links between data sets. I have used it against sql server, Oracle, Postgresql. show less

G2 logo

Verified user.

Review from G2.com

Name:

Niels C

Role:

Developer

*****

Tons of features. Most importantly great editor with autocomplete.

Tons of features. Most importantly great editor with autocomplete. show less

Capterra logo

Verified user.

Review from CAPTERRA

Name:

Dominik H

Role:

Senior Software Engineer

*****

Extremely helpful on a day to day base for typical software developments needs

Extremely helpful on a day to day base for typical software developments needs show less

Capterra logo

Verified user.

Review from CAPTERRA

Name:

Leandro L

Role:

Mid-Market(51-1000 emp.)

*****

Nice user interface, lightweight, inline edits allowed, being able to import and export my connections, great technical support

Nice user interface, lightweight, inline edits allowed, being able to import and export my connections, great technical support show less

G2 logo

Verified user.

Review from G2.com

Name:

Robert Y

Role:

Engineer / Developer

*****

One of the best things about DbVis (apart from the fact that it just works) is that the tech support team is always super responsive.

One of the best things about DbVis (apart from the fact that it just works) is that the tech support team is always super responsive. show less

Sourceforge logo

Verified user.

Review from SOURCEFORGE

Name:

Clark G

Role:

Director, Research Technology Services

*****

One of the best software products I've ever used. I have especially appreciated that there is a cli tool as well as an excellent IDE experience.

One of the best software products I've ever used. I have especially appreciated that there is a cli tool as well as an excellent IDE experience. show less

Sourceforge logo

Verified user.

Review from SOURCEFORGE

Name:

Michael B

Role:

Senior Backend Engineer

*****

Provides a common interface to many different databases. Easy to use.

Provides a common interface to many different databases. Easy to use. show less

Capterra logo

Verified user.

Review from CAPTERRA

G2 REVIEWS

Used and rated
by the best.

DbVisualizer is a G2 Leader among database management software.

G2 users love us
Most likely to recommend
G2 Best results

FAQs

QUESTION
Action
WHAT IS POSTGRESQL?

PostgreSQL is a relational database built open source.

View + Hide -
WHAT IS A POSTGRESQL CLIENT?

PostgreSQL client is a tool for connecting to and manage your PostgreSQL database from your OS.

View + Hide -
WHAT IS POSTGRESQL DATABASE CLIENT USED FOR?

A PostgreSQL client is used to manage, update and create tables in your database.

View + Hide -
HOW DO I CONNECT TO POSTGRESQL WITH DBVISUALIZER?

You connect your database using JDBC driver, DbVisualizer has a driver manager is built in. Here is how you connect to a SSL enabled PostgreSQL server.

View + Hide -
HOW CAN I USE DBVISUALIZER AS A QUERY TOOL?

DbVisualizer allows you to write SQL queries, which clever highlighting of operations and autocomplete suggestions. DbVIsualizer also has a visual query builder, that automatically generates SQL code as you drag and drop tables and select what values you want to include.

View + Hide -
HOW DO I GET STARTED TO USE POSTGRESQL WITH DBVISUALIZER?

Download DbVisualizer, and connect to your PostgreSQL database. You can use the client for free with limited functionality, try the Pro version for 21 days or buy the Pro version to get the full function set.

View + Hide -
WHAT ARE THE BENEFITS OF USING POSTGRESQL?

Postgres offers a very versatile database with a large community, thanks to it's open source nature. It is SQL based with relations between data and tables. It is widely used by several companies, professionals and hobby programmers.

View + Hide -
CAN I CONNECT TO POSTGRESQL AND OTHER DATABASES USING DBVISUALIZER AS A POSTGRESQL CLIENT?

Yes. As many businesses have multiple data sources for their various applications and other systems we've ensured that you can connect to all popular data sources within DbVisualizer.

View + Hide -
HOW CAN I CONNECT TO MY DATABASE USING THE POSTGRESQL JDBC DRIVER?

The PostgreSQL JDBC driver is already bundled with DbVisualizer, so there is no need to download anywhere else. With the driver manager you can just select PostgreSQL from the list of available data sources you want to connect to, enter the credentials and DbVisualizer automatically set up the connection for you. It's super easy.

View + Hide -
WHAT OBJECT TYPES ARE SUPPORTED IN THE DBVISUALIZER POSTGRESQL CLIENT?

DbVisualizer has deep support for specific PostgreSQL functions and object types. For the full list, please see PostgreSQL supported object types.

View + Hide -
WHAT ARE SOME OF THE FEATURES OF THE POSTGRESQL GUI IN DBVISUALIZER?

In DbVisualizer you can customize the layout and functions to match your workflow. Put multiple SQL editors next to each other for quick comparisons, save scripts, re-arrange tabs, work with variables, get help with the Auto-complete feature and much much more. It is built to make your life easier.

View + Hide -
WHAT IS THE DIFFERENCE BETWEEN A POSTGRESQL CLIENT, A POSTGRESQL GUI, A POSTGRESQL IDE, A POSTGRESQL EDITOR AND A POSTGRESQL WORKBENCH?

The different labels of the environment in which you work with PostgreSQL have come mean more or less the same thing. While a client indicates that you have a server elsewhere, the GUI refers to the graphical interface of the application. IDE refers to the larger "integrated development environment" and the editor refers to in actual part of the client in which you write your code. A workbench focuses more on the process of development itself. However, all of these have come to be synonym in how people refer to the application in which you do the actual coding.

View + Hide -
IS THERE A DATABASE BROWSER IN DBVISUALIZER?

Yes, you can use DbVisualizer to browse your database. For each database you can see the tables, relations and custom objects that have been created. There are automatic visualization tools for you to generate Entity Relationship Diagrams (ERDs) or see the servers explain plan.

View + Hide -
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗