(Describe the specific person here)

(Sum up the pain in one sentence)

(Describe the successful outcome)

1.
2.
3.
4.
5.
6.
7.
8.

ENTITY:
Attributes:
Why needed: (journey step #)
Relationships:

ENTITY:
Attributes:
Why needed: (journey step #)
Relationships:

You are a senior database architect specializing in PostgreSQL and Supabase.

CONTEXT:
I'm building an MVP for: [PASTE YOUR PROBLEM STATEMENT FROM STEP 1]

The core user journey is:
[PASTE YOUR MVP USER JOURNEY FROM STEP 2]

DATA REQUIREMENTS:
[PASTE YOUR DATA REQUIREMENTS FROM STEP 3]

TASK:
Generate a complete SQL schema for Supabase (PostgreSQL) that:

1. Creates all necessary tables with appropriate data types
2. Includes primary keys (UUID preferred for main entities)
3. Includes foreign keys with proper constraints:
   - Use ON DELETE CASCADE where child records should be deleted with parent
   - Use ON DELETE SET NULL where we just want to unset the reference
4. Includes indexes on columns that will be frequently queried or filtered
5. Includes created_at and updated_at timestamps (with automatic triggers for updated_at)
6. Uses Row Level Security (RLS) appropriate for an MVP (enable RLS but leave policies for later)
7. Follows PostgreSQL and Supabase best practices

SPECIFIC REQUIREMENTS:
[List any specific data types, constraints, or relationships you want]
Example:
- Use DATE for event_date, TIME for event_time
- Use VARCHAR(255) for names and emails
- Add CHECK constraints for status fields
- Expected load: <100 records per month

CONSTRAINTS:
- This is a free tier Supabase project (keep schema efficient)
- [Add any other constraints about authentication, user load, etc.]

OUTPUT FORMAT:
Provide a single, complete SQL script that I can copy and paste into the Supabase SQL Editor.
Include comments explaining each table's purpose.
Include the updated_at trigger function and triggers for all tables.

You are an expert frontend engineer specializing in Next.js, React, TypeScript, and Tailwind CSS.

CONTEXT:
I'm building an MVP for: [PASTE YOUR PROBLEM STATEMENT]

The target user is: [PASTE WHO HAS THE PROBLEM]

MVP USER JOURNEY:
[PASTE YOUR USER JOURNEY]

DATA AVAILABLE:
I have a Supabase PostgreSQL database with the following tables:
[List your table names and key columns—don't paste entire SQL, just structure]

Example format:
- events (id, organizer_name, organizer_email, event_name, event_date, status)
- invitations (id, event_id, invitee_email, response_status)
- dietary_preferences (id, invitation_id, is_vegetarian, is_vegan, allergies)

TASK:
Generate a complete Next.js application that implements the above user journey.

REQUIREMENTS:

UI/UX:
- Modern, clean design using Tailwind CSS
- Mobile-first responsive design
- Clear visual hierarchy and intuitive navigation
- Loading states for data fetching
- Error states with helpful messages
- [Add design preference: "Minimalist" / "Playful and colorful" / "Professional SaaS"]

Technical:
- Next.js 14+ with App Router
- TypeScript for type safety
- Supabase client for database queries
- Server components where appropriate, client components for interactivity
- Form validation where needed
- Optimistic UI updates for better UX

Pages/Components Needed:
[Based on your user journey, list main pages]

Example:
1. Landing/Event Creation page (step 1)
2. Invitation Response page (steps 2-3)
3. Organizer Dashboard (step 4)
4. Restaurant Selection page (step 5)
5. Confirmation page (steps 6-7)

Key Features:
[Translate each journey step into feature requirements]

Example:
- Event creation form with date/time pickers and email input
- RSVP form with dietary restriction checkboxes
- Real-time dashboard showing all responses
- Restaurant card display with selection buttons
- Email notification triggers (can be placeholder for MVP)

STYLING PREFERENCES:
- Color scheme: [e.g., "Professional blues and grays" / "Warm earth tones"]
- Typography: [e.g., "Clean sans-serif, high readability"]
- Overall feel: [e.g., "Polished SaaS tool" / "Fun consumer app"]

CONSTRAINTS:
- This is an MVP—prioritize core functionality over polish
- Free tier Supabase (optimize queries)
- [Add any other constraints: "No authentication yet" / "Mobile-only" / etc.]

OUTPUT:
Generate the complete application code, including:
- All page components
- Reusable UI components
- Supabase client setup
- TypeScript types based on database schema
- Basic error handling

The code should be immediately deployable to Vercel and connectable to my Supabase project.

NEXT_PUBLIC_SUPABASE_URL=your-project-url
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key

Example: "No user authentication yet—just unique URLs"
Example: "No payment processing—just contact forms"

Your simplifications:
-
-
-

What went well:


What was frustrating:


What I'll do differently next time:


Questions to research later: