Generate Large Datasets of MySQL Test 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 populating MySQL database tables with random data. You don't have to create your test data manually anymore - dbForge Data Generator for MySQL makes the data generation process easy and fast.

Full support of 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

Multiple generators with data customization

Data Generator comes with individual generators for each supported data type, that allow to customize:

Number of NULL rows

Number of empty rows

Data uniqueness

Value ranges

Value distribution mode

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.