MySQL client

The MySQL client with the happiest users

Tested for {{ curDB.name }} version {{ curDB.versions }}
MySQL client
MySQL client
DbVisualizer has a long history of being a top-performing MySQL editor.
MySQL G2 badge
MySQL client

The feature-packed MySQL client

It includes everything you need to develop, connect and manage your MySQL database. It supports MySQL-specific object types and everything else that makes MySQL great.

Support for MySQL's specific object types

Object types

There are multiple object types supported by MySQL. Some are more common, like Schemas and Tables. Other object types are however less common, such as Events, TableEngines and Privileges. In DbVisualizer, you’ll easily find and manage all objects in your database, just as intended by the designers of MySQL.

Object type actions

Every object type is meant to be used in a certain way. As a powerful MySQL client, DbVisualizer supports the execution of unique actions for the object types in MySQL. Actions can be triggered via simple SQL queries or even by right-clicking on the object and selecting the preferred action.

Learn more about what object types are supported for MySQL.

MySQL object types

An SQL editor helping you get the most out of MySQL

Auto-complete

Writing SQL for MySQL has nuances not found with other databases. DbVisualizer understands these differences and provides relevant suggestions, letting you create better SQL queries more efficiently.

SQL formatting

Insert long, unformatted SQL queries into the MySQL editor and automatically get it formatted for easy editing.

Variables

Some queries are meant to be run several times, maybe only changing small details. Client-side variables for MySQL can be used to prompt the user to insert only these specific values, removing the need for any edits to the query itself. A true time saver.

Learn more about the supported features for MySQL.

MySQL autocomplete

Visualize relationships and dependencies automatically

Generate Entity Relationship Diagrams (ERDs)

The relationships between objects in MySQL are crucial to understand. With automatically generated ERDs you’ll be able to see all dependencies and opportunities directly in the MySQL client.

ERD MySQL
See the ERD feature
MySQL ERD illustration

Explain plans

Extract the explain plan for your query to see how the database handles the request. It will allow you to explore ways to optimize the query so that it is efficiently executed by the server.

MySQL ERD illustration
MySQL scheduling

Scheduling with MySQL Events

DbVisualizer supports the use of MySQL Events for scheduling of tasks.

Jobs can also be scheduled outside of the MySQL client, using the command-line interface and the pre-built scheduling tools of your OS.

Try DbVisualizer Pro

Start your free 21 day evaluation of DbVisualizer Pro
Maven MySQL driver

MySQL JDBC driver management

DbVisualizer has the latest JDBC driver for MySQL built right in, and even older versions. With the JDBC driver manager you’ll easily connect to your databases using JDBC drivers hosted on Maven, with multiple versions to choose from.

Maven MySQL driver
MySQL driver manager

Properties specific to the MySQL client

Configure the MySQL client to work as you want directly in the properties pane. Make sure that the user needs to enter a User-ID and password to access the IDE. Enable preprocessing of scripts. You can even set up auto-commit and much more.

MySQL properties

Users love using DbVisualizer
with MySQL

  • Edward M
    Director of Software Development & Integration

    I have been using this product for over 5 years. I searched for a long time, tried many other products but once I found DbVisualizer my search was over. This is my go to product for dealing with our MySQL instances which host our data warehouse. It has everything I need and it is simple to use.
    Verified MySQL user.
    Review from Capterra.
    capterra review
  • Dan H

    I am administering MySQL and SQL Server databases in multiple environments (development, staging, and production). The ability to connect to multiple database types, multiple database connections per database, it's flexibility and ease of use, and access to all database components in an intuitive manner. When support is required, which is seldom, quick and meaningful responses are received.
    Verified MySQL user.
    Review from G2.
    g2 review
  • James T

    If you're looking for a mature, feature-rich, agnostic database client, you should definitely consider DbVisualizer.
    Verified MySQL user.
    Review from G2.
    g2 review
  • Michael L
    Director of Managed Services

    We've used this tool for over 20 years. There are other options. That should say it all.
    Verified MySQL user.
    Review from G2.
    g2 review
  • Edward M
    Director of Software Development & Integration

    I have been using this product for over 5 years. I searched for a long time, tried many other products but once I found DbVisualizer my search was over. This is my go to product for dealing with our MySQL instances which host our data warehouse. It has everything I need and it is simple to use.
    Verified MySQL user.
    Review from Capterra.
    capterra review
  • Dan H

    I am administering MySQL and SQL Server databases in multiple environments (development, staging, and production). The ability to connect to multiple database types, multiple database connections per database, it's flexibility and ease of use, and access to all database components in an intuitive manner. When support is required, which is seldom, quick and meaningful responses are received.
    Verified MySQL user.
    Review from G2.
    g2 review
  • James T

    If you're looking for a mature, feature-rich, agnostic database client, you should definitely consider DbVisualizer.
    Verified MySQL user.
    Review from G2.
    g2 review
  • Michael L
    Director of Managed Services

    We've used this tool for over 20 years. There are other options. That should say it all.
    Verified MySQL user.
    Review from G2.
    g2 review
/* g2 reviews */

Great feedback from great users.

DbVisualizer is a G2 Leader among database management software.

Frequently asked questions