apply-migration

name	apply-migration
description	Apply SQL migration files to JusticeHub Supabase database with verification and error handling.

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