dbForge Studio for MySQL

You are viewing an old version of this article. View the current version here.

Attachment 'dbForge-Studio-for-MySQL' not found dbForge Studio for MySQL is a universal front-end for MySQL and MariaDB database administration, development, and management.

The MySQL GUI tool allows to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface. The MySQL client provides utilities to compare schema and data and synchronize them, includes also database reporting tools, backup options with scheduling, and much more.

Key features:

1. Compatibility with all MySQL and MariaDB server versions, Percona PAM Authentication for MySQL, and Sphinx Search Engine.

2. Intelligent SQL Coding

  • MySQL prompt
  • MySQL code completion
  • Automatic SQL syntax check
  • MySQL syntax highlighting

3. Database Compare and Sync

  • Quick MySQL schema and data comparison with synchronization tools
  • Display of MySQL database diffs, grouping, filtering
  • Several synchronization ways to choose from

4. Database Designer

  • Visual query builder for MySQL
  • Visual design and editing
  • Viewing foreign key relations between tables
  • Clear display of database objects and their properties on a database diagram

5. Query Profiler

  • Visual query profiling
  • Comparing profiling results
  • MySQL performance tuning

6. Data Import/Export

  • MySQL import and export wizard supporting up to 12 popular formats Data import from 8 popular formats into MySQL table Multitude of options to customize data import and export

7. Database Backup

8. Database Administration

  • Managing user privileges
  • MySQL service control
  • Managing server variables and server sessions
  • Table maintenance

9. MySQL Debugger with step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism

10. Database Refactoring

11. Report and Analysis.

Learn more about dbForge Studio for MySQL at the product page

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.