Apply SQL migrations to Supabase databases

Apply and verify SQL database migrations

Applying schema changes to Supabase with transactional safety and verification logging.

• · Migration file path (.sql)
• · .env.local with Supabase credentials

• · Migration executed and verified, created tables/columns logged, success/failure report

• · Supabase PostgreSQL
• · pg library (Node.js)
• · Environment variables (NEXT_PUBLIC_SUPABASE_URL, SUPABASE_DB_PASSWORD)

Migration file in supabase/migrations/ directory; .env.local configured; Supabase account accessible

SQL syntax error halts execution; connection timeout if network blocked; idempotency not guaranteed if IF NOT EXISTS missing

• · Transaction safety with error rollback
• · Backup reminder included
• · Manual fallback instructions for failed migrations