Why are RLS policies and grants grouped together in this skill?

Missing either a policy or a grant leads to silent failures where no rows are returned or permissions are denied; this skill ensures RLS is enabled, policies are created, and grants are issued as a complete unit.

How does this skill handle failed migrations?

It follows transactional rollback principles, ensuring that fix migrations include all necessary statements from the original to restore a consistent state rather than relying on partial successes.

Can I use this for seed data?

Yes, the skill provides patterns for 'Seed Data FK Safety' to prevent migration rollbacks caused by missing foreign key references during data insertion.

Does this skill help with PostgreSQL index errors?

Yes, it specifically prevents common errors related to STABLE functions like now() in partial index WHERE clauses by enforcing the use of IMMUTABLE constraints or trailing index columns.

Migration Safety & Reliability

Name: Migration Safety & Reliability
Author: Undercurrent-Studio

byUndercurrent-Studio

0•

데이터베이스 관리

Safeguards database schema changes with idempotent patterns and PostgreSQL best practices to prevent migration failures and data loss.

Migration Safety is a specialized Claude Code skill designed for developers working with Supabase and PostgreSQL. It enforces high-integrity database evolution by implementing defensive coding patterns such as idempotent IF NOT EXISTS clauses, proper Row-Level Security (RLS) configuration, and transactional rollback handling. By applying learned lessons from real-world production incidents, this skill helps Claude write, review, and debug migrations that are resilient to failures, ensuring that data types, constraints, and security policies are applied correctly and consistently across all environments.

주요 기능

01Validates function immutability for partial indexes to prevent PostgreSQL errors

02Implements idempotent IF NOT EXISTS patterns for tables, columns, and indexes

03Automates Row-Level Security (RLS) setup including policies and grants

04Manages dual-name constraint dropping to handle PostgreSQL default naming conventions

050 GitHub stars

06Ensures seed data integrity with foreign key existence guards

사용 사례

01Writing new Supabase migrations with complex table relationships and security policies

02Standardizing data types like BIGINT vs NUMERIC for high-precision financial data

03Debugging and fixing migrations that failed or partially rolled back in production

주요 기능

01Validates function immutability for partial indexes to prevent PostgreSQL errors

02Implements idempotent IF NOT EXISTS patterns for tables, columns, and indexes

03Automates Row-Level Security (RLS) setup including policies and grants

04Manages dual-name constraint dropping to handle PostgreSQL default naming conventions

050 GitHub stars

06Ensures seed data integrity with foreign key existence guards

사용 사례

01Writing new Supabase migrations with complex table relationships and security policies

02Standardizing data types like BIGINT vs NUMERIC for high-precision financial data

03Debugging and fixing migrations that failed or partially rolled back in production