How do I load fake data into PostgreSQL?

Generate the JSON here, then either INSERT row by row, expand it with json_to_recordset, or write it to a CSV and use COPY. For large volumes, call the bulk API endpoint.

Test Data for PostgreSQL

Generate realistic rows for your Postgres tables — JSON you can load with COPY, INSERT, or your ORM's bulk insert.

Need to fill a Postgres table for load testing or a demo? Generate consistent fake rows below, then bulk-load them with INSERT ... VALUES, a json_to_recordset query, or COPY from a generated file. Bump the count via the paid API to seed thousands of rows at once.

Generate now

Get this data from the API

curl "https://mock.wrapper-agency.com/api/v1/mock?type=person&count=25&locale=en"

Free mock-data API — no key during beta, up to 100 records per call. Need bulk (up to 10,000)? Use the paid endpoint. Data is fully synthetic — no real PII.

Example output

A small sample of the JSON this generator returns (person):

[
  {
    "id": "0fd32248-6492-4457-8c38-90921ffc41a7",
    "firstName": "Tracy",
    "lastName": "Miller",
    "fullName": "Tracy Miller",
    "sex": "female",
    "email": "tracy.miller15@example.com",
    "username": "tracy_miller",
    "phone": "292.735.5197 x985",
    "birthDate": "2003-10-15",
    "jobTitle": "Senior Implementation Associate",
    "avatar": "https://avatars.githubusercontent.com/u/32533033",
    "address": {
      "street": "3832 Connelly Springs",
      "city": "Fort Olinberg",
      "state": "Alabama",
      "zipCode": "77703-1863",
      "country": "Azerbaijan"
    }
  },
  {
    "id": "c786010a-58e3-46c3-8142-ecadc2e8ce51",
    "firstName": "Gail",
    "lastName": "Nienow",
    "fullName": "Gail Nienow",
    "sex": "female",
    "email": "gail_nienow47@example.com",
    "username": "gail_nienow",
    "phone": "1-880-642-1393 x573",
    "birthDate": "2006-12-06",
    "jobTitle": "Principal Functionality Analyst",
    "avatar": "https://avatars.githubusercontent.com/u/30087831",
    "address": {
      "street": "16502 E Center Street",
      "city": "South Winonaburgh",
      "state": "North Dakota",
      "zipCode": "27366-5083",
      "country": "Christmas Island"
    }
  },
  {
    "id": "e251ee4a-d883-41ee-8a55-beeca12e901a",
    "firstName": "Lorena",
    "lastName": "Armstrong",
    "fullName": "Lorena Armstrong",
    "sex": "female",
    "email": "lorena_armstrong@example.com",
    "username": "lorena.armstrong69",
    "phone": "1-666-372-3768",
    "birthDate": "1987-02-20",
    "jobTitle": "Global Security Coordinator",
    "avatar": "https://avatars.githubusercontent.com/u/26520237",
    "address": {
      "street": "93867 Mayer Locks",
      "city": "Lake Dylantown",
      "state": "North Carolina",
      "zipCode": "99930",
      "country": "Uganda"
    }
  }
]

Use it in code

Fetch the same data from the free API — no key needed during beta, up to 100 records per call:

curl "https://mock.wrapper-agency.com/api/v1/mock?type=person&count=25"

Need thousands of rows at once? The bulk API returns up to 10,000 records per call.

FAQ

How do I load fake data into PostgreSQL?: Generate the JSON here, then either INSERT row by row, expand it with json_to_recordset, or write it to a CSV and use COPY. For large volumes, call the bulk API endpoint.

Other generators

Fake Person Data Generator

person

Fake Email Address Generator

Fake Name Generator

fullName

Fake Company Data Generator

company

Fake Address Generator

address

UUID Generator

uuid

Fake Product Data Generator

product

Fake Credit Card Number Generator (Test)

creditCardFake

MockForge generates fully synthetic data — no real personal information, ever.