OpenSkillIndex← back to search
claude-codedevops

Claude-skill-registry apply-migration

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

install
source · Clone the upstream repo
git clone https://github.com/majiayu000/claude-skill-registry
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/apply-migration" ~/.claude/skills/majiayu000-claude-skill-registry-apply-migration && rm -rf "$T"
manifest: skills/data/apply-migration/SKILL.md
tags
#database#sql#supabase#migration#automation
safety · automated scan (low risk)
This is a pattern-based risk scan, not a security review. Our crawler flagged:
  • references .env files
Always read a skill's source content before installing. Patterns alone don't mean the skill is malicious — but they warrant attention.
source content

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