Features

The features, functions and GUI of DbVisualizer Pro

Smart, efficient & powerful

Connect to all major databases with a smart and powerful database tool built for efficiency. Improve your productivity and decrease time to learn by using one single tool for all your databases and OSes.

Advanced SQL features

Write queries in an advanced SQL editor that has all the smart features you need. Speed up your coding and avoid errors.

No coding skills? No problem

Access and understand your data even if you have no coding skills or database experience, thanks to powerful features.

Highly optimized features

Customize your workspace and use optimized features and functions, improved for over a decade by continuous feedback from thousands of professional users.

Connect to all your data, easily

DbVisualizer connects to most major databases and JDBC drivers. For common databases we have added support for database specific features, read more.
{{ database.name }}

* Will be supported very soon

Is your favourite database missing?

We support most databases with the generic database driver.

Generic database driver

Many of our users successfully use DbVisualizer with the following databases/data sources:

Miss a database, let us know!

Database

Information

{{ database.name }}
Check extended support

{{ database.name }} Database Specific Support

The following table shows the database specific support in DbVisualizer Pro for {{ database.name }} organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Miss a database, let us know!

Getting started

DbVisualizer works with a common UI on all major operating systems. Connect to your database via the step-by-step Connection Wizard or manually. Adjust your workspace the way you like it.

Supports all major OSes

DbVisualizer works on all supported operating systems, Windows, macOS and Linux/UNIX.

{{ feature.label }}

The DbVisualizer UI

The user interface gives you a lot of control over the layout and how to work with your database.

{{ feature.label }}

Task Management and Memory Monitoring

Features run in the background, monitored with interrupt support, so you can work with other tasks.

Connection management

Connection management is flexible. Set up a connection manually or via the step-by-step Connection Wizard.

{{ feature.label }}

Detailed users guide

Get started easily and improve your knowledge with our detailed users guide, straight from the developers.

Support from the developers

Get help in our extensive knowledge base with articles and forums or contact us for personal support.

Download for free

Experience and test the full power of the DbVisualizer Pro.

Screenshots

Check out our screenshots to get an overview of the DbVisualizer features and the user interface.

Go to screenshots

Screenshots

Check these screenshots to get an overview of the DbVisualizer features and the user interface. Click a thumbnail and then use right/left keyboard buttons to navigate to next/previous.

Manage your database

Browse and administer database objects such as tables, procedures, functions, triggers, etc.

Database Object Management

Browse and administer database objects such as tables, procedures, functions, triggers, etc.

{{ feature.label }}

Database Browser

Visually navigate the objects in the database, run actions and open objects for more details.

{{ feature.label }}

Table

Visually create, alter, drop and rename tables. Specific actions added for the supported databases.

{{ feature.label }}

Procedure, Function, Package and Trigger

Support for PL objects such as procedures, functions, packages and triggers.

{{ feature.label }}

Export Schema/Database

Export the DDL for objects such as tables, views, procedures, functions, triggers, packages and package bodies.

{{ feature.label }}

References Graphs

Automatically render all primary/foreign key mappings (also called referential integrity constraints) in a graph style.

{{ feature.label }}

Table Data Management

Handle the data in a table. Edit, import, export, etc.

{{ feature.label }}

Table Data Viewer/Editor

Manage table definitions and table data. Table data can be edited via the spreadsheet-like editor or via the form editor.

{{ feature.label }}

Table export

The DDL and data for a table can be exported in various formats to a file, the system clipboard or an SQL editor.

{{ feature.label }}

Table data import

The import feature reads CSV files and Excel spreadsheet files. The data can be imported to a new table.

{{ feature.label }}

Data navigator

Follow foreign keys by data. Want to know what employees works in "DEPT_ID = 56"? The navigator is all about this.

{{ feature.label }}

Run SQL scripts

Write and run queries in the advanced SQL editor that speeds up your coding and reduce errors with features such as auto-completion and syntax/error highlighting.

SQL Query Tools

The SQL Tools are centered around the SQL Commander, with its SQL Editor and Query Builder.

Database Server Management

The SQL Tools in DbVisualizer is centered around the SQL Commander, with its SQL Editor and Query Builder. Additional features are the Scripts, SQL History, Explain Plan and support to display result sets as stunning graphs.

Get detailed information in the Users Guide.

SQL Query Tool

The SQL Commander supports multiple editors and result sets, bookmark feature, formatting, script execution and extensive customization.

{{ feature.label }}

Result Set Management

The grid component is a very central component in DbVisualizer and it provides a lot of convenient context-dependent features.

{{ feature.label }}

Query Builder

The Query Builder provides an easy way to develop database queries.

{{ feature.label }}

Client-side commands

Client-side commands are script commands that are executed in the context of DbVisualizer.

{{ feature.label }}

Explain Plan

Explain Plan is a way to analyze how a query will be processed by the database, for instance whether an index can be used or if a full table scan is required.

{{ feature.label }}

SQL History

The SQL history feature displays information about scripts you have executed in the SQL Commander.

{{ feature.label }}

SQL Bookmarks

The bookmark feature is used to organize frequently used SQL statements in a folder structure.

{{ feature.label }}

Charts

Any result set produced by a query in the SQL Commander can be visualized in a chart.

{{ feature.label }}

Command-line Interface (CLI)

Run DbVisualizer SQL scripts without the GUI ever being displayed.

{{ feature.label }}

Optimize queries - explain

The explain plan* feature visually presents how well the query perform. This tool helps optimizing queries for best performance.

{{ feature.label }}

Parameterized SQLs

Running the same queries over and over again? Parameterize them and let DbVisualizer prompt for values.

{{ feature.label }}

SQL formatter

The formatter helps organize complex SQLs into readable and organization wide standards.

{{ feature.label }}

Visual query builder

Visually create SQL queries without writing code. Generate SQL code by drag and drop.

{{ feature.label }}

Visualize your database

Create and manage the database visually. Generate SQL code by drag and drop and copy and paste it into other applications.

Database browser

Visually navigate the objects in the database, run actions and open objects for more details.

{{ feature.label }}

Visualize tables

Visually create, alter, drop and rename tables. Specific actions added for the supported databases.

{{ feature.label }}

Get more productive

DbVisualizer's features have been optimized with feedback from thousands of users. Benefit from features that make you faster, let's you minimize mistakes and work in a secure way.

  • Favorites: tag your favorites for one click access

    {{ feature.label }}

  • Monitor: real-time monitoring of the database.

    {{ feature.label }}

  • Compare: see how objects differ side by side.

    {{ feature.label }}

  • Configurable: DbVisualizer is highly configurable.

    {{ feature.label }}

  • Export/Import User Settings: reuse your setup.

    {{ feature.label }}

  • Auto-update: get notifications or auto update.

    {{ feature.label }}

Secure your work

Connect with high security. Access databases through SSH. Stay secure with strong master password security. Stay focused with autosave of your workspace.

{{ feature.label }}

Strong master password

A master password raises security considerably. The master password is requested once per DbVisualizer session.

Access through SSH

Access databases through SSH to secure an encrypted connection between two hosts over an insecure network.

Save your work

Autosave your workspace and resume where you left off with editors preserved between sessions.