dbForge Studio for MySQL Features

• 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.
• Source Control - This is an integrated feature that was designed to simplify and streamline database version control, providing you with support for all popular version control systems, including Azure DevOps Server (previously known as Team Foundation Server), Apache Subversion (SVN), TFVC, Git (including GitHub, GitLab, and Bitbucket), Mercurial (Hg), Perforce (P4), and SourceGear Vault.
• Database Compare and Sync - When modifying MySQL database structure, transferring data between servers, analyzing differences between databases, you will:
  • Compare and sync data and schemas
  • Schedule regular database sync tasks
  • Generate comparison report
• 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.
• Copy Database - Transfer MySQL Server databases from one server instance to another with a handy Copy Databases tool. The tool allows you to:
  • Customize copying settings
  • Copy databases together with data
  • Drop a database if it already exists on a target server
• Database Migration - dbForge Studio for MySQL provides several ways to migrate databases either within the same instance or between different instances, including the following:
  • Copy databases
  • Backup and restore databases
  • Import and export data to multiple formats
• Database Designer - Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your MySQL databases and for:
  • Viewing foreign key relations
  • Displaying DB objects with properties
  • Execution of stored routines
• Data Generator - Populate your MySQL tables with thousands of rows of realistic test data. Data Generator supports all MySQL data types, includes a large number of meaningful generators with customizable settings, and allows generating data via the command-line interface.
• Query Profiler - Improve multi-second queries using Query Profiler. The tool helps you detect problems and optimize SQL queries via GUI. Profiler:
  • Offers visual query profiling
  • Compares profiling results
• 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.
• 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, indexes, primary keys, defaults, and CHECK constraints. Get full control over the changes you have made. The heuristics feature will suggest a column type on creating a column based on the name you enter.
• Database Refactoring - Improve MySQL database design by applying small changes. When such changes are performed, they are fully transparent and application takes care of all dependencies in the database:
  • Renaming database objects with preview
  • Refactoring script
• 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 your settings and connections as a project for the next time or to use in the command line.
• Database Administration - Tools for MySQL database administration and management include means for:
  • Managing user privileges
  • MySQL service control
  • Managing server variables
  • Table maintenance
  • Managing server sessions
• Database Projects - The Database Project is a collection of SQL scripts and query files which allows you to logically organize them in one place and in an offline mode. With this technology you can compare a database project with a database, by receiving a synchronized script, and deploy database changes.
• 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.
• Documenter - A tool for generation of MySQL and MariaDB database documentation. Documenter allows you to:
  • Retrieve an overview of the database structure
  • View inter-object and inter-database dependencies
  • Customize documentation with style templates
  • Generate documentation files in the HTML, PDF and Markdown formats
• Broad Compatibility Options - dbForge Studio for MySQL is compatible with:
  • All MySQL server versions
  • All MariaDB server versions
  • Percona PAM Authentication for MySQL
  • Sphinx Search Engine
  • And more

Standard Features

• SQL editor with syntax highlighting, bookmarks, and text search
• Visual Query Builder with support of SELECT statement
• Visual Query Builder with support of INSERT, UPDATE, and DELETE statements
• Visual Query Builder with support of sub-queries
• Quick INSERT statements generation from data grid without opening wizard
• MySQL stored procedure debugger
• Query Profiler
• Execution plan tool
• Execution of scripts, selected SQL fragments, and statements
• Executed Queries History
• Code Snippets
• Context-sensitive code completion
• Phrase completion
• Support for SQL refactoring
• Quick information about schema objects
• Parameter information for stored routines
• SQL code formatting
• One-step access to a schema object editor from code (go to definition)
• Database Designer
• View Database Object Dependencies
• Visual routine editors
• Flat table editor with heuristics support
• Object Viewer window for quick browsing of schema object properties
• Schema object search on a live database
• Security Manager to administer user accounts and privileges
• Session manager
• Server Variables window
• Service control for starting and stopping MySQL servers
• Table maintenance wizard and flush dialog
• Database backup and restore wizards
• Data Export to 14+ file formats
• Data Import from 10+ file formats
• Enhanced visual data editor
• Data search on a live database
• Master-Detail Browser
• Support for MySQL
• Support for MariaDB
• Support for Sphinx and Percona
• MySQL pluggable authentication and Windows authentication on connecting to MySQL server
• Percona PAM Authentication for MySQL
• Working with MySQL on Amazon RDS and on Amazon Aurora
• Working with Google Cloud
• Working with Alibaba Cloud
• Working with Tencent Cloud
• Working with Azure for MySQL
• Working with Azure for MariaDB
• Working with MySQL embedded server
• Working with Galera Cluster
• Multiple database connections in Database Explorer window
• Connection coloring and document categories
• Full shortcut customization
• Rich user settings
• Wizards for exporting/importing user settings

Professional Features (All Standard features plus the following)

• Formatting code through the command line
• Automatic SQL syntax check
• Partitioning support for table editor
• Schema comparison and synchronization tool
• Command-line interface for schema comparison and synchronization
• Database Refactoring
• Database project framework
• CRUD generation
• Command-line interface for database backup and restore
• Command-line interface for data import/export
• Data comparison and synchronization tool
• Command-line interface for data comparison and synchronization
• Pivot tables
• Data reports
• Automated data report delivery
• Creating data reports through the command line

Enterprise Features (All Professional features plus the following)

• Source Control
• Execution warnings
• Find invalid objects
• Comparison of script folder objects and data
• Copy Databases
• Data Generator with 200+ predefined meaningful data generators
• Generation of Database Documentation in HTML, PDF, Markdown file formats