DbSchema Database Designer

DbSchema vs DbVisualizer

Publish on DbSchema Blog >>>

DbVisualizer and DbSchema are two powerful tools for designing and managing databases. Further, we will compare both tools
focusing on 5 main points:

  • Connectivity
  • Interface
  • Schema & Diagram
  • Query Tools
  • Managing Data
  • Price


Both DbSchema and DbVisualizer can connect to any SQL, NoSQL and Cloud database using JDBC drivers.



DbVisualizer offers an interface that enables users to interact with database objects. It integrates a tree menu on the
left side of the screen from which the user can browse the objects and open them in the middle working area.

The working area can contain multiple Object View tabs or SQL Commander tabs. The first category opens a database object
that can be modified or browsed. In the SQL Commander, the user can run simple queries or scripts.

dbvisualizer interface


The interface on DbSchema offers more of a visual approach to database browsing. On the left side of the screen, there is
a classic tree menu from which the user will browse databases, schemas, and tables. The tables can be dragged to the center and arranged in a layout.

A user can open multiple layouts, each focused on any part of the database. A table can be opened in multiple layouts at the same time.
The layouts are interactive and any database object can be modified directly in the schema (tables, columns, foreign keys, indexes, etc.).
The layout contains the query tools that open at the bottom of the screen.

dbschema interface

Query Tools


SQL Editor

The SQL editor can run single queries and scripts. A frequently used query can be saved to a template and re-executed
when needed. For complex scripts, DbVisualizer offers options that save memory and prevent the app from crashing.
Also, the user can select specific SQL blocks from the script and run them separately.

dbvisualizer sql editor

Visual Query Builder

The Visual Query Builder runs as an extension of the SQL editor. It can create queries using all types of Joins with
Aggregate and Group functions. At the bottom of the editor, there are 4 columns that provide a detailed view of the query.
From here, the user can modify the Aggregate & Group functions, Conditions and sort the results.

dbvisualizer query builder

The visual query can be copied and executed in the SQL editor and the results will be shown at the bottom.

dbvisualizer execute query

The results from the queries can be exported to various formats.
The queries themselves can be saved and compared. In the case of an error, this will be displayed in the results panel.


SQL Editor

The tool integrates an SQL editor that can also run single queries or scripts. It can run Groovy or JavaScript.
In the case of a complex script, the powerful engine will handle the parsing and execution smoothly.
The user can select a single part of a script and run it. The SQL History shows every query executed in the application
(visual or in the SQL editor). The user can re-execute e query from there by copying it to the editor.

dbschema sqleditor

Visual Query Builder

DbSchema offers a Visual Query Builder in which the tables can be added by drag & drop.
From an added table, the user can right-click on the header and add another one based on foreign keys. The tool can create
visual queries using any type of Joins with Aggregate and Group functions. On the right side of the screen, the
Preview tab shows the visual query in SQL language. After executing, the results will be shown at the bottom of the screen.

dbschema visual query

Both SQL editor and Visual Query Builder can explain a script and export the result in various formats.

Relational Data Editor

DbSchema integrates another query tool named Relational Data Editor. Users can visualize & edit data from multiple tables
simultaneously. Once a table is open in Relational Data Editor, the user can cascade into further tables based on foreign keys.
When a table selection changed, the referenced data from the other tables change accordingly.
Data can be edited just by double-clicking on a cell.

dbschema data explorer

Schemas & Diagrams


In DbVisualizer, the user mainly interacts with the schema and the objects from the left menu. A table can be altered by
right-clicking on it in the node. From there the user can alter its columns, primary keys, foreign keys, and indexes.
For every change made, the SQL syntax will be shown below.

dbvisualizer alter table

DbVisualizer can open the ERD diagram by right-clicking on the node and opening it in object view. The objects can be
arranged in many different layouts and the diagram can be exported to JPEG, SVG, PNG, PDF, GIF or GML.

dbvisualizer diagram

Although DbVisualizer can’t compare the schemas in terms of objects and data, the user can select the items one by one
and compare them. For example, two table nodes can be opened in separate tabs and compared.


DbSchemas’ whole workflow is based on the diagram. Once a layout is created and filled with tables, the user can interact
with the objects in the diagram. Tables and columns can be modified by double-clicking on them. Once clicked a new window
appears with all the details that can be edited.

dbschema alter table

Foreign keys can be created either from the table editing dialog or by drag & dropping a column over another. In DbSchema
every object from the diagram is interactive. The user can see where a foreign key is pointing by hovering it with the
mouse or change it’s pointing direction from the top menu. It is possible to create a virtual foreign key that exists only in the
model file and doesn’t affect the database.

dbschema foreign key

For Mongo DB, DbSchema can deduce the database diagram by analyzing the JSON objects.

DbSchema saves everything to a local model file that can be reopened even without database connectivity.

dbschema offline

When in offline mode, the user can modify every aspect of the schema. After reconnecting to the database, the local schema will be compared &
synchronized with the database schema.

dbschema synchronization

Working with model files makes it very easy to work in a team. Two different versions of the same model file can be
compared, synchronized and shared in a team using GIT.

DbSchema can export interactive HTML5 or PDF documentation.

dbschema documentation

Working with data


To interact with the data in DbVisualizer, the user has to open the table and select the data tab. Cells can be modified
by clicking on them. The grid view is pretty straightforward and solid. The tool can read & format text, JSON files or images.

dbvisualizer edit data

The user can compare the DDL and data of two tables. DbVisualizer can import data from CSV format and Excel (.xsl and .xslx).

dbvisualizer compare ddl


DbSchema has a more visual approach to browsing & editing data. First, the tool integrates a quick view function that
can be opened by clicking on a table header while holding CTRL + SHIFT keys. This will open a floating window of the table.
From here the data can be edited by clicking on the cell.

dbschema quick view

Another way of browsing the table data is with the Relational Data Editor explained in a chapter above. This feature offers
an overview of the relations between data.

dbschema data explorer

DbSchema can load data from delimited text files, CSV and Excel (.xsl, xlsx) formats. The user can do this through a simple
Data Loader wizard.

For generating test data, DbSchema integrates a powerful Data Generator that uses configurable, random and reverse
regular expressions. The user can choose data patterns from the integrated library or configure its own data patterns.

dbschema data generator



The price for a DbVisualizer Pro license starts at $195/ user with an additional $69 for yearly licence renewal. The tool also comes with a
free version.
DbVisualizer offers discount for academic institutions and for bundle purchase.


DbSchema offers 3 types of licenses:

  • Academic - $98
  • Personal (for individuals) - $196
  • Commercial (for companies) - $294

Discounts will be applied for bundle purchase.


When to use DbVisualizer

DbVisualizer has a more technical approach to database design. If you don’t mind writing and reading complex SQL syntax, than DbVisualizer can
be a good tool. It has some nice features such as SQL templates or Query Monitoring, but lacks others like Schema Comparison or Random Data

When to use DbSchema

DbSchema offers a more visual approach to database design. You can easily interact with the diagram and execute queries only by drag & drop or
double-click. Working with the model files makes it very easy to compare different versions of the schema or work in a team.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.