apply-migration

Automating SQL migrations against a Supabase database requires running migration files transactionally with safety checks and rollback reminders to prevent partial deployments. This Skill executes scripts from the supabase/migrations directory inside a transaction using the pg library and environment credentials.

Transactional migration execution runs SQL schema changes within a single database transaction, ensuring that all operations succeed or fail together. This mechanism prevents partial deployments and keeps the PostgreSQL database schema consistent if an error occurs during execution.

Verifying database schema changes after applying SQL migrations involves validating that expected tables and columns exist in the database. This Skill performs schema verification post-migration to confirm the Supabase database structure matches the intended outcome.

Applying PostgreSQL migrations with this Skill requires the pg library and proper environment variables configured for database access. These dependencies provide the necessary connection layer to authenticate and execute SQL scripts against the Supabase database.

Deploying schema changes across development, staging, and production workflows is supported by this Skill. It applies SQL migrations and verifies changes specifically for environments like the JusticeHub Supabase backend, ensuring consistent schema updates across different deployment stages.