These include improvements in connections and driver management, extended SQL permissions, improved database support, as well as performance and compatibility fixes. While we continue to work on larger features for future releases, we are excited to offer these important updates to our users.

CONNECTIONS AND DRIVERS

Connections and driver management.

A number of improvements have been made to how DbVisualizer handles database connections and drivers.

Shared driver artifacts

Driver artifacts are now shared between driver definitions to allow reuse, save disk space and improve maintainability.

Improved import

Exporting database connections now exports the corresponding user drivers. A user driver will be created automatically when importing a connection previously exported without the driver.

Maven repositories

In Tool Properties, a server availability indicator is now available in the list of Maven repositories.

DATABASE-SPECIFIC IMPROVEMENTS

Improved database support.

PostgreSQL and Greenplum

Foreign servers are now displayed per database in the objects tree with the corresponding foreign tables as sub-nodes. DbVisualizer also generates DDL for foreign tables.

Snowflake

New data views for database, warehouse, server info and user parameters.

AND MORE

Other improvements

Detection of missing WHERE clause

DbVisualizer now detects DELETE and UPDATE statements with a missing WHERE clause and warns the user. This behaviour is controlled in Tool Properties > Permissions.

Support for multiple displays

Adjust windows to visible screen area when screen setup changes.

Performance

The performance of the database objects tree has been improved by optimising the auto-detection of database type.

Each feature has been thoughtfully crafted to solve real world problems.

DbVisualizer has everything you need to build, manage and maintain state-of-the-art database technologies.

Powerful SQL editor

Simple 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.

Database management

Extensive support for most popular data sources

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 visualization and optimization, helping you work smarter and faster.

Data management

The power of SQL with the simplicity
of a spreadsheet

With simple data visualizations, query tools, inline data editing, and powerful exports you have everything you need to manage your data with ease and with full control.

Workflow

Configure DbVisualizer to how you want to work

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

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.

Connect to your favorite set of databases

DbVisualizer connects to all popular databases with support for database-specific object types and more.

Oracle

Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing.

MySQL

MySQL is an Oracle-backed open source relational database management system (RDBMS) very popular with web applications and online publishing.

PostgreSQL

PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.

Microsoft SQL Server

Microsoft SQL Server is a industry standard relational database management system (RDBMS) used in a wide variety of BI and analytics applications.

ClickHouse

ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries.

SQLite

SQLite implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.

MongoDB

MongoDB is a cross-platform document-oriented and NoSQL database.

Cassandra

Apache Cassandra is an open source NoSQL distributed database trusted by thousands of companies for scalability and high availability.

Google BigQuery

BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service (PaaS) that supports querying using ANSI SQL.

Microsoft Access

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools.

Oracle Cloud

Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing.

Azure SQL Database

Azure SQL Database is a SQL Server database engine, based on the latest stable Enterprise Edition of SQL Server and fully managed by Azure.

Db2

Db2, or Database 2, is a set of relational database products built and offered by IBM to store, analyze and retrieve data with maximum performance.

Derby

Apache Derby is a rdbms developed by the Apache Software Foundation focusing on easy installation and usage with a minimal disk-space footprint.

Elasticsearch

Elasticsearch is the world’s leading free and open search and analytics solution with an emphasis on speed and scalability.

Exasol

Exasol is a high-performance, in-memory, MPP database specifically designed for analytics of large data sets in real time.

Greenplum

Greenplum Database (GPDB) is an advanced, fully featured, open source data warehouse, based on PostgreSQL.

H2 is a open source rdbms that can be embedded in Java applications or run in client-server mode.

IBM Db2 on Cloud

IBM Db2 on Cloud is a fully managed SQL cloud database with point-in-time recovery and high-availability disaster recovery (HADR).

Informix

IBM Informix is an embeddable, high-performance database for integrating SQL, NoSQL, JSON, time-series and spatial data that's designed for analytics int the cloud.

MariaDB

MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL.

Mimer SQL

Mimer SQL is a high performance database engine, targeted at mission-critical client/server environments while offering scaleable performance on multiple plattforms.

MySQL Cloud

