Connecting to OmniTools before opening this tool…
Only a temporary connection check is sent. Your files and tool inputs stay in your browser.
How Mock & Fake Data Generator works
The Mock Data Generator creates realistic, production-grade test datasets for software development, database seeding, QA testing, and UI prototyping. Powered by Faker.js, the visual schema builder lets you define custom fields spanning personal identities, corporate records, location coordinates, commerce metrics, timestamps, and UUIDs with zero server calls.
Generating realistic mock data is crucial for testing edge cases, validating database constraints, measuring query performance, and mocking API endpoints before backend services are built. You can customize field names, assign specific data generators, and configure row counts from 10 up to 5,000 records.
The generator supports instant multi-format exports including structured JSON arrays, comma-separated CSV files for spreadsheets, and SQL batch INSERT statements with customizable table names. Preview your dataset live in the interactive table and export with a single click.
How to use Mock & Fake Data Generator
1. Configure Schema Fields
Add, rename, and assign data types to your fields (Names, Emails, UUIDs, Dates, Prices, Companies, Avatars, Booleans).
2. Set Target Row Count
Select how many records to generate (10, 50, 100, 500, 1,000 rows) based on your development and testing needs.
3. Preview Generated Data
Inspect the live preview table to review sample data values and verify schema structure before exporting.
4. Export in JSON, CSV, or SQL
Select your desired output format (JSON, CSV, or SQL INSERT statements) and copy or download the generated dataset.
Key features and technical specifications
Extensive Field Catalog
Rich generators for UUIDs, full names, emails, phone numbers, addresses, companies, job titles, prices, dates, and avatars.
Multi-Format Exporting
Download datasets as structured JSON arrays, flat CSV spreadsheets, or ready-to-run SQL INSERT statements.
Visual Schema Builder
Easily add, rename, reconfigure, and delete custom schema fields with an intuitive card-based builder interface.
100% In-Browser Generation
Generate thousands of mock records instantly in local memory without API rate limits or network latency.
Useful fixtures include edge cases
A table of ordinary-looking sample records may miss the cases that break an interface. Add empty values, long names, Unicode characters and boundary numbers relevant to your application. Synthetic data is useful for testing structure and display, but it should not be presented as real customer activity or statistical evidence.
Full-Stack Developers
Seed local development databases, mock REST and GraphQL API responses, and test complex frontend pagination components.
QA & Test Engineers
Create diverse test datasets with realistic edge cases to validate search filters, data grids, and form validations.
UI/UX Designers & Prototypers
Populate Figma prototypes and interactive web mockups with authentic names, photos, job titles, and company data.
Frequently asked questions
Are the generated email addresses and phone numbers real?
No. All data is synthetically generated using Faker.js algorithms to mimic authentic formatting without belonging to real individuals or organizations.
Can I export SQL statements for specific table names?
Yes! Select the SQL export mode and enter your target table name in the field. The tool generates structured INSERT INTO "table_name" statements automatically.
What is the maximum number of rows I can generate?
You can generate up to 5,000 rows per batch directly in your browser within a fraction of a second thanks to efficient local processing.
Can I customize the schema field names?
Yes. Simply click into any field name input to rename it to match your exact database columns or API property names.
Can I generate correlated relational foreign keys?
You can generate sequence numbers, UUIDs, and random integer ranges to simulate foreign key references across multiple generated mock datasets, enabling realistic multi-table relational seeding.
Are image avatars served from live CDNs?
The avatar generator produces standardized placeholder image URLs with randomized avatars that can be rendered directly in web browsers and UI component testing environments.
Can I customize the generated SQL INSERT statements?
Yes. You can specify a custom destination table name, and the generator will produce valid INSERT INTO "your_table" (col1, col2) VALUES (...) statements formatted with properly escaped string literals and timestamps.
Can I generate customized dates within a specific historical or future range?
Yes. The date generator produces realistic ISO 8601 timestamps and calendar dates across configurable past and future spans, ideal for testing time-sensitive scheduling, subscriptions, and financial transaction histories.
Do I need an internet connection, and are my inputs uploaded?
An internet connection is required to open tools and refresh a temporary session. Processing stays on your device; the handshake sends a random challenge, not files or text inputs. Libraries, fonts or models may download. Local processing cannot remove risks from an untrusted device or extension.