ScreenshotsScreenshots

Supported OS'es

 

               
DbVisualizer runs smoothly on the Windows platform, here with the
Windows look and feel
DbVisualizer on Windows

               
DbVisualizer on Mac OS X with the Aqua look and feel
DbVisualizer on Mac OS X

               
DbVisualizer on Linux/UNIX with the Synthetica Standard look and feel
DbVisualizer on Linux/UNIX


The DbVisualizer UI

 

               
This shows a maximized result-set tab in the SQL Commander labelled "1: HR Production Unititled".
Maximized tab

               
The top-level tab types, Object View and SQL Commander, can be dragged to desired
positions in the workspace area. There are also actions in the tab right-click menu to
 automatically tile all top-level tabs or collapse them into a single tab group.
Top-level tabs side-by-side

               
For each database object type being presented in DbVisualizer there are a lot of
information presented in sub-tabs. Users may decide to hide certain tabs, rearranging them
or present some side-by-side with other tabs. The layout can be saved between DbVisualizer
sessions and is automatically loaded at next open of the object type. This example show
a table in Oracle that is maximized with 3 sub-tabs organized side-by-side. In additon
are the top-level toolbar, object view header and the favorites bar not visible to
better use the space in the window.
Save Layout of Individual Object Types

               
The Object View tab offer great configuration options specifically for each
object type in the database. You may for example decide to show only 4 sub-tabs for a table
in MySQL where each of the tabs are presented side-by-side. In for example Oracle
you may configure a completely different layout with another set of tabs.
The layouts may be saved between sessions and are automatically loaded at next run.
Object View tab with sub-tabs side-by-side


Task Management and Memory Monitoring

 

Task Manager

Memory Monitor


Connection Management

 

               
Defining a database connection is a simple task using the Connection Wizard in
DbVisualizer. In the wizard, choose what database you are connecting to,
information about the JDBC driver and finally the details about the database
server and user credentials. An alternative to the wizard is to setup the
connection manually via the Server Info and Database URL forms in the Connection tab.
Connection Wizard

               
Along with the Connection Wizard is the Server Info the preferred methods to
manage connection details. It presents the various parameters in a form that
adapt the choices based on your input. The screen image also show the SSH fields.
Connection setup using Server Info and SSH

               
The conventional JDBC setup is used for databases with no pre-defined
Server Info.
Connection setup using Database URL

Connection Details with Variables
 

Connection Properties

               
For each database connection you may assign a color and/or border. These will appear
for the components in the DbVisualizer GUI that are referenced by the connection.
This is useful in order to quickly determine what parts belong to which connection.
Borders and Colors

JDBC Driver Manager


Database Browser

 

                  
The database browser in DbVisualizer is the place where you navigate the structure
of objects available in the database server. The information in the tree
depends on what database is being accessed.
Database Browser when connected to a Oracle DB

                  
Every object (node) in the tree has an accompanying right-click menu with
actions specifically for that object. What actions are available depends
on the object type but are typically used to create, alter, rename and remove
objects of that type.
Right click menu actions for a table in Oracle

                  
You may search the database based on object names
Database Search

                  
When you select an object in the Database Browser, you see a number of tabs
in the Object Details pane to the right. What is displayed here depends on what database
you are accessing and the type of object you select.
Table Object Details
 

                  
Some object actions can be executed for multiple objects in a single run. Actions
not accepting multiple objects are disabled in the right-click menu.
Drop Multiple Tables (and other objects)

                  
Any object can be scripted based on what object type it is. For tables the scripting
feature can generate SQLs such as SELECT, CREATE, INSERT, UPDATE, etc. The scripting
feature is either started using the right-click menu in the databases list or by dragging
the actual objects to an existing SQL Commander editor or on the main toolbar area
to create a new editor.
Table Scripting (and other objects)

                  
Selecting the top level Connection row will show an overview of all connections
and their connection details.
Connections overview


Table

 

                  
The Create Table feature is used to specify the definition of a database table in
terms of columns, keys, indexes, foreign keys, constraints, etc. This screenshot
show the Columns information with the instant SQL Previewer visible.
Create Table

                  
Specify foreign keys to other tables
Define Foreign Keys

                  
The alter table feature enables visual editing of the table structure. This
screenshot also shows the SQL Preview area. This is the SQL that DbVisualizer
will run when Execute is pressed.
Alter Table

                  
The create index table action is used to create non-unique and unique indexes.
Create Index
 

                  
The CREATE TABLE DDL can be browsed.
Browse Table DDL


