apply-migration

Apply SQL migration files to JusticeHub Supabase database with verification and error handling.

Stars 163

Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/apply-migration

SKILL.md

Apply Database Migration

Invocation: /apply-migration <migration-file>

Usage

bash

/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

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

Search AI Tools