💙 Supporting healthcare non-profits: Metadataloop is free for 6–12 months. Contact Us to get started.
Free Online Tool

Free Mockaroo Alternative

Mockaroo is great — but if you already have a CREATE TABLE, MetaDataLoop is faster.

Try the Mock Data Generator →

Overview

Mockaroo's UI is excellent, but configuring 50 fields by hand for every new table gets old. MetaDataLoop reads your CREATE TABLE statement directly: it infers what each column probably contains from the column name (email → email, full_name → person name, phone → phone) and the type (NUMERIC(10,2) → currency-shaped decimal, DATE → realistic recent date), and produces ready-to-use rows in seconds.

What you get

✓ INCLUDED
Skip the 50-field UI — your CREATE TABLE is already the spec
✓ INCLUDED
Smart inference: emails, names, phones, addresses, IPs, URLs, lorem text
✓ INCLUDED
Dialect-aware output: Postgres, MySQL, Snowflake, SQL Server INSERT
✓ INCLUDED
Bundled with the rest of MetaDataLoop's data-engineering toolkit
✓ INCLUDED
Free, no signup, no row-limit gotcha

Side-by-side comparison

FeatureMockaroo (free)MetaDataLoop
Signup requiredYesNo
Configure each fieldManualAuto from DDL
Read CREATE TABLE inputNoYes
Free row limit1,0001,000
CSV / JSON / SQL outputYesYes
Snowflake INSERT syntaxGenericYes (dialect-aware)
Schema diff & migrationsNoYes
Schema → Mermaid / DBMLNoYes

Frequently asked questions

Can I customize how a single field is generated?
Currently inference is automatic — column name + type drive the value. For fully custom field-by-field configuration, Mockaroo is still the more flexible tool.
What about referential integrity?
Generate the parent table first, then use those PKs as the FK column values when generating the child table. Cross-table FK auto-wiring is on the roadmap.
Can I generate millions of rows?
Up to ~1,000 rows in-browser. For larger volumes, generate the SQL INSERT, then loop in your client or use a generate_series pattern in Postgres/Snowflake.

Try it now

No signup, no install — runs entirely in your browser.

Try the Mock Data Generator →

⚠ Confirm Delete