Procedure, Function, Package and Trigger

 

                  
This screenshot show the action used to create a
stored procedure in a SQL Server database.
Create Procedure

                  
Click a procedure in the database browser and the Procedure Editor is
activated in the object details pane.
Edit Procedure

                  
Clicking Execute in the Procedure Editor executes the procedure in the 
SQL Commander and prompts for IN/INOUT parameters. The return value and 
OUT/INOUT parameter values are written to the log.
Execute Procedure

                  
The Create Trigger action dialog lets you visually define a new trigger
Create Trigger


Export Schema/Database

 

                  
Exporting in CSV format allows export of table data only.
Export Database in CSV

                  
Exporting in HTML format allows export of table data only.
Export Database in HTML

                  
Exporting in SQL format supports export of the DDLs and table data. The output is
SQL statements that can be re-executed in DbVisualizer or in a 3:rd party tool.
Export Database in SQL

                  
Exporting in XML format allows export of DDLs and table data.
Export Database in XML
 

                  
Exporting in XLS/XLSX format allows export of table data only. XLS is the old binary
format for XLS while the XLSX format is the XML based OOXML format.
Export Database in XLS/XLSX

                  
Exporting in JSON format allows export of table data only.
Export Database in JSON


References Graphs

 

                  
This screenshot shows a zoomed portion of the tables in the MS SQL Server,
AdventureWorks2012_CS sample database.
Graph Tables in a Database

                  
The references graph have options to align the relations to the actual columns
forming the primary/foreign keys. This screenshot show relations pointing to the
actual columns.
Aligned Relations

                  
Full table details can be displayed in a separate window and selected tables
can be scripted using the Script Table right-click menu feature.
Show Full Table Details


Table Data Viewer/Editor

 

                  
The inline data editor is a spreadsheet-like editor. Just open a table and modify
the data you want. Modified cells are indicated to represent the type of edit.
You may paste information into a multi row/cell selection and the pasted data
will update the corresponding cells. Once you're ready, all changes are propagated
to the database table in a single transaction. In addition you may sort one
or several columns, filter the data being presented and a lot more.
Grid Table Data Editor

                  
The form data editor is useful when editing a row that is either
composed of many columns and/or some fields contain much data. The data for a
row is presented in a form with the column name to the left and the actual data
in the right area.
To launch the form editor, either select Edit in Form or double click
the row header. The form editor is also used to visualize binary data
such as images, XML, etc.
Form Table Data Editor

                  
Open the SQL preview to browse what SQLs will be executed once saving the
edits.
Display the most common image formats

                  
The inline data filtering allows quickly entering a WHERE clause that is used
when getting the table data from the database. Column names can be auto-completed using
Ctrl-Enter. Filters may be saved between
sessions and easily applied in a drop-down list. The extended Filter Configurator
supports more detailed support designing the WHERE and ORDER BY clauses.
Inline Filtering Setup


Table Export

 

Export Table

                  
There are a number of options to control data formats and other details of the
export result.
Configure Data Formats, Quoting, etc.


Table Data Import

 

                  
The file viewer show the file as it look on disk. This is useful to check what
delimiters are being used, quotes, column header, etc.
Raw File Viewer

                  
The import feature tries to auto detect what column separators being used. This
can be manually overidden along with settings to control if text data is enclosed
in quotes, if empty rows should be ignored and if there is a column header row.
Data Delimiters and File Configuration

                  
Data types are automatically recognized when the file is loaded. To change this
click the first row cell and choose the appropriate type from the list.
Data Type Setup

                  
Columns in the file are automatically mapped to columns in the table, based on
either the name or the index. You can also map the columns manually.
Import Column Mapping
 

                  
A new table can be created for the imported data. The data type for each column
is determined automatically from the data and the specific types supported by
the database. You can adjust the types manually.
Import to a new table


