dbForge Data Generator for MySQL Revision History

2026.1.77 25-Jun-2026

User-reported bug fixes

Resolved clipboard data corruption when copying HTML data with duplicate column names
Fixed an issue that caused a parsing error in stored procedures

2026.1.39 15-May-2026

User-reported bug fixes

Several minor bugs are fixed

2026.1.31 11-May-2026

AI Assistant

Improved AI Assistant by adding support for database index metadata

Text Editor

Added the Enclose identifiers in quotes feature to the SQL Editor
Added index name suggestions in code completion
Added indexed column icons in Quick Info
Added the ability to pin document tabs

Improvements

Added the ability to restore document tab order
Enabled data generation for columns with unsupported data types

User-reported bug fixes

Fixed the behavior of the "SQL Look In" option in the Find and Replace control
Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data
Fixed an issue in the Procedure Editor when editing procedures with invalid syntax
Added parsing support for the sys_refcursor pseudo-type
Improved saving of window layouts and restoration of window positions after restarting the Studio
Updated the installation wizard to not display the "Successful Install" page during dbForge product updates

2025.3.149 25-Mar-26

User-reported bug fixes

Fixed an issue that caused long response times from MySQL and MariaDB servers when executing certain queries that referenced non-existent objects

2025.3.107 12-Feb-26

User-reported bug fixes

Several minor bugs are fixed

2025.3.93 29-Jan-26

User-reported bug fixes

Improved support for SET TRANSACTION syntax on MySQL and MariaDB servers for the Text Editor

2025.3.61 24-Dec-25

Connectivity

Added support for AWS RDS Proxy with caching_sha2_password authentication
Added support for MySQL 9.5
Added support for MariaDB 12.2

Text Editor Improvements

Added scroll bar annotations
Added an option to automatically surround selections
Added support for SHOW BINARY LOG STATUS
Added support for CREATE OR ALTER USER, SET PASSWORD, and CREATE ROLE
Added camelCase formatting for identifiers

User-reported bug fixes

Fixed an issue with connecting to MySQL servers over SSH
Fixed an issue with generating data using Python
Implemented a text preview for CLOB data types instead of an icon
Fixed an issue where floating-point values lost precision when copied to Excel

2025.2.138 20-Nov-25

User-reported bug fixes

Several minor bugs are fixed

2025.2.109 31-Oct-25

User-reported bug fixes

Resolved an issue with displaying the tooltip for a document bookmark, where the tooltip window overlapped the document bookmark

2025.2.91 23-Oct-25

User-reported bug fixes

Fixed an issue with text selection on double-click in SQL Document

2025.2.37 23-Sep-25

AI Assistant

Introduced automatic error submission from the Error List to AI chat for detailed explanations and suggested fixes
Added a Web Search option in the AI Assistant chat, allowing searches across Devart documentation, website, and blog

Connectivity

Added support for MySQL 9.4
Added support for MariaDB 12

Improvements

Improved encryption capabilities
Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
Introduced the ability to customize the position where new document tabs open
Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values

User-reported bug fixes

Added support for fractional values in precision (decimal data type); the fractional part is discarded, and values are now treated as integers
Added support for parsing the 'not_auto' secondary engine

2025.1.230 21-Aug-25

User-reported bug fixes

Fixed an issue that occurred when connecting to a MySQL server via SSH

2025.1.186 21-Jul-25

User-reported bug fixes

Fixed an issue with the Clear Filter functionality in server mode
Fixed an issue with the automatic display of Data Editor: when the Activate Data Editor after query execution option is enabled, Data Editor now opens automatically after a query runs, even if no data is returned

2025.1.134 23-Jun-25

User-reported bug fixes

Several minor user-reported bugs are fixed

2025.1.124 16-Jun-25

AI Assistant is added

Context-aware query generation
Conversion of natural language to SQL
Query optimization
SQL explanations
SQL troubleshooting
Error analysis and recommendations
AI chat
Integration with the dbForge tools

Improvements

Updated color palettes for the Light and Dark skins
Refined font rendering and the coloring of syntax errors
Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list

User-reported bug fixes

Several minor user-reported bugs are fixed

10.1.165 09-Apr-25

User-reported and internal bug fixes

Several user reported minor bugs are fixed

10.1.158 28-Mar-25

Improvements

Added connectivity support for MySQL 9.2
Added support for modern encryption, hashing, and key exchange algorithms for SSH connections

