關於 dbForge Studio for MySQL

使用 MySQL 資料庫的管理工具和開發環境。

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. The MySQL client delivers data and schema comparison and synchronization tools, database reporting tools, backup options with scheduling, and much more.

dbForge Studio for MySQL Features

  • 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
  • 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 - 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
  • 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.
  • 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
  • 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 - 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
  • 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 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
  • 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
  • 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
  • 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.
  • 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.
  • 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

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
  • Support for SSL/SSH/HTTP connections
  • 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)

  • 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