Data Navigator

 

                  
The navigator starts at the current table. The diagram at the top shows the
checked tables and their relationships. The lower grid shows the actual data
that is referenced by the primary/foreign key mappings. Select the data in the
grid and what constraint to follow in the "Related Table" drop down and
the navigator will render the referenced table in the diagram. The linked
data is displayed in the grid. You may jump back and forth by selecting
table nodes in the diagram. Nodes may be tagged with information from the
table data to make it easier to recognize them.
The Table Data Navigator


SQL Editor

 

                  
The SQL Editor supports auto completion which is an aid used to complete
sentences with either table or column names. Specify the beginning of a table
name and then press Ctrl+SPACE to show a list of matching names. The screenshot
show 3 select statements and their respective result as grid tabs in the lower part.
SQL Editor with Auto Completion and result sets in Grid format

                  
A result set displayed with the Text output format.
Execution of selected SQL with result set in fixed width Text format

                  
Any result set may be presented as a chart. There are several options
to control the appearance and these are preserved for new result sets
when running more select statements.
Result set in Chart format

                  
The data in a result set may be edited via the inline or form editors, as long as certain conditions are fulfilled.
Edit result set either inline or in the form editor
 

                  
Enter variables in the script and DbVisualizer will prompt for real values
at execute. The variable window remembers previously used values and is useful
if running the same SQL only with minor differences between the runs.
Variables in the SQL

                  
Finding errors in SQL scripts may be a tedious process. The error highlighting in
the SQL Commander show errors with a wavy underline and when hovered the error text is
displayed. Error highlighting is supported for Oracle, MySQL, PostgreSQL,
Informix, JavaDB/Derby and Mimer SQL.
Error highlighting


Query Builder

 

                  
The query builder is a very useful feature used to build SQL select statements
graphically. Pick tables in the database browser and drag them into the
query builder diagram area or use the quick-add feature in the query builder.
Then draw lines between columns in one table node
and attach to columns in another table node. These lines represent the joins
in the generated SQL. The tabs below the diagram area are used to specify any
COLUMNS, WHERE, ORDER BY and GROUP BY clauses.
Table Diagram and Join Properties

                  
In addition to the previous screenshot the query builder supports loading an
existing SQL statement so that it can be edited in the query builder.
Column Select list

                  
Once you are satisfied with the query, just pass it on to the SQL Commander
for test execution. If you need to make any refinements just
switch to the query builder and continue editing the query.
Generated and test SQL


Explain Plan

 

                  
The explain plan feature presents detailed information about how a specific
SELECT statement will be processed by the database. The plan data gives a lot
of information and is a great tool for improving select statement performance. This screenshot show the plan data in a multi-column list.
The explain plan feature is supported for Oracle, DB2 for LUW, SQL Server and Mimer SQL.
Explain Plan as a Tree List

                  
The explain plan feature presents detailed information about how a specific
SELECT statement will be processed by the database. The plan data gives a lot
of information and is a great tool for improving select statement performance. This screenshot show the plan data as a tree.
The explain plan feature is supported for Oracle, DB2 for LUW, SQL Server and Mimer SQL.
Explain Plan as a Graph


SQL History

 

                  
Previously executed statements and scripts can be located and executed again
from the SQL History window.
SQL History window

                  
Filtering by meta data for each entry and in the full script content.
Filtering the SQL History


SQL Bookmarks

 

                  
The bookmark container in the Scripts tab. Double click a SQL entry to load it
in the SQL editor.
Bookmarks in the Scripts tab


Charts

 

                  
A result set presented in a line chart.
Result Set as Line Chart

                  
Result set as a stacked bar chart. Regular bar chart is also supported.
Result Set as Stacked Bar Chart

                  
The pie chart visualize a single serie (column).
Result Set as Pie

                  
Result set as a stacked area. Regular area chart is also supported.
Result Set as Stacked Area
 

                  
The configuration options for charts. Here you can define the appearance of the
chart, titles and labels for the series as they will appear in the legend.
Chart Configuration Options


Favorites

 

                  
Clicking an item in the Favorites toolbar opens the corresponding
Database Object node in the database browser or loads the Bookmark script in
the SQL Commander. The toolbar can be dragged and docked on the edges of the main window and
even on the same row as the main toolbar.
Favorites toolbar

                  
To add a database object as a favorite either drag the object to the wanted
position in the favorite toolbar or into the Favorites tab.
Drag Database Object to Favorites toolbar

                  
Add a bookmark script file by dragging to the wanted
position in the favorite toolbar or into the Favorites tab.
Drag Script to Favorites toolbar

                  
The Favorites tab is used to organize and open favorite objects. Use drag and
drop to move favorites to the wanted position.
Favorites Editor


