DbVisualizer Pro
DbVisualizer is the database client with the highest user satisfaction.
DbVisualizer is the database client with the highest user satisfaction.Developers, analysts, and DBAs use it to elevate their experience with modern tools to build, understand, manage and maintain databases. It helps you generate and optimize SQL queries, use variables in SQL statements, compare queries, generate ERDs, manage database-specific objects, edit table data like a spreadsheet, set up monitoring, use CLI, and so much more.It connects to all popular databases (e.g. MySQL, PostgreSQL, SQL Server, Oracle, Cassandra, Snowflake, SQLite, BigQuery, and 25+ more) and runs on all popular OSes (Windows, macOS, and Linux).With 6M downloads and Pro-users in 145 countries worldwide, it won't let you down. Free and Pro versions available.
Learn more here about DbVisualizer.
Introducing the most eye-catching update of DbVisualizer this year. Version 24.2 comes with a refined UI, extended support for Azure Synapse Analytics, more powerful exporting capabilities, and much more. Let’s break it down.
<REFINED GUI>
Updated UI
The UI has been refined to create a balanced work environment for the user in both dark and light mode. And it’s more than just an adjustment to colors - you’ll also see new icons, button placements, and an improved overall balance.
Darker darks and clearer lights
In this update, the dark theme has become darker, and the light is more balanced. There are also small improvements to margins around elements, line heights in lists, and more to create a well-balanced UI. You will also find a new setting for themes allowing DbVisualizer to match the dark or light setting of your OS automatically.
New scalable icons
To further increase compatibility across different screens and settings, DbVisualizer is now shipped with modern and scalable SVG icons. Together with the new colors in the UI, we also think they look stunning.
In an effort to enhance usability and free up space for what matters the most, we’ve adjusted the placements of some buttons. All while making sure to keep the organization of UI elements intact, so that you still feel familiar with the UI. Previously available on Windows and Linux, it is now possible to further optimize screen real estate by merging the main toolbar into the header of the application window on macOS.
<New database support>
Extended support for Azure Synapse Analytics
This release introduces extended support for dedicated and serverless SQL pools in Azure Synapse Analytics. DbVisualizer now includes support for database-scoped credentials, external file formats and data sources, external tables, and more. For more information, see DBVisualizer´s pages on Azure Synapse Dedicated and Azure Synapse Serverless.
<New object support>
Improved support for arrays
DbVisualizer is now more capable of understanding the content and structure of array objects. In addition to a new JSON-based syntax for presenting and editing arrays, the improved understanding of the array data types also enables new validation of user input before it’s sent to the database.
The new array support is currently available for PostgreSQL, Oracle and MySQL databases.
<Database-Specific improvements>
Improved database support
MariaDB, Oracle
A new navigation panel was added to the package body editor making it easier to navigate between procedures and functions in the package.
Cassandra
This release introduces support for the JDBC wrapper of the Java driver for Cassandra which is more powerful and future-proof than previous alternatives. To start using the new driver in existing connections, choose "Cassandra" in the Driver Type field. In addition, a number of Cassandra-related improvements were implemented such as support for overloaded functions, error marking in the procedure editor and more.
PostgreSQL
The support for PostgreSQL was extended to include role management (in addition to users and groups in legacy versions of the database). Additionally, this update allows you to specify the sequence name when working with auto-generated columns.
MySQL
It is now possible to create and update generated columns in the Create Table and Alter Table dialogs.
Redshift
The new release adds support for materialized views in Redshift.
Snowflake
In this update, support for additional table types in Snowflake has been added. This includes dynamic tables, event tables, hybrid tables and iceberg tables.
Greenplum
Integration with the Greenplum database has been extended to Greenplum 7 including adjustments for partitioned tables, generated columns, constraints, procedures, functions, aggregates and sequences.
Databricks
The new release adds basic database support for Databricks. You will find a pre-defined entry for Databricks in the driver manager, making it easy to get started.
<DATA EXPORT>
New options for data export
Support for MERGE statements
When exporting data in SQL format, it is now possible to generate merge statements instead of insert statements. Check the “Generate MERGE statements” option and select the desired merge statement type.
Trim text data
Support for text functions has been added to the grid export dialog. For now the available options are to keep the text as is, trim both ends, trim the right end or trim the left end. This setting affects all text columns that are exported.
Suggest file extensions automatically
When exporting data to a file, the correct filename extension is now applied automatically depending on the selected output format. If the format is changed, the export filename will be updated with a suitable extension. You can always change or remove the extension if so desired before proceeding with the export.
Syntax highlighting in the export preview
When previewing the export in SQL format, the generated code will now use syntax highlighting making it easier to read.
<CODE Editor>
Editor improvements
Advanced substitution in Find and Replace
Support for advanced substitution in Find and Replace has been extended. Now, the panel contains buttons to add newlines to the corresponding field and supports literals n and t, as well as L, U, E for lowercase and uppercase manipulation.
Smarter auto-completion
When auto-completing column names, they will now be automatically qualified when the column name alone is ambiguous.
Select next/previous statement
A quick action was added allowing to select the next/previous statement in the current script. This can be done using the keyboard shortcuts CTRL+ALT+UP and CTRL+ALT+DOWN.
Support for a list of choices in custom variables
For advanced scripting scenarios, it is now possible to define variables with a list of available values using the choices attribute.
<AND MORE>
And more improvements across the board
Uncommitted SQL statements
When warning about auto-commit being turned off, also show which statements are going to be committed as a result of the commit.
Special characters in text fields
Previously, it was possible to see and edit special characters such as newline and tab in text values using the cell editor but they were not visible in the data grid. In the new release, newlines and tabs in text fields are rendered as symbols in the data grid.
Images in the data grid
Values in binary columns can be displayed as images in the grid. Now, this support also includes SVG images.
Additionally, DbVisualizer now multi-threads image loading for binary columns, which means that the images in a data grid show up quicker, especially for data sets containing larger images.
Create persistent database connections using the command line
In addition to the familiar graphical UI, DbVisualizer comes with a command-line interface that can be used for various automation scenarios. With the new release, this support has been extended to include creation of persistent database connection using the command line.
Updated user guide
Since the previous release, the updated user guide with a massive overhaul to improve usability. It received a major design update, and includes a much more powerful search function as well as an easy-to-use version selector. If you haven’t already, go in and take a look.
And that’s not all…
There are a total of 50 improvements and fixes that you can read about in the latest release notes from DBVisualizer.
________________
CODE EDITOR
SQL Editor rebuilt from the ground up
This new version includes many improvements, both big and small, all aimed at giving you a great environment to work in making it more user-friendly and efficient.
Find and Replace
Redesign of the Find and Replace functions for efficiency and ease of use:
- seamlessly switch between searching and replacing text
- choose to match by case or whole words
- utilize regular expressions for complex searches
- easily navigate between matches.
All of this is accessible through a straightforward, inline panel
Auto-complete
The new SQL editor features a newly developed auto-completion engine designed to be smarter and more accurate than before.
- handles complex queries better
- understands the difference in context between the inner and the outer parts of the query
The default shortcut to trigger the auto-complete feature in the editor is CTRL + SPACE.
WORKSPACES
Switch between multiple contexts using workspaces
The new release includes support for workspaces, a feature that allows you to switch effortlessly between different work contexts. Each workspace operates independently, complete with its own connections, drivers, scripts, and settings. This functionality makes it easy to manage distinct environments, projects, or client engagements. You have the flexibility to tailor each workspace to suit your specific requirements.
Workspaces can be created and opened through the File -> Workspaces menu.
DATABASE CONNECTIONS
Create a connection from a database URL
An additional method to create database connections simplifies the setup process. Now, you can begin by entering your database URL, and DbVisualizer will automatically choose the matching drivers for you.
MASTER PASSWORD UPDATE
Streamlined handling of the master password
If security is a priority for you, you're likely already familiar with the master password feature. In this new release, the master password experience is refined to make it more intuitive and less obtrusive. This enhancement allows you to maintain robust security without compromising on ease of use.
PERFORMANCE
Performance and stability fixes
Improved database read performance
Better response times and less load on the database by reducing the need for roundtrips and are handling paging in a smarter way for BigQuery, SingleStore, Vertica, and Oracle databases.
Additional syntaxes for multi-row inserts
Added support for additional syntaxes for multi-row inserts that can be generated when exporting table data. Using multi-row inserts is essential to the performance when importing large data sets. This release extends the support for the default SQL-92 syntax to also include syntaxes specific to Oracle and Cassandra, as well as the generic union-based syntax.
Smarter memory management
Memory used by scripts and result sets is released faster, making DbVisualizer more efficient when processing large result sets and working with complex scripts.
DATABASE SPECIFIC IMPROVEMENTS
Improved database support
Oracle
The Grant Privilege action has been added for materialized views, functions, and procedures in Oracle databases. With this addition, you can give privileges to database users to perform operations on the corresponding database object. To give privileges to several objects at once, select them in the database objects tree first.
Microsoft SQL Server
In the new release, default constraints are displayed alongside primary key, foreign key, unique and check constraints in the database objects tree for SQL Server. This allows for a more comprehensive view and easier navigation of the database schema.
SingleStore
Now, DbVisualizer includes the capability to display the DDL for pipelines in SingleStore. This allows users to view the underlying SQL statements that define the structure and configuration of pipelines in their database.
Vertica
Support for procedures in Vertica has been improved. Now it is possible to create stored procedures as well as external procedures in the GUI, and more information about existing procedures is shown both in the Procedures view and in the database objects tree.
AND MORE
Additional improvements across the board
Navigation in the row form editor
Added navigation buttons to the row form editor in DbVisualizer makes it easier to move between rows within a full result set, while staying within the familiar interface of the row form editor. This enhancement streamlines the process of reviewing and editing data, providing a more seamless and efficient user experience.
Adjust window sizes to the selected application font
As you adjust the font size within the application, the windows will automatically resize to match, ensuring a consistent and optimal viewing experience. This feature not only improves readability but also provides a more comfortable and adaptable user interface, catering to various screen sizes and user preferences.
Security updates
DBVisualizer continues to strengthen its security infrastructure by upgrading to the latest version of the Java platform and updating third-party dependencies. This approach to maintaining up-to-date software components is a key part of DbVisualizers´ commitment to providing a secure environment for our users.
Key Features
Powerful SQL editor
Modern SQL coding. With the help of intelligent autocomplete, visual query builders, variables and much more, we are able to let users spend less time on mundane coding tasks, and more time on actual problem solving..
Universal database management
Works with all your databases. You’ll be able to connect to most popular data sources and work with their custom object types directly in the client. You’ll also find tools for database visualization and optimization, helping you work smarter and faster.
Simple data management
Harness the power of SQL with the simplicity of a spreadsheet. With simple query tools, inline data editing, and powerful exports you have everything you need to manage your data with less queries and with full control.
Configurable to fit your workflow
Make it yours. You can fully control window layouts, key bindings, UI theme, mark scripts, and database objects as favorite for quick access or even work outside of DbVisualizer with the command-line interface. You are in full control.
Security built in
DbVisualizer is built to meet rigorous security standards. Set up encryption for all data that goes to and from the application, set user permissions to avoid alteration of sensitive data, and enforce strong local passwords. All configurable directly in DbVisualizer.
CONTACT
Pascal Carmohn
✉️ [email protected]
📞 +49 (0) 89 2314142 11