| 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
- Reads migration from
supabase/migrations/
- Connects to Supabase using
.env.local credentials
- Executes SQL via direct PostgreSQL connection
- Verifies created tables/columns
- 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