The MySQL client with the happiest users
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.
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.
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.
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.
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
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.
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.
Users love using DbVisualizer
with MySQL
-
Edward MDirector 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 LDirector 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 MDirector 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 LDirector 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]()
Great feedback from great users.
DbVisualizer is a G2 Leader among database management software.
Frequently asked questions
-
What is MySQL?
MySQL is an open-source relational database management system.
-
What is a MySQL database viewer?
To connect to and manage your MySQL database you use a MySQL client.
-
What is MySQL database viewer used for?
To navigate and manage your MySQL database for example insert, delete and update tables.
-
How do I connect to MySQL with DbVisualizer?
DbVisualizer has a driver manager built in that you can use to connect to MySQL. You can read more on how to connect securely in this article..
-
How can I use DbVisualizer as a query tool?
DbVIsualizer has a visual query builder, that automatically generates SQL code as you drag and drop tables and select values to include. DbVisualizer also allows you to write SQL queries, highlighting of operations and autocomplete suggestions is done in a clever way.
-
How do I get started to use MySQL with DbVisualizer?
Download DbVisualizer, and connect to your MySQL database. Try the Pro version for 21 days or buy the Pro version to get the full function set. You can also use the client for free with limited functionality.
-
What are the benefits of using MySQL?
MySQL is a reliable, secure and robust database with a huge user base. It is one of the most favourable transactional databases on the market.
-
Can I connect to MySQL and other databases using DbVisualizer as a MySQL client?
Yes you can! DbVisualizer can connect to many different data sources to navigate and manage data. Many businesses has several different databases and with DbVisualizer you get one tool to manage all (on this list) data sources.
-
How can I connect to my database using the MySQL JDBC driver?
This is easy handled with the built in driver manager in DbVisualizer. You select MySQL from the list of available data sources you want to connect to, enter the credentials and DbVisualizer automatically sets up the connection.
-
What object types are supported in the DbVisualizer MySQL client?
DbVisualizer has extended support for MySQL object types and functions, you can see the full list of supported object types here.
-
What are some of the features of the MySQL GUI in DbVisualizer?
In DbVisualizer you can put multiple SQL editors next to each other for quick comparisons, re-arrange tabs, work with variables, save scripts, get help with the Auto-complete feature and a lot more. DbVisualizer is built to make your life easier and you can easily customize the layout and functions to match your workflow.
-
What is the difference between a MySQL client, a MySQL GUI, a MySQL IDE, a MySQL editor and a MySQL workbench?
Those different environment labels in which you work with your database does mean more or less the same thing. While a client indicates that you have a server elsewhere, the GUI refers to the graphical interface of the application. IDE refers to the larger "integrated development environment" and the editor refers to in actual part of the client in which you write your code. A workbench focuses more on the process of development itself. However, all of these have come to be synonym in how people refer to the application in which you do the actual coding.
-
Is there a database browser in DbVisualizer?
Yes! For each database you can see the tables, relations and custom objects that have been created. There are automatic visualization tools for you to generate entity relationship diagrams (ERDs) or see the servers explain plan.