create-migration

name	create-migration
description	Scaffold a new timestamped Supabase migration file in supabase/migrations/
disable-model-invocation	true

Create Migration

Scaffold a new Supabase migration file with a timestamped filename and boilerplate template.

Arguments

A short snake_case migration name (e.g., add_waitlist_table, create_notifications).

Steps

1. Generate a timestamp in YYYYMMDDHHMMSS format using the current UTC time
2. Create the migration file at supabase/migrations/<timestamp>_<name>.sql
3. Populate with the template below
4. Open the file for editing

Template

-- Migration: <name>
-- Created: <ISO 8601 timestamp>

-- TODO: Add your migration SQL here

-- REMINDER: If this migration creates or modifies a table, consider:
-- 1. Row-Level Security (RLS) — enable RLS and add policies scoped to club_id
-- 2. Indexes — add indexes for columns used in WHERE/JOIN clauses
-- 3. Foreign keys — ensure referential integrity with ON DELETE behavior

-- To validate: supabase db diff
-- To apply locally: supabase db reset

After Creating

Report the file path and remind the user to:

• Write the migration SQL
• Run supabase db diff to validate
• Run supabase db reset to apply locally and verify