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.
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.
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.
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.
Insert long, unformatted SQL queries into the MySQL editor and automatically get it formatted for easy editing.
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.
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.
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.
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.
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.
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.
DbVisualizer is a G2 Leader among database management software.
MySQL is an open-source relational database management system.
To connect to and manage your MySQL database you use a MySQL client.
To navigate and manage your MySQL database for example insert, delete and update tables.
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..
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.
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.
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.
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.
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.
DbVisualizer has extended support for MySQL object types and functions, you can see the full list of supported object types here.
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.
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.
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.