Skip to content
Browse tools

Mock Data Generator

Build realistic test records in seconds — pick your fields, choose how many rows, and export as JSON, CSV, SQL inserts or a TypeScript interface.

๐Ÿงฉ Fields

Click a field to include or remove it. The order you pick them is the order they appear in the output.

๐Ÿ“„ Output

โ€”
Pick at least one field to generate data.

๐Ÿ‘๏ธ Table Preview

โš ๏ธ This data is fake, and that's the point. Names, emails and addresses are assembled from generic word lists and are not real people. Never populate a staging or demo environment with a copy of production data — that's how personal information ends up somewhere it was never meant to be. Everything here is generated in your browser and never uploaded.
HOW IT WORKS

Realistic Enough To Find Real Bugs

Good test data isn't just filler — it's shaped like the real thing so it surfaces the bugs real data would. Names here vary in length so your layout gets tested against both "Li Wu" and a long hyphenated surname; emails are derived from the generated name so they look plausible rather than random; dates fall in sensible ranges rather than the year 47000. Export formats cover the usual paths: JSON for API stubs and fixtures, CSV for spreadsheets and bulk import, SQL inserts for seeding a database directly, and a TypeScript interface when you want the type rather than the values. Everything is generated locally, so you can safely use it for commercial work without anything leaving your machine.

What else can you check?

These tools all work on the same connection and address data — pick whichever question you actually have.

Want to see the full path to a site? DNS, redirects, every hop, the CDN, TLS and the origin server. Want to know your public IP? See your IPv4 and IPv6 addresses, location, ISP and ASN. Want to check your tower & route? Live ping, speed, DNS, traceroute and a map of nearby points. Want to ping from around the world? Real latency from real probes across 12 countries, live on a map. Want to locate any IP address? City, region, country and coordinates for any public IP. Want to know if an IP is risky? Proxy, VPN, Tor, hosting and abuse-report indicators. Want to know if you're blacklisted? Check an address against major spam and abuse DNSBLs. Want to know who owns an IP? Network owner, ASN, CIDR range and abuse contact. Want to explore an AS number? Announced prefixes, BGP neighbours and registry details. Want to test your connection speed? Measure real download, upload, ping and jitter. Want to see what changed? Word-level diff between two blocks of text or code. Want to know if a DNS change is live yet? Compare answers from five independent public resolvers. Want to verify a domain's nameservers? Direct authoritative checks, glue records and SOA serials. Want to check a domain's DNSSEC setup? DNSKEY, DS records, signature expiry and real validation. Want to see the hop-by-hop path to a server? A real traceroute from a genuine probe anywhere in the world. Want to know if a server port is open? A real TCP connection attempt - open, closed or filtered. Want to measure latency to a server? Real connect timing - min/avg/max, jitter and connection loss. Want a clean URL slug from a title? Real transliteration, stop words and batch mode. Want to find and replace across a document? Regex, capture groups and a live preview before you commit. Want to find the invisible character? Code points, escapes, bytes and hidden-character detection. Want to escape text for HTML? Minimal, named or numeric entities, attribute-safe. Want to strip emoji cleanly? Whole clusters - no half-flags or stray modifiers left. Want to spot repeated words? Frequency, density and accidental doubles like "the the". Want to know if a URL is cached? Two requests prove whether your CDN is really caching it. Want to see what a site knows about you? Storage, cookies, tokens and what your browser actually cached. Want to run that check on any site? One-click bookmarklet reads storage and tokens where they live. Want to know who your site talks to? Renders the page and names every outside company it contacts. Is your site one address or four? www, non-www, http and https - which serve, which redirect. Need to build an Authorization header? Basic, Bearer, API key, Digest and AWS SigV4 - signed in your browser. Want to tidy up a messy SQL query? Beautify, minify, lint and convert keyword casing for six dialects. Need to work out a percentage? Nine calculators covering every way a percentage gets asked. Want to work out a rise or a raise? Increases, growth, compounding and CAGR, with the working shown. Want to work out a discount or a drop? Discounts, stacked sales and depreciation, with the working shown. What is actually on that page? Words, reading time, readability, every image, embed and link. Need a favicon that works everywhere? Every size, a real multi-resolution .ico, and the tags to paste. What headers does a site send back? Every response header on every redirect hop, explained. Need to test a regular expression? Live matches, capture groups, replace preview and code snippets. Need a JPG as a PNG? Batch convert in your browser, with optional transparent background. Need somewhere to jot things down? Private notes, links, to-dos and reminders saved in your browser. Need just some pages of a PDF? Split by page, range or chunk, or extract the pages you pick. What is hiding inside that image? EXIF camera settings, GPS tags, colour palette and web checks.
COMMON QUESTIONS

Mock Data FAQ

Could any of this data match a real person?

Names are assembled by combining common first and last names, so a combination could coincidentally match someone — but nothing here is drawn from any real dataset, and emails use the reserved example.com domain, which can never receive mail. Treat it as fictional, because it is.

Can I use this for commercial projects?

Yes. It's generated on your machine from generic word lists, with no licensing restrictions and nothing transmitted anywhere.

Why example.com for emails?

Because RFC 2606 reserves it precisely so test data can't accidentally send mail to a real address. Test data that reaches a stranger's inbox is a genuine and surprisingly common incident.

How many rows can I generate?

Up to 1,000 per run. Past that, browser rendering becomes the bottleneck rather than the generation, and a script in your own language is a better fit.

Are the SQL inserts safe to run directly?

Values are escaped for single quotes, but always review generated SQL before running it against anything you care about — and never against production. The table name in particular is inserted as you type it.