Quickly creating sample data is now easy. Create plausible, syntactically correct database sample data for test or demonstration purposes and stress tests. The basis are real postal addresses, first names, surnames, industries, business hours and much more. (*)
event_available selected fields
person person
salutation (Mr./Ms.)
salutation Mr. or Ms.
degree of filling %
title
academic title e.g. Dr. or Dr.med.
degree of filling %
firstname
mostly german firstname
degree of filling %
lasname
mostly german lastname
degree of filling %
firstname and lastname
mostly german fistname and surname
degree of filling %
full name
mostly german salutation fistname and surname
degree of filling %
firstname
additional mostly german first name or middle name
degree of filling %
location_city companies
company name
Company name with legal form, derived from the surname
degree of filling %
branch
branch name derived from the company name if possible
degree of filling %
business hours
frequently used business hours
degree of filling %
tax id
german tax id
degree of filling %
map address
street house nr.
Street and house number matching the other address fields derived from an existing address in Germany
degree of filling %
zip city
Zip code and city matching the other address fields derived from an existing address in Germany
degree of filling %
addition to city
Addition to city matching the other address fields derived from an existing address in Germany
degree of filling %
city
City matching the other address fields derived from an existing address in Germany
degree of filling %
zip code
Zip code matching the other address fields derived from an existing address in Germany
degree of filling %
street
Street matching the other address fields derived from an existing address in Germany
degree of filling %
house number
House number matching the other address fields derived from an existing address in Germany
degree of filling %
house number ext.
House number extension
degree of filling %
house number + ext
House number including extension matching the other address fields derived from an existing address in Germany
degree of filling %
district
City district matching the other address fields derived from an existing address in Germany
degree of filling %
country
country only "Deutschland" suported
degree of filling %
state
State matching the other address fields derived from an existing address in Germany
degree of filling %
big city
big city in Germany
degree of filling %
geo coordinates
Geo longitude and latitude in Germany not matching to the other address fields.
degree of filling % Trennzeichen
x-longitude
Geo position x-longitude in Germany not matching to the other address fields.
degree of filling %
y-latitude
Geo position y-latitude in Germany not matching to the other address fields.
degree of filling %
call communication
phone number
Phone number, the area code matching the other address fields.
degree of filling %
phone
Phone number whitout the area code.
degree of filling %
area code
Area code matching the other address fields.
degree of filling %
mobile phone
Mobile phone number, with a german mobile phone area code.
degree of filling %
fax
Fax number, the area code matching the other address fields.
degree of filling %
e-mail
E-mail address, also derived from the name.
degree of filling %
homepage
Homepage address, also derived from the name.
degree of filling %
addition phone
Phone number, the area code not matching the other address fields.
degree of filling %
e-mail address
e-mail address
degree of filling %
additional homepage
homepage
degree of filling %
event_busy date
birthday >18
birthday >18
degree of filling %
date recently
date recently
degree of filling %
date long time ago
date long time ago
degree of filling %
date near future
date near future
degree of filling %
date far future
date far future
degree of filling %
date/time recently
date/time recently
degree of filling %
date/time/ns recently
date/time/nanosec recently
degree of filling %
date/time long time ago
date/time long time ago
degree of filling %
date/time/ns long time ago
date/time/nanosec long time ago
degree of filling %
date/time near future
date/time near future
degree of filling %
date/time far future
date/time far future
degree of filling %
time
time
degree of filling %
time daylight
time daylight
degree of filling %
emoji_objects miscellaneous
object begin
object begin
current number
current number
degree of filling %
1-14 digit number
1-14 digit number
degree of filling % size
foreign key0
Upload a file with foreign keys, one key per line. These keys are used randomly
degree of filling %
Load a foreign key ID list, one ID per line.
value 0/1
value 0/1
degree of filling % frequency for 1%
value true/false
value true/false
degree of filling % frequency for true%
null field
null field
empty field
empty field
integer
integer
degree of filling % min max
price
price
degree of filling % lowest price highest price currency
flexible
%CC% and %ccc% are 2 uppercase and 3 lowercase letters, %A% are the letters A,B,C %nnnn% is a 4-digit number