🧪

Mock Data Generator

LOCAL · Browser-Only

Generate millions of rows of realistic mock data from SQL schemas, Prisma models, or a visual column builder

Quick Presets

Columns7

Nullable

Rows

Free: up to 10,000 rows

Format

Seed (optional)

·Share recipe

Was this tool helpful?

What is Mock Data Generator?

Generate realistic mock data at scale with the Mock Data Generator.

Define your schema visually by adding columns and picking data types, or import directly from CREATE TABLE SQL, Prisma models, or TypeORM entities - the tool auto-detects column types based on names and data types. Generate up to 10,000 rows free in your browser with no signup. Export as JSON, CSV, SQL INSERT statements, TSV, or XML. Choose from 40+ data types including names, emails, addresses, UUIDs, timestamps, IP addresses, credit cards, and more. Use a seed for reproducible output. All free-tier processing runs entirely client-side - your schema and data never leave your device.

How to Use Mock Data Generator

1Define your schema using the visual column builder or import a CREATE TABLE, Prisma model, or TypeORM entity
2Configure column names, data types, and nullable settings
3Set the number of rows to generate and choose your output format (JSON, CSV, SQL, TSV, XML)
4Click Generate to create the data instantly, then copy or download the output

Frequently Asked Questions

How is this different from the Dummy Data Generator?

The Mock Data Generator supports schema-aware generation - paste a CREATE TABLE SQL statement, Prisma model, or TypeORM entity and it auto-detects your columns and maps them to appropriate data types. It also supports nullable columns, and paid tiers will support generating millions of rows via server-side streaming.

What schema formats are supported?

You can import CREATE TABLE statements (MySQL and PostgreSQL syntax), Prisma model definitions, and TypeORM entity classes with decorators. The parser auto-detects the format and maps SQL/Prisma/TypeORM types to realistic mock data generators.

How many rows can I generate for free?

The free tier supports up to 10,000 rows generated entirely in your browser. Paid credit packs allow generating up to 100 million rows via server-side streaming, so your browser never runs out of memory.

What output formats are available?

JSON (pretty-printed array of objects), CSV (with proper escaping), SQL INSERT statements (ready to run against your database), TSV (tab-separated), and XML. All formats support the full column set you define.

Is my schema data safe?

Yes. Schema parsing and free-tier data generation happen entirely in your browser using JavaScript. Your schema is never sent to any server. For paid tiers, the schema is sent to our Cloudflare Worker only during generation and is not stored.

Share this tool

Related Tools

Fake data

Generate mock data in JSON, CSV, or SQL from a text description using a local AI in your browser

🧪

Dummy Data Generator

Free online dummy data generator - generate realistic fake data for testing in JSON or CSV format

🔌

Mock api response

Free online API mock response generator - generate mock API responses for testing

👤

Random Name Generator

Free online random name generator - generate realistic random names for testing and mockups

{ }

Generate json schema

Free online JSON schema generator - generate JSON Schema from sample JSON data automatically

📊

CSV to JSON Converter

Free online CSV to JSON converter - convert CSV data to JSON format with delimiter options and preview

Json to ts interface

Free online JSON to typescript - convert JSON objects to TypeScript interfaces and type definitions

UUID Generator

Free online UUID generator - generate unique UUIDs (v4) for your applications

Keep reading: SQL Cheat Sheet and http status codes reference. Doing this in code instead? See the utility endpoints.

🧪