Structured Mock Data Generator

Design a single table or a relational dataset locally in your browser and generate localized data with faker-js/faker. Supports foreign keys, dependency ordering, nested fields, uniqueness, null probability, ranges, enums, templates, and sequences, plus relational SQL DDL, multi-sheet Excel, JSON, CSV, TSV, YAML, and XML exports.

Data is generated only in this browser and never uploadedWorker generation11 fields

Field designer

11 fields3 nested

Use dots for nested objects, such as address.city. Fields generate from top to bottom.

UNIQUE

Null probability

Unique values

Prefix

Suffix

Null probability

Unique values

Prefix

Suffix

UNIQUE

NULL 10%

Entirely local

Schema parsing, generation and file export all run in your browser.

Reproducible schemas

Save the seed, reference date and field rules to reproduce test data.

Multiple exports

Export JSON, CSV, TSV, SQL, YAML, XML, Excel and the schema itself.

Smart import

Infer a field model from database DDL, API types or sample JSON.

About Structured Mock Data Generator

Generate reproducible relational test data with foreign keys. Design a single table or a relational dataset locally in your browser and generate localized data with faker-js/faker. Supports foreign keys, dependency ordering, nested fields, uniqueness, null probability, ranges, enums, templates, and sequences, plus relational SQL DDL, multi-sheet Excel, JSON, CSV, TSV, YAML, and XML exports. The core workflow is designed to run in your current browser.

Key capabilities

Multiple tables, foreign keys, and complete database templates
Visual field and nested-schema designer
Unique, null, range, enum, and template constraints
JSON, CSV, SQL, YAML, XML, and Excel exports

Useful for

Generate database seeds and demo data
Create API fixtures and automated-test samples
Fill prototypes, tables, and dashboards with realistic content

Frequently asked questions

Is Structured Mock Data Generator free to use online?

Yes. Structured Mock Data Generator opens in a modern browser and does not require desktop software installation.

What is Structured Mock Data Generator useful for?

Common use cases include Generate database seeds and demo data; Create API fixtures and automated-test samples.

Is my input or file uploaded?

The core processing workflow is designed to run locally in the browser. Key capabilities include Multiple tables, foreign keys, and complete database templates, Visual field and nested-schema designer, Unique, null, range, enum, and template constraints; account, comments, and anonymous analytics may still create normal site requests.

Comments

0 comments

AAccount

No comments yet. Be the first to leave feedback.