Generate seed.sql for Supabase Local Development

1. 1.
   Define Your Schema: Create your tables in Supabase Studio or write migration files.
2. 2.
   Copy to MockBlast: Paste your CREATE TABLE statements into MockBlast's SQL import.
3. 3.
   Generate Seed Data: MockBlast creates realistic INSERT statements compatible with Supabase.
4. 4.
   Save as seed.sql: Download the SQL and save it to supabase/seed.sql
5. 5.
   Reset Database: Run supabase db reset to apply migrations and seed data.

Your Supabase Schema:

CREATE TABLE profiles (
  id UUID PRIMARY KEY REFERENCES auth.users(id),
  username VARCHAR(50) UNIQUE NOT NULL,
  full_name TEXT,
  avatar_url TEXT,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

CREATE TABLE posts (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  profile_id UUID REFERENCES profiles(id),
  title TEXT NOT NULL,
  content TEXT,
  published BOOLEAN DEFAULT false,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

Generated supabase/seed.sql:

-- Seed data for local development
INSERT INTO profiles (id, username, full_name, avatar_url, created_at) VALUES
  ('550e8400-e29b-41d4-a716-446655440000', 'johndoe', 'John Doe', 
   'https://avatar.example.com/john.jpg', '2024-01-15 10:30:00+00'),
  ('6ba7b810-9dad-11d1-80b4-00c04fd430c8', 'janesmith', 'Jane Smith',
   'https://avatar.example.com/jane.jpg', '2024-01-16 14:20:00+00');

INSERT INTO posts (id, profile_id, title, content, published, created_at) VALUES
  ('7c9e6679-7425-40de-944b-e07fc1f90ae7', '550e8400-e29b-41d4-a716-446655440000',
   'Getting Started with Supabase', 'Lorem ipsum...', true, '2024-01-17 08:15:00+00'),
  ('a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', '6ba7b810-9dad-11d1-80b4-00c04fd430c8',
   'Supabase Local Development', 'Lorem ipsum...', false, '2024-01-18 12:30:00+00');