Tailored to your workflow
Your personal workspace
Working with tabs
Your work will be organized in tabs which make you able to jump between tasks with ease. Tabs can be re-arranged, dragged into unique windows, compared with each other, and much more. Create your preferred layout and DbVisualizer will remember it every time you start the application.
Organizing your scripts
Scripts are used to save and sort your queries. It allows for a full folder structure in which you are in full control. Maybe you want to have a folder per project or per database. Maybe you want to group scripts that you are currently working on and have a separate folder for the queries that are done and implemented in a live environment. You are in full control.
Favorite objects
Right next to the scripts tab you will find the favorites tab. Simply drag any object or script to the favorites area so have quick access wherever you find yourself in the tool.
Key bindings
Speed up your workflow with custom key bindings. Browse or search for the command you use the most, and create a keyboard shortcut for it, for quick access.
Work in a dark or light environment that looks the same in any OS
Command line
Client-side commands
Client-side commands are used to control the execution of scripts and run for example export and import functionality without needing to interact with the DbVisualizer UI. The commands even allow you to send emails with result sets directly from DbVisualizer. Client-side commands are also supported in the command-line interface for DbVisualizer.
@import
Instead of using the GUI to import data, you can use client-side commands to import data from xlsx, xml, json, csv or txt files.
@export
Instead of viewing and exporting query results from result set grids, you can export the result of one or more queries to a file from a script. For very large results, this may be the preferred choice due to memory constraints.
The @mail command sends emails with attachment support, useful when using @export and then to mail the result of a query.
Work in the terminal
Command-line interface
With DbVisualizer you can execute commands directly in the terminal. By calling the dbviscmd command you can set up connections, run SQL scripts, use client-side commands, and much more.
Command-line generator
To easily generate the full command-line for DbVisualizer, use the command-line generator which will do the tedious work for you.
Monitoring
Run queries continously to track live progress
In DbVisualizer you can create monitors, which will repeatedly query the database in set intervals and can display the incremental data from the result.