Generate realistic fake test data from a SQL schema and emit INSERT statements, CSV, or JSON. Parse CREATE TABLE DDL or define fields manually; per-column data types include names, emails, dates, numbers, addresses, UUIDs, IPs, ENUMs and regex patterns. FK-aware relational generation (child rows reference valid parent keys), deterministic seed for reproducible data, blank %, unique constraints, batched INSERTs, and per-dialect output (MySQL, PostgreSQL, SQLite, SQL Server). Unlimited rows, 100% client-side, no server.
100% Private Works Offline Instant
Generate realistic fake test data from a SQL schema and emit INSERT statements, CSV, or JSON. Parse CREATE TABLE DDL or define fields manually; per-column data types include names, emails, dates, numbers, addresses, UUIDs, IPs, ENUMs and regex patterns. FK-aware relational generation (child rows reference valid parent keys), deterministic seed for reproducible data, blank %, unique constraints, batched INSERTs, and per-dialect output (MySQL, PostgreSQL, SQLite, SQL Server). Unlimited rows, 100% client-side, no server. Everything runs locally in your browser — your data never leaves your device.
How to use
Enter your input in the tool above.
Adjust any options to your preference.
Use the Copy or Download buttons to save the result.
Everything happens locally — your data never leaves your browser.
The tool parses columns, types, NOT NULL, defaults, ENUM values, inline REFERENCES, table-level FOREIGN KEY clauses, PRIMARY KEY and UNIQUE constraints. Inline REFERENCES are promoted to FK relationships automatically.
Parsed tables (1)
users
7 columns · 0 FK · 1 unique
id: bigintemail: varcharfirst_name: varcharlast_name: varcharage: tinyintis_active: boolean+1 more
Column types are inferred automatically from the SQL type and column name (e.g. email → email, price → money, created_at → timestamp). To override, manually edit the parsed schema (advanced — not exposed in this UI; consider using the CREATE TABLE Generator tool to design schemas with explicit faker hints).
auto— Pick a sensible faker type from the SQL column type.
first_name— e.g. Alice
last_name— e.g. Smith
full_name— e.g. Alice Smith
email— e.g. alice.smith@example.com
username— e.g. alice.smith42
phone— e.g. +1-555-123-4567
street— e.g. 123 Main St
city— e.g. Springfield
state— e.g. IL
country— e.g. United States
zip— e.g. 62704
company— e.g. Acme Inc
job_title— e.g. Software Engineer
sentence— Lorem-ipsum short sentence
paragraph— Lorem-ipsum paragraph
url— e.g. https://example.com/page
ipv4— e.g. 192.168.1.1
ipv6— e.g. 2001:db8::1
uuid— e.g. 550e8400-e29b-41d4-a716-446655440000
date_past— ISO date in the past 30 years
date_future— ISO date in the next 5 years
date_recent— ISO date in the last 90 days
timestamp— ISO timestamp (datetime)
time— HH:MM:SS
boolean— true/false (or 0/1)
int— Random int between min/max (default 1-1000)
bigint— Random bigint between min/max
decimal— Random decimal with scale
money— Currency value e.g. 1234.56
age— Integer 18-99
hex_color— e.g. #1a2b3c
enum— Pick from enumValues with optional weights
regex— String matching the `pattern` regex
constant— Always emit `constantValue`
null— Emit NULL (only for nullable columns)
Privacy: All mock data generation runs locally. Your DDL and generated data never leave the browser. History is stored in localStorage on this device only.