Mock Data Generator

Build a schema, get up to 10,000 rows as JSON, CSV, SQL INSERT or C#, reproducible with a seed.

Runs locally · nothing uploaded

All names, emails (example.com), companies, addresses, URLs (.example), card numbers and IBANs are fictional, randomly generated test data. Phone numbers follow real formats and may happen to exist, so never call or text them.

Schemafield name, type, options, % of nulls

Output

What it does

Describe the rows you need and get realistic test data in the format your code wants. Each field has a name, a type, its own options (ranges, decimals, date windows, value lists, card brand, IP range) and a null % for optional columns.

  • 31 field types: names, emails, usernames, phones, companies, job titles, addresses, lorem text, numbers, booleans with a true %, dates, GUIDs, sequences, value lists, IBAN-like values with a valid mod-97 check, Luhn-valid test card numbers, URLs, IPs, hex colors, products, prices and statuses.
  • English and Turkish names, cities, streets and companies, with correct Turkish characters. Turkish postcodes start with the city’s plate code.
  • Consistent rows: email, username and full name are built from the same person as the first and last name fields.
  • Seed: the same seed and schema always give the same rows. Leave it empty for fresh random data.

Output formats

JSON, JSON Lines, CSV (comma, semicolon or tab, with an optional BOM so Excel shows Turkish characters), SQL INSERT for T-SQL (N'…' strings, at most 1000 rows per statement) or PostgreSQL with an optional CREATE TABLE, and C#: a record plus a ready-to-use list, or a Bogus Faker<T> that recreates the schema in your tests. Bogus uses its own random generator, so its values will not match this page.

How to use

Start from a preset (Customers, Orders, Products, Users), edit the fields, pick the row count and format, then copy or download the result.

Privacy

Everything is generated in your browser with crypto.getRandomValues, or with a seeded generator when you set a seed. Emails use the reserved example.com domain and URLs use the reserved .example domain. Your schema and settings are saved only in local storage.