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

  • Sphinx Search Engine
  • Percona Server
  • MySQL server, versions 3.23-5.x
  • MariaDB
  • Secure SSL/SSH connections
  • HTTP connections via PHP tunnel
  • UTF-8 databases
  • MySQL embedded server
  • Direct access to MySQL server without client libraries
  • Pluggable authentication (PAM)
  • Windows authentication
  • Amazon RDS

Administration and Maintenance

Administration and Maintenance

  • Comprehensive Security Manager for user accounts and privileges administration
  • Session Manager for monitoring active MySQL server connections
  • Service Control for starting and stopping MySQL servers
  • Table Maintenance wizard
  • Server Variables window
  • Flush dialog box

Data Analysis

Data Analysis

  • Master-detail browser
  • Data report wizard
  • Data report designer
  • Pivot table designer
  • Chart designer
  • Data search within a live database
  • Automatic report generation and delivery

Database Synchronization

Data Comparison and Sync

  • Comparing and synchronizing data in databases of any size
  • Compairng data in tables, views, materialized views and custom queries
  • Support of custom comparison keys
  • BLOB data comparison
  • Filtering of comparison results
  • Generation of data synchronization scripts
  • Revision of data differences
  • Option to exclude tables and records from synchronization
  • Option to save and load comparison settings
  • Command line interface for data comparison and synchronization
  • Generation of accurate comparison reports in HTML and Excel formats
  • Option to include objects into comparison by mask

Data Editor

Data Editor

  • Asynchronous data fetch with the option to cancel the operation
  • Batch table update when changes are accumulated and applied explicitly
  • Copying data with column headers for a quick paste to spreadsheet
  • Custom data filters of any complexity
  • Data Viewer window for browsing images, rtf, and binary cell values
  • Date time visual editor
  • Foreign key lookup editor for easy editing of the fields referencing other tables
  • 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
  • Editing of multi-table query results
  • Paginal data browsing for large result sets
  • Data printing
  • Quick filtering is available for each data cell
  • Row numbering
  • Read-only state indication
  • Generation of reports, charts, and pivot tables directly from data editor
  • Server-side sorting and filtering to improve large data sets manipulation
  • Visible Columns 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
  • Support of large (exceeding 2 Gb) databases
  • Backup projects for saving settings for the future use
  • Zip compression for backup files
  • Command line interface for backup scheduling
  • Error and status logging

Database Explorer

Database Explorer

  • Support of multiple database connections
  • Asynchronous connection to server with the option to cancel the operation
  • Detailed object properties and data browsing in the Object Viewer window
  • Dependency tree browsing for each object
  • Object duplication
  • Quick generation of template scripts for selected object: SELECT, INSERT, EXECUTE, etc.
  • Customizable DDL generation wih the help of wizard
  • 'Send To' command for quick sending of tables to Query Builder, Data Report, and other tools
  • Smart column renaming that allows to rebuild dependent tables
  • Quick access to object privileges (GRANT) from the shortcut menu
  • Selection of multiple objects for batch operations
  • Database navigation history

Database Refactoring

Database Refactoring

  • Renaming of tables, columns, views, procedures, and functions
  • Preview of database changes with the option to cancel the operation
  • Generation of refactoring script without applying changes
  • Access to refactoring from Database Explorer and from object editors
  • Option to rename several columns from the object editor
  • Option to fix errors related to processing dependencies manually

T-SQL Debugger

Debugger

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

T-SQL Debugger

MariaDB specific features

  • SELECT (LIMIT ROWS EXAMINED) extended syntax
  • INSTALL SONAME statement support
  • 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 support
  • Virtual columns support
  • Microseconds support
  • Pluggable Authentication support

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 export and import operations

Table Designer

Flat Table Editor

  • Visual table editor
  • Convenient foreign key editor
  • Partitioning support
  • Editable column grid: columns can be added and edited without opening the shorcut dialog
  • Full-text search within a column grid
  • Schema changes display before updating a 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
  • Browsing 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 tool with zooming and keyboard support
  • Diagram preview and printing
  • Visual addition of sub-queries to any part of a main query
  • Query outline (displayed in Document Outline window)
  • Visual editing of sub-queries
  • Expression builder for creation of complex conditions
  • Copy/Paste for tables on a diagram
  • Undo/Redo support
  • Saving queries to a file
  • Visual building of INSERT, UPDATE, and DELETE statements
  • Conversion of SELECT queries into INSERT statements
  • One-click conversion of a SELECT query into an UPDATE or DELETE query with retaining of the WHERE condition

Query Profiler

Query Profiler

  • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI
  • Query plan is displayed in tree view for easy review
  • Profiling history can be saved for further analysis
  • Profiling results comparison with highlighted differences
  • 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 design with skin support
  • Smart diagram layout
  • Diagram export to different image formats
  • Objects search on a diagram
  • Organizing diagram shapes with containers
  • Customizable diagram printing with a rich set of options
  • Optional display of table constraints, indexes, and triggers
  • Integration with Document Outline window
  • Diagram Overview window for diagram navigation
  • Option to add comments to a diagram

User Interface

User Interface

  • Start page with the 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
  • Option to browse schema objects within a single editor (pin document option)
  • Wizard for user settings export/import


  • 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