dbForge Studio

dbForge Studio is a Windows application for MySQL database administration. All necessary tools for working with tables and queries to them are built in. You can change the structure, integrate new elements, extract information and much more. A scheduler is built in to create backups on a specified schedule.

Creating a database

After launching the application, you need to set up a new connection, local and remote databases are supported. To design the structure, you can use a convenient tool for generating schemas. Relationships between tables can be displayed separately. This makes it much easier to create complex databases with a large set of linked tables.

Administration

With the help of the built-in wizard you can create queries for extracting a sample with the required parameters. It is possible to add users and customize access rights. A separate module allows you to flexibly customize the schedule for creating backups. The interface allows you to administer several servers in parallel. The service management service is used for this purpose. The SQL query editor provides all the necessary options. There are automatic error checking, syntax highlighting, hints and a number of other features. Such queries provide all necessary operations - structure editing, data retrieval, data modification and so on. There is a built-in report generator and a module for analyzing tables.

Features

• the application allows you to create, customize and administer databases;
• function for generating detailed reports;
• SQL query editor;
• adding users and changing access rights;
• built-in scheduler for backups;
• trial version is available for free.