Available field types
Each schema field has a name, a type and optional settings. Below are all available types and what they fit.
id
Auto-increment: integer starting from 1. Used as a primary key.
uuid
UUID version 4 — a random 128-bit identifier. Fits distributed systems, APIs and Postgres uuid columns.
firstName
A random first name from the built-in list. Email and full name fields are derived from the same list.
lastName
A random last name from the built-in list.
fullName
A full name — combination of first and last names separated by space.
An email of the form firstname.lastname@domain. If you need guaranteed uniqueness across a large dataset, add a separate id field and use it as a suffix in your SQL.
phone
A phone number in +CC NNN-NNNN format.
integer
An integer with min/max settings.
decimal
A floating-point number with min/max and number of decimal places.
boolean
A true/false value; the probability of true is configurable (default 50%).
date
A random date in the given range, formatted as YYYY-MM-DD.
datetime
A random date-time in the given range, formatted as YYYY-MM-DD HH:MM:SS.
timestamp
Unix timestamp in seconds for a random date-time from the range.
enum
A random pick from a comma-separated list of values. Used for statuses, categories, types.
lorem
Lorem ipsum — random placeholder text. The number of words is configurable.
url
A random URL of the form https://domain/path.
ip
A random IPv4 address.
color
A random color in HEX format (#RRGGBB).
city
A random city from the built-in worldwide cities list.
country
A random country from the built-in list.
company
A random company name from the built-in list.