dbForge Data Generator for MySQL

GUI tool for the fast generation of large volumes of MySQL test table data

dbForge Data Generator for MySQL is a powerful GUI tool for creating massive volumes of realistic test data. The tool includes a large collection of predefined data generators with customizable configuration options that allow to populate MySQL database tables with meaningful data of various types.

Key features:

1. Full support of all MySQL column data types

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

2. Multiple generators with data customization

• Number of NULL rows
• Number of empty rows
• Data uniqueness
• Value ranges
• Value distribution mode

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

4. Multiple ways to populate data

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

5. Basic generators

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

6. Meaningful generators

• dbForge Data Generator for MySQL includes 180+ generators, that allow to populate tables with realistic-looking test data. There is an ability to fill tables with IDs, Post codes, Phone numbers, Countries, Credit card numbers, E-mails, etc.

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

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

9. Command-line interface

• With the command-line functionality, you can save time by scheduling routine data generation tasks.

Learn more about dbForge Data Generator for MySQL at the product page