MySQL Data Generator

The Data Generator tool incorporated into dbForge IDE for MySQL provides a simple and fast way to populate MySQL database tables with thousands of rows of meaningful test data. The tool features 200+ generators to populate tables with the most frequently used data types. In addition, dbForge Studio for MySQL allows automating data generation using the command line.

Full support for all MySQL column data types

The tool supports a massive range of column data types, including:

  • INTEGER, DECIMAL, NUMERIC, FLOAT
  • TIME, DATE, DATETIME, YEAR
  • CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT
  • ENUM, SET, JSON
  • All spatial data types
Supported Data Types

Multiple generators with data customization

Data Generator comes with individual generators for each supported MySQL data type, that allow customizing:

  • Number of NULL rows
  • Number of empty rows
  • Data uniqueness
  • Value ranges
  • Value distribution mode
Multiple generators with data customization

SQL data integrity support

The tool supports foreign keys for generation of consistent data across multiple tables. It also allows disabling triggers and constraints to avoid interference with database logic.

Data integrity support

Multiple ways to populate data

The generated data population script can be immediately executed against a MySQL database, saved for the future use or edited in the internal editor.

Multiple ways to populate data

Basic generators

With the collection of basic generators, you can populate tables with various types of values. The tool includes the following generators:

  • Regular Expression
  • Weighted Lists
  • SQL Query
  • Table or View
  • Text File
  • Files Folder
  • Shuffled Text
  • Lorem Ipsum
  • Python
Basic Generators

Meaningful generators

MySQL Data Generator includes 200+ generators, that allow populating MySQL tables with real-world test data. In particular, the tool can fill your tables with:

  • IDs
  • Post codes
  • Phone numbers
  • Countries
  • Credit card numbers
  • E-mails
    • and much more!
Meaningful Generators

User-defined generators

You can create, save, and use your own generators that would better meet your needs, instead of customizing existing generators over and over again.

User-Defined Generators

Real-time preview of generated data

A convenient preview pane gives you real-time visualization of the changes you make while you adjust data generation settings. This gives you an opportunity to quickly make visual assessment of the data that will be generated.

Real-time preview of generated data

Command-line interface

The command-line functionality allows scheduling routine MySQL data generation tasks. In addition, you can create a command line execution file with preset options and parameters for MySQL data generation, and run it with a single click.

Command-Line Interface

Conclusion

Data Generator, as a part of dbForge Studio for MySQL, simplifies the testing process of software. It's an excellent tool for creating meaningful and realistic test data for database tables. With Data Generator, you can automate and schedule data generation using the command line.

Along with Data Generator, dbForge Studio for MySQL provides many other tools for managing, developing, and administering MySQL and MariaDB databases.

dbForge Studio for MySQL

The most intelligent MySQL management tool

Download

Availability in the editions of dbForge Studio for MySQL

Feature

Enterprise
Professional
Standard
Express
Data Generator with 200+ predefined meaningful data generators
Yes
None
None
None