Apply Database Migration

Apply Database Migration

Invocation: /​apply-migration <migration-file>

Usage

/​apply-migration 20260102_alma_unification_links.sql

How It Works

1. Reads migration from supabase/​migrations/
2. Connects to Supabase using .env.local credentials
3. Executes SQL via direct PostgreSQL connection
4. Verifies created tables/​columns
5. Logs success/​failure

Prerequisites

• .env.local with NEXT_PUBLIC_SUPABASE_URL, SUPABASE_DB_PASSWORD
• Migration file in supabase/​migrations/
• pg library installed

Connection

postgresql://postgres:PASSWORD@HOST:6543/​postgres

Fallback to session pooler if direct fails.

Success Output

✅ Migration executed successfully!
🔍 Verifying tables...
   ✅ article_related_interventions
   ✅ alma_intervention_profiles
🎉 Migration Complete!

Failure Output

❌ Error: syntax error at or near "CRATE"

📋 Manual alternative:
   1. Open Supabase Dashboard → SQL Editor
   2. Copy from: supabase/​migrations/​bad_migration.sql
   3. Fix syntax and run

Safety Features

• Transaction safety
• Idempotent checks (IF NOT EXISTS)
• Proper connection cleanup
• Backup reminder

Files

• Script: scripts/​apply-migration-skill.mjs
• Migrations: supabase/​migrations/​*.sql

Related

• /​create-migration - Generate new migration
• /​verify-schema - Check database schema