dbForge Studio for MySQL Feature List

Devart's MySQL GUI tool provides a number of instruments for database management and administration. In this page you will find a comprehensive listing of features available in dbForge Studio for MySQL. For a list of new features see What's New in 6.2.

Table of Contents

  1. MySQL Connectivity
  2. Administration and Maintenance
  3. Data Analysis
  4. Data Comparison and Sync
  5. Data Editor
  6. Database Backup
  7. Database Explorer
  8. Database Refactoring
  9. Debugger
  10. MariaDB specific features
  11. Exporting and Importing Data
  12. Flat Table Editor
  13. Object Editors
  14. Database Projects
  15. Query Builder
  16. Query Profiler
  17. Schema Comparison
  18. SQL Editing and Execution
  19. Visual Database Designer
  20. User Interface

MySQL Connectivity

MySQL Connectivity

  • Support of Sphinx and Percona
  • Support of all MySQL server versions 3.23-5.x
  • Support of MariaDB
  • Secure connections via SSL/SSH
  • HTTP connections via PHP tunnel
  • Support of UTF-8 databases
  • Work with MySQL embedded server
  • Direct access to MySQL server without client libraries
  • Support of MySQL pluggable authentication when creating connection to MySQL server (PAM)
  • Support of Windows authentication when creating connection to MySQL server
  • Working with MySQL on Amazon RDS

Administration and Maintenance

Administration and Maintenance

  • Comprehensive Security Manager to administer user accounts and privileges
  • Session manager for monitoring active MySQL server connections
  • Service control for starting and stopping MySQL servers
  • Table maintenance wizard for check, analysis, repair, and optimization of tables
  • Server Variables window
  • Server objects flush dialog

Data Analysis

Data Analysis

  • Master-detail data browser
  • Data report generation wizard
  • Data report designer
  • Pivot table designer
  • Chart building wizard
  • Data search on a live database
  • Automatic data report generation and delivery to the requested destination

Database Synchronization

Data Comparison and Sync

  • Comparing and synchronizing data in databases of any size
  • Optional view comparison
  • Custom comparison keys support
  • Option for BLOB data comparison
  • Comparison results filtering
  • Data synchronization script generation
  • Per record viewing of data differences
  • Exclude tables and records from synchronization
  • Saving and loading of comparison settings
  • Command line interface for data comparison and synchronization
  • Generating accurate comparison reports in HTML and Excel formats
  • Comparison of custom query results (along with tables and views)
  • Possibility to include objects into comparison by mask, which is useful when comparing groups of tables

Data Editor

Data Editor

  • Asynchronous data fetch with ability to cancel the operation
  • Batch table update mode when changes are accumulated and applied explicitly
  • Copying data with column headers for quick paste to spreadsheet
  • Custom data filters of any complexity
  • Data Viewer window for browsing images, rtf, and binary cell values
  • Date time editor with visual interface
  • Foreign key lookup editor for easy editing of fields referencing other tables
  • Free copying of any block of data to clipboard
  • Full-text search (Ctrl+F) through data grid
  • Graphical card view
  • Grouping by arbitrary columns
  • Incremental search (Ctrl+I) through data grid
  • Large objects (LOB) editor
  • Multi-table query result set editing
  • Paginal data browsing for large result sets
  • Printing of data
  • Quick filter feature available for each data cell
  • Record numbering option
  • Read-only state indication
  • Report, chart, and pivot building directly from data editor
  • Server-side sorting and filtering to help dealing with large data sets
  • Visible columns picking dialog box
  • Editing microseconds in columns with the TIME, DATETIME and TIMESTAMP data types

Database Backup

Database Backup

  • Comprehensive MySQL backup and restore wizards
  • Schema or data only backups in addition to full backups
  • Large database (exceeding 2 Gb) support
  • Backup projects to save settings for future use
  • Zip compression for backup files
  • Command line support for scheduling backup tasks
  • Error and status logging

Database Explorer

Database Explorer

  • Multiple database connections allowed
  • Asynchronous connect to server with ability to cancel the operation
  • Detailed object properties and data browsing in Object Viewer window
  • Dependency tree browsing for each object
  • Duplicate object feature
  • Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc
  • Customizable DDL generation via wizard
  • 'Send To' command for quick sending of tables to Query Builder, Data Report, and other tools
  • Smart column renaming that allows rebuilding dependent tables
  • Quick access to object privileges (GRANT) from the popup menu
  • Multi-selection for batch operations on objects
  • Database navigation history

Database Refactoring

