# Mock Data Generator Online - Fake Test Data as JSON, CSV, SQL or TypeScript

> Free online mock data generator: define fields and generate up to 10,000 rows of fake names, emails, addresses, dates and IDs, exported as JSON, CSV or SQL.

- URL: https://qilingtools.com/en/mock-data
- Category: Developer Tools (https://qilingtools.com/en/dev)
- Tags: [Developer](https://qilingtools.com/en/tags/dev), [Data Formats](https://qilingtools.com/en/tags/data)
- Last updated: 2026-10-26
- Price: Free, no sign-up
- Privacy: Runs locally in the browser; files are never uploaded

Development and testing constantly call for realistic-looking data: seeding a database, checking table pagination, demoing a UI or load-testing an API. Define fields the way you would design a table — a name and a type — and generate up to 10,000 rows at once. More than 30 types are built in: auto-increment ID, UUID v4, English and Chinese names, usernames, emails, US and Chinese phone numbers, US and Chinese addresses, cities, ZIP codes, company and product names, integer and decimal ranges, date, date-time and timestamp ranges, booleans, custom enums, words, Lorem sentences and paragraphs, Chinese sentences, IPv4, IPv6, MAC addresses, URLs, hex and HSL colors and constants, and every field can have a null percentage. Names, usernames and emails in the same row match each other for more believable data. Generation uses a seeded pseudo-random generator, so the same seed and fields always produce exactly the same data — ideal for reproducible tests. Export as JSON, JSON Lines, CSV with a choice of delimiter, SQL INSERT statements for MySQL, PostgreSQL, SQLite or SQL Server with configurable batch size, or a typed TypeScript array, and start from the Users, Orders or Products presets.

## How to use

1. Pick a preset or add fields one by one and set their types and options
2. Set the row count and seed, and check the preview table
3. Choose an output format (JSON / CSV / SQL / TypeScript), then copy or download

## Features

- 30+ field types including names, addresses and phone numbers
- Ranges, enum values and null percentage per field
- Seeded generator for reproducible results
- Up to 10,000 rows, generated in milliseconds
- Export JSON, JSON Lines, CSV, SQL INSERT or TypeScript
- SQL dialects for MySQL, PostgreSQL, SQLite and SQL Server
- Fictional data generated locally, nothing uploaded

## FAQ

### Are the generated names, phones and addresses real?

No. Names are random combinations of common first and last names, and addresses are assembled from cities, streets and random house numbers, so they are fictional. US phone numbers use the 555-01xx range reserved for fiction and emails only use reserved domains such as example.com, so nothing reaches a real inbox. Chinese mobile numbers only follow a valid prefix format and may coincide with real numbers, so never call or text them.

### What is the seed for?

The seed determines the random sequence. As long as the seed and the fields stay the same, every run produces identical data, and the first N rows stay the same when you change the row count. That keeps test cases, screenshots and bug reproductions consistent. Click New seed when you want a fresh batch.

### Can I import the SQL output directly?

Yes. Pick your database and identifiers are quoted the way it expects (backticks for MySQL, brackets for SQL Server, double quotes for PostgreSQL and SQLite), single quotes in strings are escaped, and booleans and NULL follow the dialect. You can choose how many rows go in each INSERT; 100–1,000 rows per statement imports much faster for large batches. You still need to write the CREATE TABLE statement yourself.

### How many rows can it generate, and will it be slow?

Up to 10,000 rows per run, and generation itself usually takes a few dozen milliseconds. For large results the text box shows only the beginning to keep the page responsive, while copy and download always include everything. All data is generated locally in your browser and never uploaded.

## Related tools

- [JSON Formatter](https://qilingtools.com/en/json): Free online JSON formatter: beautify or minify, validate with the exact line and column of any error, browse a collapsible tree, sort keys and escape strings.
- [Base64 Encode/Decode](https://qilingtools.com/en/base64): Free online Base64 encoder and decoder: UTF-8 safe, optional URL-safe variant, convert text to Base64 and back in real time. Processed locally, never uploaded.
- [URL Encode/Decode](https://qilingtools.com/en/url-encode): Free online URL encoder and decoder with encodeURIComponent and encodeURI modes. Escapes Chinese, spaces and special characters. Real-time and local, no upload.
- [JWT Decoder](https://qilingtools.com/en/jwt): Free online JWT decoder: decode the header and payload of a JSON Web Token, show expiry and issued-at times, all locally without uploading the token.
- [Timestamp Converter](https://qilingtools.com/en/timestamp): Free online Unix timestamp converter: convert timestamps and dates, auto-detect seconds or milliseconds, and show local, UTC, ISO 8601 and relative time.
- [Hash / Checksum](https://qilingtools.com/en/hash): Free online hash calculator: SHA-1, SHA-256, SHA-384 and SHA-512 of text or any file through the browser crypto API. Files never leave your device.
- [UUID Generator](https://qilingtools.com/en/uuid): Free online UUID generator: create RFC 4122 UUID v4 in bulk with a cryptographic RNG. Options for uppercase, no hyphens and braces, with one-click copy.
- [Base Converter](https://qilingtools.com/en/base-convert): Free online number base converter: convert between binary, octal, decimal, hexadecimal and any base 2–36. Uses BigInt for huge integers, computed locally.