MySQL is an Oracle-backed open source relational database management system (RDBMS) very popular with web applications and online publishing.

Netezza

IBM Netezza is a powerful and highly parallelized Data Warehousing system that is simple to administer and to maintain.

NuoDB

NuoDB is an SQL-oriented transactional database management system (DBMS) designed for distributed deployment in the cloud.

Presto

Presto is a distributed query engine for big data using the SQL query language.

Redshift

Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.

SAP ASE

SAP ASE is a relational model database server developed by Sybase Corporation.

Snowflake

The Snowflake Cloud Data Platform includes a pure cloud, SQL data warehouse.

Trino

Trino is an ANSI SQL compliant query engine, that works with a wide variety of BI tools.

Vertica

Vertica is a columnar data storage platform designed to handle large volumes of data, which enables very fast query performance in traditionally intensive scenarios.

Yellowbrick

Yellowbrick Data Warehouse is an advanced, massively parallel processing (MPP) SQL database designed for batch, real-time, ad hoc, and mixed workloads.

Hive

Apache Hive is a distributed, fault-tolerant data warehouse system that enables analytics at a massive scale.

Solr

Solr is a fast, open source enterprise search platform built on Apache Lucene™

Salesforce.com

The Salesforce Database is powered by Oracle. There are a number of languages that are used for the Salesforce Database including SQL.

Firebird

Firebird is an open-source SQL relational database management system that runs on Linux, Microsoft Windows, macOS and several Unix platforms.

Teradata

Teradata is a Relational Database Management System (RDBMS) suitable for large data warehousing applications.

CrateDB

CrateDB is a open-source distributed SQL database management system that integrates a fully searchable document-oriented data store.

HSQLDB

HSQLDB (HyperSQL DataBase) is a SQL relational database system written in Java. It offers a small, fast multithreaded and transactional database.

InterSystems IRIS

Iris is an object-oriented database management system being developed at Hewlett-Packard Laboratories.

MaxDB

MaxDB is a heavy-duty, SAP-certified open source database that offers high availability, scalability and a comprehensive feature set.

SingleStore

SingleStore (formerly MemSQL) is a cloud-native database designed for data-intensive applications. A distributed, relational, SQL database management system (RDBMS) that features ANSI SQL support.

Actian X (Ingres)

Actian X is a combination of Ingres transactional and Vector analytic databases, integration and a monitoring tool.

CData Software JDBC Drivers

Easy-to-use JDBC Drivers with powerful Enterprise-level features. Connect JDBC with Salesforce, NetSuite, SharePoint, Secure File Transfer, and more.

DataDirect's Autonomous REST Connector

Progress DataDirect Autonomous REST Connector is an intelligent, customizable data connectivity solution enabling build and deploy of data connectors without coding.

FrontBase

FrontBase is a relational database management system written in ANSI C to be scalable and fast.

HPE NonStop SQL

NonStop SQL is a relational database management system designed for fault tolerance and scalability, offered by HP.

IBM Db2 iSeries

IBM Db2 is a family of data management products, including the Db2 relational database.

IBM Db2 z/OS

IBM Db2 for z/OS is a relational database management system that runs on the mainframe.

IBM IMS

IBM IMS is a hierarchical database management software system for online transaction processing (OLTP) and online batch processing.

JDBC Drivers for CSV, XML, dBase, MS Access

JDBC driver from Sesame Software for connecting to CSV, XML, dBase and MS Access.

Pervasive

Pervasive PSQL is a relational database developed by Pervasive Software mostly used as embedded database.

Progress

Progress OpenEdge RDBMS supports modern, mission-critical, business applications developed using the OpenEdge application development platform.

SAP IQ (Sybase IQ)

SAP IQ is a column-based, petabyte scale, relational database software system used for BI, data warehousing, and data marts. Replaced by Yellowbrick.

SAP SQL Anywhere (Sybase SQL Anywhere)

Users

DbVisualizer is used by database professionals all around the world.

6 million downloads

DbVisualizer has been downloaded over 6 million times.

150 countries

DbVisualizer has Pro users in 150 countries around the world.

Customers

The world’s most innovative companies use DbVisualizer

Quick Navigation;