About dbForge Studio for MySQL

Administration tool and development environment for working with MySQL databases.

dbForge Studio for MySQL is a tool designed to automate and simplify work with MySQL. dbForge Studio for MySQL provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways. dbForge Studio for MySQL offers full support of MySQL and advanced features like Quick code navigation, Automatic SQL syntax check and Customizable SQL formatting.

dbForge Studio for MySQL Key Features

  • Database Designer - a state-of-the-art visual database design tool
  • Database projects for offline database development
  • Advanced stored routine debugger
  • Schema comparison and synchronization tool
  • Data comparison and synchronization tool
  • Context-sensitive code completion
  • Quick code navigation
  • Automatic SQL syntax check
  • Customizable SQL formatting
  • Handy schema object editors
  • Visual Query Builder
  • Integrated Security Manager
  • Server maintenance toolkit
  • Schema export and import wizards
  • SQL templates library
  • Schema object search engine
  • Multiformat data export
  • Full support of MySQL versions 3.23-6.0
  • Direct access to a server

dbForge Studio for MySQL Benefits

With dbForge Studio for MySQL you will get a clear solution for many puzzling tasks, while administrating, developing, and maintaining MySQL databases.

  •  Visual Database Designer - Design the whole database visually with a visual database design tool - Database Designer.  Database Designer allows you to view and edit databases in a convenient visual way. You can observe all objects of the database, see foreign key relations between tables, view database objects information, easily access database objects for editing, retrieving data, executing stored routines.
  • Offline Development with Database Projects - Enhance your work with complex database projects. Instead of doing lots of time-consuming tasks, perfect your management with well-tried features. You can integrate various SQL and script files into a project, group them into folders, and manage in one place. Build your project to a single script file or several ones and easily deploy on the server. Feel difference. Read how to work with projects.
  • Stored Routine Debugger - Replace “by hand” debugging with a full-featured debugger tool. Debug stored procedures, functions, and triggers with no worry. You can easily set breakpoints to stop execution on any code line and evaluate variables and parameters declared in routines.
  • Schema and Data Comparison and Synchronization Tools - Just select two databases (or a database and a project) to compare. Based on your needs, you can compare and synchronize the structures of databases (schema comparison) or the content of databases (data comparison). Manage differences in a convenient window and simply select the required synchronization actions.
  • Powerful SQL Management - Free yourself from tedious work, while coding, with well-thought features. Speed up your development with code templates, code completion, syntax check, code formatter, and many other options. Make your work simple and pleasant. Learn how to effectively manage SQL scripts.
  • Visual Query Builder - Create effortlessly complex queries which you could not create before.  Do not think about coding, just use Query Builder. Drag’n’drop required tables to the diagram, select parameters, set conditions in a convenient editor, and then view and edit a query text. Find out more about Query Builder features.
  • Convenient Schema Object Editors - Manage efficiently shema objects in visual editors. Get clear and automated ways to work with tables, views, procedures, functions, triggers, events, and user-defined functions (UDF). Take advantage of a quick search and navigation.
  • Centralized Server Administration and Maintenance - Have centralized server maintenance with powerful tools. Use Security Manager to have simple and accurate management of users and their privileges. Get total control of user sessions and their information with Session Manager. Benefit from MySQL services empowered with Service Control window. Transform difficult tasks into your new opportunities. See how to use Security Manager.
  • Multiformat Data Export - Experience visual and accurate data export to well-known formats. You will quickly choose required columns and rows along with additional settings for the selected format. With Data export wizard you can customize and even preview the result. You won’t waste your time changing the exported data, the result will be just what you wanted.
  • Intuitive and Highly Customizable UI - Tune layout based on your convenience and work on-the-fly.  GUI elements are well-located and easy-to-use. Tabbed documents, dockable tool windows, and other customizable elements will give you a quick navigation and full control.

Standard includes tools for database administrators and developers, such as a debugger, Query Builder, code templates, object search, various export and maintenance wizards.

Professional additionally includes accurate comparing and synchronizing the structures of databases (schema comparison) or the content of databases (data comparison), debugging stored procedures and scripts, creating complex queries, etc

Standard Features

  • Multiple database connections in Database Explorer window
  • Support of SSL/SSH/HTTP connections
  • Work with MySQL embedded server
  • Database Designer
  • Visual editors for all MySQL schema objects
  • Partitioning support for table editor
  • Summary window for quick browsing of schema object properties
  • Customizable DDL generation wizard
  • Schema object and data searching on a live database
  • SQL editor with syntax coloring, bookmarks, and text searching
  • Code templates library with the browser window
  • Context-sensitive code completion
  • Parameter information for stored routines
  • Quick information about schema objects
  • One step access to a schema object editor from code (go to definition)
  • Dynamic help on MySQL accessible from the editor
  • Execution of scripts, selected SQL fragments, and statements
  • Execution plan tool
  • Data editor with in-place filtering, grouping, and sorting options
  • Data export wizard
  • Visual Query Builder with support of sub-queries
  • Stored routine and script debugging framework
  • Security Manager to administer user accounts and privileges
  • Schema export and import wizards
  • Table maintenance wizard and flush dialog
  • Session manager
  • Service control for starting and stopping MySQL servers
  • Server Variables window
  • Rich user settings
  • Full shortcut customization
  • Wizards for exporting/importing user settings

Professional Features (All Standard features plus the following)

  • Schema comparison and synchronization tool
  • Data comparison and synchronization tool
  • Database project framework
  • Support of code refactoring
  • Automatic SQL syntax check
  • SQL formatting

Commercial License is for professional use of the product by one person for making any kind of profit. Registered users can access dbForge Studio from more than one PC but not at the same time.

Non-Commercial License is for use of the product by non-profit organizations like charities and other social-oriented organizations, all kinds of educational institutions, and individuals who use the product for non-commercial purposes only (education, entertainment, etc). Registered users can access dbForge Studio from more than one PC but not at the same time.