Database management
Access your database
Support for the most popular databases
DbVisualizer enables you to access your data from nearly any data source. Most have full support built right in, but even if the data source is not listed below you can most likely connect to it as long as you have a JDBC driver. Find your preferred data source below.
JDBC driver management via Maven
DbVisualizer has JDBC driver management built right in. It connects you to your databases using JDBC drivers hosted on Maven, web servers, local files, and even supports different versions of each JDBC driver.
Explore and visualize
Automatic generation of reference graphs and ERDs
In most databases, the relations between tables and data are crucial to understand. DbVisualizer will help you automatically generate visual ERDs so that you can better understand dependencies and opportunities. Visually navigate the objects in the database, run actions, and open objects for more details.
Support for database-specific object types
Each data source supports different object types. There are object types commonly found in several databases, like schemas and tables. Other object types are unique. In DbVisualizer, you’ll easily find and manage the specific objects in your specific database.
Support for database-specific object type actions
Each object type has a unique purpose and supported actions. DbVisualizer supports the unique actions of the different object types. You can write custom SQL to perform the actions, or simply right-click on the object and select the preferred action.
Optimize database performance
Explain plans
DbVisualizer can present a visual explain plan from the database to help guide you in writing more efficient queries. It allows you to analyze how a query will be processed by the database, for instance, whether an index can be used to fetch the data or if a full table scan is required, which is far less efficient.
Export Database objects
Export the DDL for objects such as tables, table data, views, procedures, functions, triggers, packages, and package bodies. This allows you to easily re-create any of the key objects in your database.
Database scheduling, events, jobs
Jobs can be automatically scheduled using the command-line interface for DbVisualizer and the native scheduling tools in the OS.
In addition, DbVisualizer supports “Oracle Scheduler”, “SQL Server Agent”, “PostgreSQL pgAgent”, “MariaDB Events” and “MySQL Events”.