Monitor

 

                  
The monitor tool is used to periodically execute select statements and present
the result in various formats. The chart format is really useful as it
in combination with the monitor feature, can present a number of live charts
based on real-time data.
The Monitor Tool


Result Set Management

 

                  
Here are two columns, "Type (DB)" and "Size" sorted in ascending order.
To sort one column, just click the column header. One click will sort the
column in ascending order. Click again and it will be sorted in the reverse
order,
and a third click will reset to the original ordering. To sort the grid based on more than one column,
keep the Ctrl key (Command on Mac OS X) pressed while clicking the
column headers.
<br>
The screenshot also shows filtering of the "Name" column. All matches in the grid
are highlighted with yellow color.
Grid with multi-column sorting and filtering

                  
The right click menu lists all actions that may be performed on the
grid and its data. Note that some actions are context sensitive and may
be disabled.
Grid right-click menu choices

                  
The "Browse Row in Window" action shows the selected row in a separate window.
The data is presented in a form with the leftmost column in the original
grid being presented at the top.
<br>
The form window is also a grid with the same capabilities as the grid component.
Row Form Window

                  
Sometimes it is convenient to select some data and show various statistics
such as telling max, min, avg, sum, etc. The right-click menu choice
"Aggregate Data for Selection" is used for this.
Aggregation Data for Selection
 

                  
The export functionality is used to export the content of any grid to
a file. The output can be written in CSV, HTML, SQL, XML, MS Excel
format. Data formats can be specified and test data can be generated
with the builtin data generators. The export functionality can also be
used in the SQL Commander, which is very useful when exporting large
result sets directly to file without first presenting them in DbVisualizer.
The Export feature


Compare

 

                  
In the SQL Commander, you can compare the script to its copy on disk, to a script
loaded in another SQL Commander, or to the content of the system clipboard.
Compare SQL Editors

                  
You can also compare any grid in an SQL Commander or Object View tab, such as a
Result Set grid, the Data tab grid for a table, or the Tables grid for a schema,
to any other open grid.
Compare Grid Data


Configurable

 

                  
The key binding support in DbVisualizer is extensive as it supports
setting key bindings for lots of operations. There are pre-defined key maps
specifically for Windows, Linux/UNIX and Mac OS X users. This is really
important for key bindings such as those used for editing since these key strokes
are different in each OS. In addition there
are key maps for users coming from other database tools such as TOAD and SQL Server's Query Analyzer.
Key Bindings

                  
Control the individual coloring for the syntax highlighting in the SQL editor.
SQL Editor Colors

                  
There are many settings used to control the appearance and behavior of
DbVisualizer. Two great feature is the Color & Border for a database
connection. These are used to highlight certain components that use the
database connection.
Color and Border

                  
The grid colors can be defined so that every second row is presented
in an alternate color.
Grid Colors
 

                  
The permission feature simply controls every
action and SQL that are about to be executed. The permission is set per
individual SQL statements executed in the SQL Commander, such as DELETE, DROP,
UPDATE, etc. The response can be any of "Allow", "Ask" or "Deny".
Permissions are also available when editing in the table data editor. Permissions
can be defined for Insert, Update or Delete operations. The response for each
command is any of "Confirm" or "No Confirm". Permissions are grouped based
on the connection modes, "Development", "Test" and "Production".
Permission Control


Auto-update

 

                  
The check for update feature periodically check if there is any new version available.
Check for Update

                  
If the check for update feature have detected a new version the auto-updater can
be used to download and install the new version all without leaving DbVisualizer.
Auto-updating


Command Line Interface

 

               
Using the command line interface, you can connect to a database and execute a single SQL statement or a script, with various options.
Command Line options

Who Uses DbVisualizer

 

Customer Testimonial:
Like a SAP technical consultant sometimes I need a simple database tool for different databases of our customers. DbVisualizer is an excellent solution and its free !
Jiri Ehrlich
More...