DbVisualizer is one of the world’s most popular database editors.
Developers, analysts, and DBAs use it to elevate their SQL experience with modern tools to visualize and manage their databases, schemas, objects, and table data, and to auto-generate, write and optimize queries. And so much more.
It connects to all popular databases (e.g. MySQL, PostgreSQL, SQL Server, Oracle, Cassandra, Snowflake, SQLite, BigQuery, and 20+ more) and runs on all popular OSes (Windows, macOS, and Linux).
With almost 6 million downloads and Pro-users in 145 countries around the world, it won’t let you down. Free and Pro versions available.
What's new in 14.0?
- Support for four new data sources: Cassandra, SingleStore, Google BigQue, Microsoft Access
- Refreshed SSH tunnel setup
- Export fixed column result sets
- Images in binary data types can now be rendered in grids
- Copy your filtered and sorted Table Data view as a SELECT statement
- Auto reconnect in the SQL Commander
Here you can find all improvements
Database Browser
The databases tab is one of the features in DbVisualizer that is used the most. Use it to navigate the objects in the database, run actions and open objects for more details. The object types and hierarchy that is presented are database specific and depends on the database type setting at connect. The list may be filtered to show only objects of interest. More Infos
Database Object Management
Database Object Management is all about browsing the database objects and administering objects such as tables, procedures, functions, triggers, packages, modules, etc. Check the database specific support section for an exact reference what objects and actions are supported for your database.
Table Data Management
Table Data Management is about handling the data in a table such as editing, importing, exporting, etc.
SQL Tools
The SQL Tools in DbVisualizer is centered around the SQL Commander, with its SQL Editor and Query Builder. Additional features are the Scripts, SQL History, Explain Plan and support to display result sets as stunning graphs.
Database Server Management
Database Server Management is about controlling and administering the database server. This includes areas such as instance, session storage and security management. Every database server is different and so is the support for managing the DB server in DbVisualizer. Check out the database specific support section to see what features are provided for your databases.
Comprehensive Database & OS Support
DbVisualizer is tested with the major databases and JDBC drivers. For databases more commonly used in the industry we have added support for database specific features. Some of these features are:
- Management of database specific objects
- Visual actions for CREATE, ALTER, DROP, RENAME and so on
- Create, Edit and Compile procedures, functions and triggers
- Explain plan support
- Schema Export
- Compare of editors and result sets
- ...and much more
Here you can find supported databases and JDBC drivers.
Databases with extended support in DbVisualizer
- Azure SQL Database
- Cassandra
- Db2
- Derby
- Elasticsearch
- Exasol
- Google BigQuery
- Greenplum
- H2
- IBM Db2 on Cloud
- Informix
- MariaDB
- Microsoft Access
- Microsoft SQL Server
- Mimer SQL
- MongoDB
- MySQL
- MySQL Cloud
- Netezza
- NuoDB
- Oracle
- Oracle Cloud
- PostgreSQL
- Presto
- Redshift
- SAP ASE
- SQLite
- SingleStore
- Snowflake
- Trino
- Vertica
- Yellowbrick
System requirements
The minimum system requirements to run DbVisualizer
- Java 17
- 2GB RAM (minimum)
- 300MB disk space
Supported OSes
The operating systems on which you can run DbVisualizer
- Windows
- macOS
- Linux
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.