dbForge Studio for MySQL

GUI for MySQL / MariaDB managing, developing, administrating

Posted Embed

dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database development, management, and administration. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface.

Reviews
Discussion
MakersThere are no makers yet
You need to become a Contributor to join the discussion.
Alena Subotina
Alena Subotina@alena_subotina
The best MySQL/MariaDB GUI ever! dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database administration, development, and management. The IDE 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 delivers data and schema comparison and synchronization tools, database reporting tools, backup options with scheduling, and much more. Key features: *Broad Compatibility Options -All MySQL server versions -All MariaDB server versions -Percona PAM Authentication for MySQL -Sphinx Search Engine *Intelligent SQL Coding Intelligent code completion, formatting, MySQL prompt, and code snippets bring convenience and effectiveness to your SQL code writing. Code navigation, obtaining quick object information, and syntax check are performed instantly. *Database Compare and Sync -Compare and sync data and schemas -Schedule regular database sync tasks -Generate comparison report *Visual Query Builder Visual query creation with diagram and expression editor. Queries of any complexity can be created in several seconds. The GUI tool automatically adds joins between tables and allows working with INSERT, UPDATE, DELETE statements. *Database Designer -Viewing foreign key relations -Displaying DB objects with properties -Execution of stored routines *Import/Export Data Fill MySQL databases with external data using our export and import tools. They support more than 10 popular data formats and allow customizing the whole process. Templates, automating data import and data export tasks through command line are also available. *Database Backup -Dump databases in SQL format and schedule regular MySQL database backups. -Use 5 levels of file compression and wide set of options to fine-tune backups. -Save settings and connections as a project for the next time or to use in the command line. *Database Administration -Managing user privileges -MySQL service control -Managing server variables -Table maintenance -Managing server sessions *MySQL Debugger The first debugger for MySQL that offers step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism to automate debugging of MySQL stored routines and triggers and keeps MySQL server's logic of procedure execution. *Table Designer Visual designer for modifying or creating table structure and indexes. Get full control over the changes you have made, the heuristics feature will suggest the column type on creating a column basing on the name you enter. *Database Refactoring -Renaming database objects with preview -Refactoring script *Query Profiler -Offers visual query profiling -Compares profiling results *Report and Analysis -Data reporting is performed using wizard with rich feature set, manually, or via command line. Ready reports can be imported to 9 formats and delivered to their recipients. -Group and summarize your data in pivot tables to make it easier to read and understand. More features are available at https://www.devart.com/dbforge/m...