💙 Supporting healthcare non-profits: Metadataloop is free for 6–12 months. Contact Us to get started.
Free Online Tool

Mock Data Generator for PostgreSQL

Paste a CREATE TABLE, get realistic seed rows as CSV, JSON, or PostgreSQL INSERT statements.

Open the Mock Data Generator →

Overview

Filling a Postgres dev or test database with realistic data is tedious. MetaDataLoop's mock data generator reads your CREATE TABLE and produces context-aware values: people-shaped tables get real first/last names, email columns get RFC-5322-valid addresses, date columns get plausible recent dates, and numeric columns honor your NUMERIC(p,s) precision.

What you get

✓ INCLUDED
Reads PostgreSQL DDL: SERIAL, INT, BIGINT, NUMERIC, BOOLEAN, DATE, TIMESTAMP, UUID, VARCHAR, TEXT
✓ INCLUDED
Smart values: names, emails, addresses, phone numbers, IPs, URLs
✓ INCLUDED
NUMERIC precision honored — no overflow on (10,2)
✓ INCLUDED
Output: CSV, JSON array, or PostgreSQL INSERT INTO ... VALUES ...
✓ INCLUDED
Generate 10 to 1000 rows in one click

Example

Input
CREATE TABLE customers (
    id SERIAL PRIMARY KEY,
    email VARCHAR(255) NOT NULL,
    full_name VARCHAR(100),
    signup_date DATE,
    balance NUMERIC(10,2)
);
Output
INSERT INTO customers (email, full_name, signup_date, balance) VALUES
  ('alice.morgan@gmail.com', 'Alice Morgan', '2024-02-12', 1042.50),
  ('bob.kim@outlook.com',    'Bob Kim',      '2024-02-19',   89.00),
  ('chen.li@yahoo.com',      'Chen Li',      '2024-03-03',  500.25);

Frequently asked questions

Will it respect NOT NULL?
Yes — every NOT NULL column always gets a value. Nullable columns are filled with NULL ~10% of the time for realism.
Does it handle FK constraints?
Foreign keys are not auto-resolved across tables. Generate the parent rows first, then use those PKs in the child generator (paste matching VALUES into the FK column).
Can I paste the output directly into psql?
Yes. Choose 'INSERT' output, copy, and paste into psql or PgAdmin's query window.

Try it now

No signup, no install — runs entirely in your browser.

Open the Mock Data Generator →

⚠ Confirm Delete