User-reported and internal bug fixes

Fixed a 'Commands out of sync' error in Data Editor

10.1.24 25-Sep-24

Improvements

Introduced connectivity support for MySQL 9.0
Added support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to MariaDB servers on Amazon Web Services (AWS)
Added support for HeatWave-specific commands in Code Completion and Syntax Check
Added connectivity support for Kamatera MySQL Cloud
Redesigned the Query History interface
Added the ability to copy data to the clipboard in the CSV format from Data Editor
Added the ability to copy data to the clipboard in the Excel-compatible format from Data Editor
Added the ability to append a timestamp to the file name

User-reported and internal bug fixes

Resolved an issue with data sorting in Data Editor
Several user reported minor bugs are fixed

10.0.225 28-Mar-24

User-reported and internal bug fixes

Fixed a MySQL server connection error that occurred when using the SSL Cipher List parameter
Fixed the issue that prevented table editing for queries involving JOIN operations in the Data Editor
Resolved an issue that occurred when attempting to open a connection to the server while editing script parameters in the SQL Document
Fixed the Lost connection to MySQL server during query error in the stored procedure editor
Fixed an issue with unnecessary quotation marks being added to values when copying data from the Data Editor
Fixed an issue related to computing the insertion position for elements from the Member List

10.0.150 17-Jan-24

Improvement

Added connectivity support for MariaDB 11.4

User-reported and internal bug fixes

Fixed an issue that occurred during the repeated execution of a query in SQL Document

10.0.60 20-Nov-23

User-reported and internal bug fixes

Fixed an issue with editing string values in the Data Editor
Resolved an application crash issue when attempting to save a script larger than 2 gigabytes
Resolved the problem with SQL Document freezing during query execution

10.0.46 03-Nov-23

New features

Added support for temporal tables in MariaDB
Extended support the INET6 data type, intended for the storage of IPv6 addresses

Connectivity

Introduced support for Transport Layer Security 1.3
Added support for MySQL v8.2

User-reported and internal bug fixes

Resolved an issue with invoking the popup menu on macOS
Improved data display for the JSON_OBJECT function
Resolved an issue that occurred when establishing an SSH connection to the server
Resolved an issue with updating data cells for TIMESTAMP-type columns in Data Editor
Fixed an error that occurred when editing data in Data Editor

2.6.107 14-Sep-23

Improvements

Added support for authentication via AWS Identity and Access Management (IAM)

User-reported and internal bug fixes

Fixed an issue with the SSL connection to the server

2.6.86 17-Aug-23

Connectivity

Added support for MySQL v8.1

User-reported bug fixes

Fixed an internal application error in SQL Editor

2.6.27 18-May-23

User-reported bug fixes

Several user reported minor bugs are fixed

2.6.4 19-Apr-23

Data Generator

Added support for the UUID Data Type
Added support for the INET6 Data Type

Connectivity

Added support for MariaDB v11.3
Added support for Support for Aiven Cloud
Added support for SHA-256/512

Text Editor

Enhanced code completion for application-period temporal tables
Added support for a broader range of optimizer hints
Added support for the VALUES ... ORDER BY ... LIMIT statements
Added support for the TABLE statement
Added support for the EXCEPT and INTERSECT statements
Added support for spatial functions ST_LineInterpolatePoint, ST_LineInterpolatePoints, ST_PointAtDistance and ST_Collect

User-reported bug fixes

