Dummy Data for MYSQL Database

Automatically generate data and fill your database tables with test data.

FillDB is a free tool that lets you quickly generate large volumes of custom data in MySql format to use in testing software and populating databases with random data.

Application will try to guess the format of data required based on column names and will generate random names, dates, emails, addresses and more to fill your MySQL database with data.

Just upload you database schema and this unique online service will 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
• Country and Langauge specific Names/Addresses/PhoneNumbers

There are 3 steps to follow for filling your database

1. Submit database schema
2. Generate data for database tables
3. Export Database with generated data

Step 1. Provide your database structure

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

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.

Sample of generaged Data

Step 3. Export Database with generated data

Frequently asked questions

What is Dummy Data?

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.

Is it possible to generate images and how to generate images?

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.

How to populate a column with Foreign Key values?

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.

How to generate country specific entities?

On the Step2 page where you choose what type of data to be generated for selected table there's an optional dropdown next to the 'Number of rows to be generated' text input named 'Generate country specific Names/Addresses/PhoneNumbers', please select required country/language option before cliking on 'Generate Data' button.