Supported OS'es
Runs on Windows, macOS, and Linux/UNIX
Configurable key bindings with pre-defined key maps
Look & Feels for Windows, macOS, Linux/UNIX
HiDPi images on Mac Retina displays
GUI and Archive installers with option to install Java
The DbVisualizer UI
Rearranging Tabs using drag&drop
Maximize Tabs with double-click
Detach tab in separate Window
Pin tabs
Tile/Collapse all tabs in a tab group
Specify default naming scheme for tabs
Rename individual tabs
Save layout of Object View tabs between DbVisualizer sessions
Connection Management
Dynamic JDBC driver management (no CLASSPATH editing)
JDBC drivers included with DbVisualizer:
- DB2 for LUW
- Derby
- Exasol
- H2
- Mimer SQL
- MySQL
- NuoDB
- PostgreSQL
- Oracle
- Redshift
- SQLite
- SQL Server
- Sybase SQL Anywhere
- Sybase ASE
- Vertica
SSH support with known_hosts and private key support
Step-by-step connection setup with a wizard
Connection Keep-Alive
Optionally use a single physical connection for all operations
Organize database connections in folders
Set individual tab background color and borders for each
connection
Parameterized connection data
Supports multiple simultaneous open database connections
Connect a single or multiple connections with a single click
Export and Import connections and general user settings
Basic password Security
Strong master password Security
Show passwords in plain text if using master password Security
Database Browser
A tree structure to browse and manage database objects
Multi-object support for open, connect, drop, etc
View basic information for
tables, indexes, primary keys, privileges,
schemas, databases, procedures and a lot
more
Type-to-find objects by name
Database objects filtering
Hide database objects
Sort database connections and folders
Search database objects
Show only default database/schema
Organize database connections and folders with drag&drop
Script multiple database objects using drag&drop
Table
Create and Alter table
Define Referential Integrity Constraints
Rename Table
Drop Table
Empty Table
Create Index
Table DDL viewer
Procedure, Function, Package and Trigger
Create Procedure, Function, Package, Trigger
Edit Procedure, Function, Package, Trigger
Execute Procedure, Function
Export Schema/Database
Export Formats
CSV, HTML, SQL, XML, XLS, XLSX, JSON
Export object DDLs
Export Table Data
Custom Data Format Settings
Support for BLOB, CLOB and binary data
References Graphs
Graph or list of referential integry rules
Several automatic graph layout managers
Link table nodes by foreign keys
Link table nodes by all columns in a foreign key
Bridge link support to improve readability
Graph zooming, fit, animation and navigator pane
Show Table details
Script Tables as SQL by SELECT, INSERT, CREATE, etc.
Export and print
Save/Load manual layouts
Database Scheduling, Events, Jobs
Manage jobs and scheduling in "Oracle Scheduler"
Manage jobs and scheduling in "SQL Server Agent"
Manage jobs and scheduling in "PostgreSQL pgAgent"
Manage jobs and scheduling in "MySQL Events"
Table Data Viewer/Editor
Table data editing in grid (spreadsheet) editor
Table data editing in form editor
Auto-complete column names while specifying inline filter
Table filters saved between sessions
Copy/Paste with external spreadsheet tools such as Excel
Quick filtering in grids
Display references to other tables
Monitor row count differences
Support for BLOB, CLOB and binary data
View BMP, TIFF, PNG, GIF and JPEG images
View PDF documents
View XML data in tree or text format
Table Export
Export Formats
CSV, HTML, SQL, XML, XLS, XLSX, JSON
Export CREATE DDL for SQL format
Export INDEX DDL for SQL format
Custom Data Format Settings
Support for BLOB, CLOB and binary data
Table Data Import
Import table data from CSV or Excel files
Support for BLOB, CLOB and binary data
Support multi-character column separator
Automatic data type detection
Automatic mapping of file columns to table columns
Create table from imported data
Save settings between sessions
Data Navigator
Expose foreign keys by data selection
Limit referenced data with filters
Tag support
Edit table data directly in Navigator
SQL Commander
Execute Script with multiple SQL statements
Execute single SQL statement at cursor position
Execute selected SQL statement(s)
Execute Buffer (as a single SQL statement)
Execute Explain Plan
Syntax colored SQL editor
Auto Completion (aka code completion, intellisense)
Predefined and user defined editor templates
Support for multiple SQL editors
Support for procedures producing multiple result sets
SQL formatter with extensive customization options
Execution control (stop on error/warning)
View result sets as grid, text or chart
Editable result sets with the inline or form editors
Support for BLOB, CLOB and binary data
View BMP, TIFF, PNG, GIF and JPEG images
View PDF documents
View XML data in tree or text format
Export result sets with Create Table option
CSV, HTML, XLS, XLSX, XML, SQL
Export large result sets directly to file (@export)
Parameterized SQL queries
Supports objects dragged from the Database Browser
Drop files from Desktop or external tools
SQL execution logging with filtering options
Pre-defined editing key maps
Merge Result Sets in Text Format
Error highlighting in editor
Result Set Management
Auto resize columns, manual column resizing
Double click column divider to sort column
Re-arrange columns by drag and drop
Multi colum sort by clicking column header
Copy column name
Copy selection
Quick filter with range options
Quick filter highlights matched cells
Aggregation Data for Selection
Find cell data and column name
Compare Cells
Manual or Automatic Merge of Result Sets in Text Format
Export grid data
CSV, HTML, XLS, XLSX, XML, SQL, TEXT, JSON
Query Builder
Design queries with a few mouse clicks
No SQL expertise is required
Adapts the generated SQL for the actual database
Reverse engineer a SELECT statement
Auto Join of columns by primary/foreign key or name
Explain Plan
Browse plan data in graph format
Browse plan data in tree format
Browse plan data in text format
Coloring based on node cost (tree and graph format)
SQL History
SQL History
Limit number of history entries to save
Filter by full script content
SQL Bookmarks
Organize bookmarks in a folder structure
Save bookmark as favorite for fast access
Charts
Supports Line, Area, Bar, Point, Pie, Stacked Area,
Stacked Bar
Modify serie label without need to use column aliases in
select
Set chart, X-axis and Y-axis titles
Pre defined color schemes
Optional legend at top, bottom, left or right
Zooming, Export, Print
Export
Print
Copy chart image to system clipboard
Favorites
Display database object details with a single-click
Load bookmark scripts in current or new editor
Organize favorites with drag and drop
Monitor
Instant Monitor of results from SQL
Automatic monitoring of any result set
Single view of result sets from multiple databases
View data in grid, text or professional charts
Print and export monitored data
Compare
Compare editor buffers
Compare grid contents
Compare individual grid cells
Configurable
Define your own key bindings
Pre-defined key bindings for TOAD and SQL Server Analyzer
Set unique properties per database connection
Permissions checks what commands need confirmation
Customize the format of Date, Time and Numbers
Set fonts
And a lot more...
Security
Basic Security
Strong master password Security
Configurable master password Pattern
Strong password protection of exported user settings
Show database connection passwords in clear text
Export/Import User Settings
Export Tool Properties
Export JDBC Drivers
Export Master Password encrypted passwords
Auto-update
Check for Update
Auto-updating to new versions
Task Management and Memory Monitoring
Central Task Manager
Memory Monitor warns about high memory usage
Command Line Interface
DbVisualizer command line interface