Fixed an error that could occur when generating BIGINT values (#107570, #107575, #110009, #110007, #110178)
Fixed an error that occurred when opening SQL Editor during script generation (#113530)

2.5.15 30-Aug-22

Improvements

Connectivity support for MariaDB 10.10

User-reported bug fixes

Fixed an issue with data modification in tables with an INVISIBLE column in the Data Editor
Fixed a bug that occurred when saving document cache for recovery

2.5.6 12-Aug-22

General

Added support for Linux and macOS via CrossOver
Added connectivity support for MariaDB 10.9

User-reported bug fixes

Minor user reported bugs are fixed

2.4.608 20-May-22

Improvements

Improved CrossOver compatibility

2.4.602 12-May-22

User-reported bug fixes

Improved the tab activation behavior when executing queries in a SQL Document
Improved the SSH Protocol configuration form to display the Local port option
Fixed an issue in the text editor on Windows builds 22567 and higher
Fixed an unexpected exception that occurred when generating data for the foreign key columns

2.4.526 09-Dec-21

User-reported bug fixes

Fixed an issue with reading table metadata
Fixed an issue with reading session variables when opening a connection
Improved performance when opening a connection

2.4.520 01-Dec-21

User-reported bug fixes

Fixed an issue with the repeated execution of a query in Data Editor
Fixed the behavior of change markers in SQL Editor

2.4.467 25-Aug-21

User-reported bug fixes

Minor user reported bugs are fixed

2.4.435 8-Jul-21

User-reported bug fixes

Minor user reported bugs are fixed

2.4.379 22-Apr-21

User-reported bug fixes

Minor user reported bugs are fixed

2.4.327 02-Feb-21

User-reported bug fixes

Minor user reported bugs are fixed

2.4.311 25-Nov-20

Improvements

Work of the application when connecting via SSL is improved

2.4.287 10-Oct-20

User-reported bug fixes

Minor user reported bugs are fixed

2.4.250 17-Aug-20

User-reported bug fixes

Minor user reported bugs are fixed

2.4.216 07-Jul-20

User-reported bug fixes

Minor user reported bugs are fixed

2.4.189 21-May-20

Connectivity

Connectivity support for MariaDB 10.5 is added
Display of server type in the Property window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
Display of server type in the Connections section of the System window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
Database Connection Properties and Test Connection windows are redesigned
Connectivity support for SkySQL is added

Support for new objects

Working with the Packages and Sequences established in MariaDB 10.3 is supported

SQL Document

-- nowarn and -- endnowarn tags have been added to the Execution warnings functionality
Exporting execution history in the CSV file format is added

Code Completion

Code completion is available in the body of triggers and events

Data Generator

Pre and post script execution during data population.

2.2.33 07-May-19

User-reported bug fixes

Issue with smart data generators list is fixed (MYS-3134)
Minor user reported bugs are fixed

2.2.18 15-Jan-19

Database Connectivity

Support for MariaDB 10.4

User-reported bug fixes

Issue with the "PDF view" mode of Data Viewer is fixed (MYS-2038)
"Spatial view" mode of Data Viewer issue is fixed (MYS-2000)
Problem in Data Population Wizard is fixed (MYS-1979)

2.1.37 20-Nov-18

User-reported bug fixes

Problems with connection to MySQL Server are fixed

2.1.36 17-Oct-18

User-reported bug fixes

Several user reported bugs are fixed

2.1.25 14-Aug-18

User-reported bug fixes

Problem with product freeze is fixed
Problem with NRE is fixed
Problems with lost connection are fixed
Problems with TLS 1.2 connection are fixed

2.1.11 27-Jun-18

Database Connectivity

Support for MySQL Server 8.0
Support for MariaDB 10.3
Support for Tencent Cloud

2.0.19 12-Apr-18

Database Connectivity

MariaDB 10.1
MariaDB 10.2
Google Cloud Platform
Alibaba Cloud
Azure MySQL

Other features and improvements

New Data Population Options

User-reported bug fixes

Connecting to Azure MySQL issue is fixed (T237215)
Other user reported bugs are fixed (T210156, T242062, T167365, T166396, T173058, T214247, T218965, T213706)

1.7.12 30-Nov-16

New features and improvements

Composite primary keys are supported (T197645, T153332, T167476)

1.7.10 17-Nov-16

New features and improvements

Improved SQL document parser performance
Connection through Named Pipe implemented
Improved XML View and new JSON View for Data Editor and Viewer Window
Additional SQL statements are supported
Syntax Check supports new MariaDB 10.0 - 10.1 statements
Styled icons are used by default
Other minor fixes and improvements

1.6.8 07-Apr-16

New features and improvements

JSON data generator added
MySQL 5.7 supported
Custom path to cache folder option added

1.5.26 23-Sep-15

Supported Data Types

BIT(M)
SET
ENUM
Point
LineString
Polygon
MultiPoint
MultiPolygon
Geometry
GeometryCollection

Meaningful Generators

Iron Python script generator implemented
Password generator implemented
Credit Card Type generator redesigned
International Securities Identification Number (ISIN) generator improved
IPv4 Address generator extended
5 new meaningful generators added

1.0.18 01-Sep-15

New features and improvements

First release of dbForge Data Generator for MySQL.