🧪

Mock Data Generator

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 to Community

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

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.

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.

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.

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.

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

🧪

Dummy Data Generator

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

AI Data Generator

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

🔌

API Mock Response Generator

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

QR Code Generator

QR code generator free - create QR codes from URLs or text with no watermark, no signup required

{ }

JSON Schema Generator

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

UUID Generator

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

What is Mock Data Generator?

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

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