A specialized tool designed for developers and DBAs to generate test data for MySQL tables. Quickly create MySQL test data by generating SQL files or populating your database directly with randomized values.
This tool is for generating test data only. Never use it on production databases. Generated data is randomized and not intended to be meaningful.
Follow these steps to run the data generator manually via command line.
wget https://raw.githubusercontent.com/kedarvj/mysql-random-data-generator/master/populate.sql
mysql -u username -p db_name < populate.sql
Arguments: CALL populate(database_name, table_name, num_rows, 'Y/N' [debug-mode])
mysql -u username -p db_name -e "CALL populate('my_db', 'my_table', 1000, 'N')"
Generating test data is often a tedious and repetitive task for developers and DBAs. Writing custom scripts or manually creating SQL statements to fill tables can lead to errors and consume valuable development time. This tool solves that problem by providing an automated, predictable, and safe way to generate test data, allowing you to focus on building features rather than filling databases.
CREATE TABLE statement. Our parser identifies columns and types, then generates a downloadable SQL file with INSERT statements. No database access required.
populate.sql script directly via the MySQL command-line client.
No. This tool is strictly for test and development data. Never use it on production databases as it performs bulk insertions and generates randomized data.
No. Database credentials are only used for the current session and are never logged, stored, or transmitted to any third-party services.
Yes. Mode 1 allows you to generate SQL files entirely on your machine without requiring any database connection or permissions.
For browser stability, we apply a 100,000 row limit for SQL generation. Direct database population is batched to prevent timeouts.
If you encounter bugs or have feature requests, report it on GitHub page.
No telemetry. No tracking. Just a tool for DBAs and developers.