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

Customers

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.
Check some case studies and user testimonials.

Supported Databases

Amazon Redshift
Azure SQL Database
Db2
Derby
Elasticsearch
Exasol
Greenplum
H2
IBM Db2 on Cloud
Informix
Microsoft SQL Server
MariaDB
Mimer SQL
MongoDB
MySQL
MySQL Cloud
Netezza
NuoDB
Oracle
Oracle Cloud
PostgreSQL
Presto
SAP ASE
Snowflake
SQLite
Trino
Vertica
Yellowbrick
Cassandra
SingleStore
BigQuery
MS Access

Supported OSes

• Windows
• Mac OS X
• Linux
• UNIX

Requirements

• Java 8
• 512MB RAM for Java
• 80MB disk space
• JDBC driver (some are delivered with DbVisualizer)

Key Features

Multi-database and cross-platform Database Management Tool

• Work with multiple database brands and perform many development and administration tasks from a single tool
• Easily explore your databases
• Automatic graphs of primary/foreign-key constraints

Visually create and manage the database

• Construct and manage database objects with ease
• Multiple object action executions
• Create, Compile and Run functions and procedures
• Object scripting
• Visually compare table and result set data
• Powerful data editing

Write and execute SQL scripts

• SQL IDE with syntax highlighting
• Auto completion
• Parameterized SQL execution
• Chart any result set in nice diagrams
• Tune your queries with integrated explain plans
• Query builder using drag and drop, no manual SQL required
• Visually compare SQL scripts

Data and database transfer

• Export table data in CSV, SQL, HTML, XML,Excel, JSON, Text
• Export all objects in the database including table data or all objects for a specific type
• Import table data from CSV files into existing table or create table from import data

General productivity

• Tasks are executed in background allowing for parallel operations
• Auto save of the workspace
• Resume where you left off with editors preserved between sessions
• Flexible workspace based on a tabbed interface supporting customized layout that is saved between sessions
• Tag DB objects and SQL script files as favorites for instant loads

Delivery

Electronic download only (no shipping costs): http://www.dbvis.com/download/

End User License Agreement (EULA)

http://www.dbvis.com/doc/main/doc/license.html