Dummy data for MYSQL database

This is a free tool that lets you quickly generate large volumes of custom data in a variety of formats for use in testing software and populating databases with random data. This application is an unique online service that allow to generate database test data in multiple relational tables with Foreign Key Support. It can generate unique values, and optional data, populate with values from another table.

Main Database Data Generator Features:

  • Generate Unique Values
  • Generate Optional Values
  • Foreign Key support
  • Numeric values (integer numbers, float numbers etc)
  • Paragraphs and Sentences
  • Date and time values
  • Emails, domains, ip,user agents
  • Images, files, extensions, mimeTypes
  • User data (firstnames, lastnames, title, gender)
  • Locations (countries, cities, address, languages)
  • Boolean values
  • Credit cards
  • Hashed data, barcodes, uuid

Step 1. Provide your database structure

You have 2 options to provide your database, using file submittion or pasting database schema in a textarea

generating data

Step 2. - Select tables, choose data type of each column, generate rows

User select a table and choose what data to be generated for every column.

generating data

Sample of generaged Data

sample of generated data

Step 3. Export Database with generated data

generating data

Frequently asked questions

Dummy data is a information that does not contain any useful data, but serves to reserve space where real data is nominally present. Dummy data can be used as a placeholder for both testing and operational purposes. For testing, dummy data can also be used as stubs or pad to avoid software testing issues by ensuring that all variables and data fields are occupied.
Yes, it's possible! There are 2 options:
1.Generate image urls - use function imageUrl()
2.Generate real image files - use function image()
You can indicate width and height of generated images, and what type of image to be generated, it can be one of the following categories: abstract, animals, business, cats, city, food, nightlife, fashion, people,nature, sports, technics, transport. If you choose to generate Real Image, please keep attention to the success message displayed after generation is complete. Here is provided a link to zip archive for downloading generated images.
Please use function foreignKey() from dropdown list. You have to indicate table name and table column as parameters.
The application will try to guess which table to use as parent table.
Please note that you cannot fill a column with values from another table if that table is empty. So you have first to generate data for parent table and then for the table with foreignKey.