Mock Data Studio | Fake Data, JSON/CSV/SQL, Bulk Generation - Features & Free Guide | Shamoji DRIVE
High-Performance Mock Data Studio: Generate Realistic Test Records in JSON, CSV, SQL & TypeScript
Instant in-browser synthetic data generator for development, testing, and UI prototyping. Produce up to 1,000 realistic records with names, emails, phones, addresses, UUIDv4/v7, ULID, timestamps, prices, and custom choices. Export as Interactive Table, JSON, CSV, SQL INSERT, and TypeScript interfaces with zero external network transmission.
Recommended Use Cases
- Database Seeding & SQL INSERT Script Generation: Generate batch SQL INSERT statements for PostgreSQL, MySQL, and SQLite with customizable table names. Perfect for populating local test databases and running migration seeds.
- Frontend Prototyping & Mock JSON Payloads: Instantly build JSON arrays with realistic user profiles, products, and order data for Vue, React, or mobile app UI components without relying on live backend APIs.
- Bulk CSV Export for Stress Testing & Spreadsheets: Download structured CSV files with up to 1,000 records for validating search filters, pagination components, and CSV import pipelines in Excel or BI tools.
- Instant TypeScript Interface Generation: Automatically generate matching TypeScript interface definitions from your schema fields (string, number, boolean) with one-click clipboard copying.
Key Features
- Rich Multilingual Data Dictionary (Japanese & Global): Supports realistic Japanese kanji names, hiragana furigana, prefectures, genuine street addresses, mobile phones (090/080), as well as English global names and street addresses.
- UUIDv4 / UUIDv7 (Time-Sortable) / ULID & Prefixed Sequences: Generates modern primary keys including timestamp-sortable UUIDv7, Crockford-base32 ULID, standard UUIDv4, and customizable sequential IDs (e.g. ORD-10001).
- 5 Output Formats: Live Table, JSON, CSV, SQL & TypeScript: Instantly preview generated records in a clean tabular grid, or switch tabs to view and copy syntax-highlighted JSON, CSV, SQL INSERT statements, or TS types.
- Flexible Options for Number Ranges, JPY Prices & Choices: Fine-tune field parameters such as min/max integer bounds, Japanese Yen price spans, or custom comma-separated enum choices (e.g. pending, shipped, delivered).
- 100% Client-Side Generation • Zero Network Leakage: All synthetic data algorithms run purely in client-side JavaScript inside your browser. No private seed requirements or generated datasets are ever sent across the wire.
How to Use
- Choose Preset or Build Schema: Select from prebuilt templates (User Profiles, EC Orders, Employee Master, Access Logs) or customize your own fields.
- Set Record Count & Generate: Pick the desired number of rows (10 to 1,000) and click Regenerate (Shuffle) to produce fresh records immediately.
- Inspect & Copy or Download: Review the interactive table preview, or copy and save formatted JSON, CSV, SQL INSERT scripts, or TypeScript types.
Frequently Asked Questions (FAQ)
- Q. Can I use the generated data in commercial projects?
- A. Yes, absolutely. All generated data is completely synthetic and randomly assembled, free for commercial and non-commercial development and testing.
- Q. What is UUIDv7 and why should I use it?
- A. UUIDv7 embeds a millisecond Unix timestamp in its high bits, making it naturally chronological and ordered. This dramatically improves B-tree index insertion performance in relational databases.
- Q. How does it perform on mobile devices?
- A. On mobile screens, the tool provides a responsive tab toggle between "Schema Definition" and "Generated Results", enabling one-handed editing and previewing without cramped split layouts.
- Q. What is the maximum number of records per generation?
- A. You can generate up to 1,000 records at once in browser memory. The table preview shows the first 50 rows for optimal UI responsiveness, while JSON/CSV/SQL exports contain the full dataset.
Keywords: Mock Data Generator Free / Dummy Data Generator Online / Synthetic Test Data / JSON Mock Generator / SQL INSERT Generator / UUIDv7 Generator / Japanese Dummy Names