Fun Data Playgroundalternative
Use casesField typesAccount← Generator

A free Mockaroo alternative

Same job — schema in, realistic rows out — with no account, no row-count meter, and no upload of the schema or the data to anybody's server.

Start generating →Field type reference

The one architectural difference

Mockaroo is a well-established hosted service, and hosted is the right model for plenty of teams — it is how you get server-side APIs, saved projects and scheduled generation.

This site is built the other way round: the generator is a static page, and every row is produced by JavaScript in your own browser. Nothing about your schema or your data is transmitted anywhere, because there is no server to transmit it to. That single decision is what removes the account, the row limit and the privacy question at the same time — there is no per-request cost to meter.

It also means the site keeps working offline after the first visit, and that generating 100,000 rows is bounded by your laptop rather than a queue.

What you get here

  • 68 field types across Basics, Person, Location, Internet, Business, Date & Time and Text — the full list is on the field type reference.
  • Six export formats — CSV, TSV, JSON, NDJSON, SQL and XML.
  • 100,000 rows per export, with no account and no daily allowance.
  • Seeded output — the same seed and schema produce byte-identical data on any machine, which is what makes a fixture safe to commit.
  • Blank % per field for nullable columns, and a Unique toggle for constrained ones.
  • Formula fields for values derived from other columns, so line totals actually add up.
  • Nested JSON through dot-notation field names, and SQL dialects for Postgres and MySQL.
  • Shareable schema links, and an optional account purely for syncing schemas between your own devices — never required to generate.

Where a hosted tool is the better answer

Being straightforward about this is more useful than a feature table. Choose a hosted service when you need:

  • A generation API your CI can call to produce fresh data on every run.
  • Multi-table relational output generated in one pass with foreign keys resolved for you. Here that is a deliberate two-pass job — generate parents, feed their IDs into a Custom List on the child — which the database guide walks through.
  • Millions of rows per file, or generation that runs on a server while you do something else.
  • Team accounts with shared, permissioned schema libraries.

Feature sets and pricing on hosted services change, so check the current terms of whichever you are comparing rather than trusting any comparison page, including this one.

Moving an existing schema over

Field names and types transfer directly — the vocabulary is close enough that a users or orders schema takes a couple of minutes to rebuild. Two shortcuts:

  • Upload a CSV sample and the generator infers a starting schema from the header row and values, which is usually faster than adding fields one at a time.
  • Start from a template — users, orders, employees, sensors or transactions — and edit from there.

Anything the built-in types do not cover is usually reachable with a Pattern field (# digit, ? uppercase, ~ lowercase), a Regex field, a Custom List, or a Formula that derives the value from other columns.

On the safety of the data

Generated values are built so that a leaked fixture is embarrassing rather than dangerous: emails use RFC-reserved domains that cannot receive mail, card numbers are the published gateway test values, IBANs are correctly shaped but fail their checksum, and IP addresses come from documentation ranges. The methodology page documents every one of those choices.

Common questions

Is it really free with no signup?

Yes. Generation runs entirely in your browser, so there is no server cost to meter and nothing to charge for. An account exists only to sync your saved schemas between your own devices, and is never required.

Is there a row limit?

Up to 100,000 rows per export, with no daily or monthly allowance. For more, export several times with different seeds and concatenate the files.

Does my schema or data get uploaded anywhere?

No. The generator is a static page and every row is produced locally. Unless you deliberately sign in to sync schemas or create a share link, nothing leaves your browser.

Can it generate related tables with foreign keys?

Not in a single pass. Generate the parent table, then paste its key column into a Custom List field on the child schema so every reference resolves. The database guide covers the full flow.

Is there an API for generating data in CI?

No — that is the main thing a hosted service offers that this does not. The alternative is to generate a seeded fixture once and commit it, which is more reproducible anyway.

Related