PostgreSQL Mock Data Generator (Supports JSONB, UUID, Arrays)

Why PostgreSQL Developers Choose MockBlast

PostgreSQL has powerful, modern data types that most mock data generators don't support well. MockBlast was built with Postgres in mind:

PostgreSQL-Specific Features

MockBlast understands PostgreSQL's unique data types and constraints:

• •JSONB Columns: Generate nested JSON objects with realistic data structures.
• •UUID Types: Native UUID v4 generation for primary and foreign keys.
• •Array Types: Support for integer[], text[], and other array columns.
• •SERIAL/BIGSERIAL: Automatic sequential ID generation.
• •TIMESTAMP WITH TIMEZONE: Proper timezone-aware datetime generation.
• •Foreign Keys: Maintains referential integrity across complex schemas.

Example: PostgreSQL Schema with JSONB and UUID

CREATE TABLE users (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  name VARCHAR(100) NOT NULL,
  email VARCHAR(100) UNIQUE NOT NULL,
  metadata JSONB,
  tags TEXT[],
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

CREATE TABLE posts (
  id SERIAL PRIMARY KEY,
  user_id UUID REFERENCES users(id),
  title VARCHAR(200),
  content TEXT,
  settings JSONB,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

INSERT INTO users (id, name, email, metadata, tags, created_at) VALUES
  ('550e8400-e29b-41d4-a716-446655440000', 'John Doe', 'john@example.com', 
   '{"age": 28, "premium": true}', ARRAY['developer', 'postgres'], '2024-01-15 10:30:00+00'),
  ('6ba7b810-9dad-11d1-80b4-00c04fd430c8', 'Jane Smith', 'jane@example.com',
   '{"age": 32, "premium": false}', ARRAY['designer', 'ui'], '2024-01-16 14:20:00+00');

INSERT INTO posts (user_id, title, content, settings, created_at) VALUES
  ('550e8400-e29b-41d4-a716-446655440000', 'Getting Started with Postgres',
   'Lorem ipsum...', '{"visibility": "public", "comments": true}', '2024-01-17 08:15:00+00');

Common PostgreSQL Use Cases

How to Generate PostgreSQL Mock Data

1. 1.
   Import Your Schema: Paste your PostgreSQL CREATE TABLE statement into MockBlast. We'll parse all Postgres-specific types automatically.
2. 2.
   Configure Data Types: MockBlast automatically infers types from column names and SQL types. Adjust as needed for JSONB, UUID, or arrays.
3. 3.
   Set Row Count: Choose how many rows to generate. MockBlast handles everything from 10 rows to 1 million+.
4. 4.
   Download SQL: Get PostgreSQL-compatible INSERT statements ready to run. Copy and paste directly into psql or your migration scripts.