Database Refactoring

  • Renaming of tables, columns, views, procedures, and functions
  • Preview of changes in the database with possibility to cancel them selectively
  • Possibility to generate refactoring script of a database without changing it
  • Refactoring feature can be accessed from Database Explorer and object editors
  • Possibility to rename several columns from object editor
  • If an error in processing dependencies is encountered, a user can fix it manually

T-SQL Debugger

Debugger

  • Stored procedure and function debugging
  • Trigger debugging
  • Script debugging
  • Step Into, Step Over, and Step Out commands for step-by-step execution
  • Breakpoints support for procedures, functions, triggers, and scripts
  • Breakpoints window
  • Call Stack window with navigation
  • Watches window for variable evaluation
  • Evaluation of session variables when debugging a script
  • Single-click debug engine deployment

T-SQL Debugger

MariaDB specific features

  • SELECT (LIMIT ROWS EXAMINED) extended syntax
  • INSTALL SONAME statement supported
  • SHOW EXPLAIN syntax
  • Multi-source replication syntax
  • Dynamic Columns syntax for DML statements
  • New KILL syntax
  • Expanded CREATE TABLE or ALTER TABLE syntax
  • Aria storage Engine supported
  • Virtual columns supported
  • Microseconds supported
  • Pluggable Authentication supported

Data Export and Import

Exporting and Importing Data

  • Data export to:
    • CSV
    • XML
    • Text
    • XLS
    • PDF
    • DBF
    • HTML
    • RTF
    • MDB (Access)
    • ODBC
    • SQL
  • Export data from multiple tables at once
  • Export data from command line interface
  • Data import from:
    • CSV
    • XML
    • Text
    • XLS
    • XLSX
    • DBF (Foxpro, dBase III, dBase IV, dBase 7)
    • MDB (Access)
    • ODBC
  • Import data from command line interface
  • Templates for exporting and importing

Table Designer

Flat Table Editor

  • Visual editor for tables
  • Convenient editor for foreign keys
  • Partitioning support
  • Editable column grid: columns can be added and edited without opening the popup dialog
  • Full-text search on the column grid
  • Schema changes can be viewed before updating database
  • Heuristics helps define data type of new columns

Object Editor

Object Editors

  • Visual editors for columns, indexes, and views
  • Visual editors for triggers, events, and user-defined functions
  • Combined editors for stored procedures and functions
  • Ability to browse schema objects in a single editor (pin document)
  • Schema object search based on a variety of parameters

Database Projects

Database Projects


Query Builder

Query Builder

  • The state-of-art diagram with zooming and keyboard support
  • Preview and printing of the diagram
  • Visual addition of sub-queries to any part of the main query
  • Query outline (displayed in Document Outline window)
  • Visual editing of sub-queries
  • Expression builder for creating complex conditions
  • Copy/Paste for tables on the diagram
  • Undo/Redo support
  • Saving queries to a file
  • Support of visual building of INSERT, UPDATE, and DELETE statements
  • Conversion of SELECT queries into INSERT statements
  • One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition

Query Profiler

Query Profiler

  • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI
  • Plan of the query displayed in the tree view for easy review
  • Profiling history that can be saved for further analysis
  • Compare profiling results feature with differences highlight
  • Profiling results printing

Database Synchronization

Schema Comparison


SQL Editing and Execution

SQL Editing and Execution


Database Design

Visual Database Designer

  • Visualization of tables, views, and stored routines
  • Easy access to database objects for viewing their properties, editing, retrieving data,
    executing stored routines, etc.
  • Support for IDEF1X and IE notations
  • Customizable diagram look and feel with skin support
  • Smart diagram layout
  • Diagram export to different image formats
  • Searching database objects on diagram
  • Organizing diagram shapes with containers
  • Customizable diagram printing with a rich set of options
  • Optional displaying of table constraints, indexes, and triggers
  • Integration with Document Outline window
  • Diagram navigation with Diagram Overview window
  • Notes for adding your comments to the diagram

User Interface

User Interface

  • Start page providing easy access to main product features
  • Rich user settings
  • UI skins
  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Syntax highlight customization
  • Tabbed groups for documents
  • Toolbars customization
  • Ability to browse schema objects in a single editor (pin document option)
  • Wizard for exporting/importing user settings


  • MySQL GUI Tools - MariaDB and MySQL Front End Client
  • Code Completion - dbForge Studio for MySQL
  • Database Administration - dbForge Studio for MySQL
  • Data Management - dbForge Studio for MySQL
  • Refactoring - dbForge Studio for MySQL