How does this skill ensure database safety?

It uses a mandatory 4-phase workflow including risk assessment, validation queries, and pre-defined rollback scripts before applying any changes to your Supabase instance.

Can it handle large production tables?

Yes, it includes specialized backfill strategies and patterns like CREATE INDEX CONCURRENTLY to handle tables with over 100,000 rows without locking production data.

Does it support Row Level Security (RLS)?

Absolutely. It audits every new table for RLS, verifies policies for different roles (anon vs service_role), and uses Supabase advisors to check for security gaps.

What happens if a migration fails?

The skill requires a rollback plan to be prepared in the Planning phase, allowing for quick recovery if the execution phase encounters errors or unexpected behavior.

Supabase DB Migration & RLS Security

Name: Supabase DB Migration & RLS Security
Author: ak125

byak125

0•

Gestión de Bases de Datos

Manages Supabase database migrations with built-in RLS auditing, schema validation, and safe DDL execution workflows.

The Database Migration skill provides a robust framework for handling Supabase schema changes safely and efficiently. It enforces a mandatory four-phase workflow—Analysis, Planning, Execution, and Verification—to minimize downtime and prevent data loss. By providing automated risk assessment for DDL operations, pre-written rollback templates, and specialized batching strategies for large tables, it ensures that database evolutions remain secure and performant. Additionally, it integrates deep security checks for Row Level Security (RLS) and performance advisors to maintain a production-ready database environment.

Características Principales

010 GitHub stars

02Built-in rollback template generation for all schema changes

03Four-phase migration workflow (Analyse, Plan, Execute, Verify)

04Risk classification for DDL operations to prevent accidental downtime

05Automated RLS (Row Level Security) auditing and policy generation

06Safe backfill strategies for large-scale tables using batching

Casos de Uso

01Auditing and enforcing Row Level Security (RLS) for data privacy

02Performing zero-downtime index creation on high-traffic database tables

03Adding new features that require complex schema changes or new tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ak125/nestjs-remix-monorepo db-migration

For use in Claude.ai and ChatGPT

Características Principales

010 GitHub stars

02Built-in rollback template generation for all schema changes

03Four-phase migration workflow (Analyse, Plan, Execute, Verify)

04Risk classification for DDL operations to prevent accidental downtime

05Automated RLS (Row Level Security) auditing and policy generation

06Safe backfill strategies for large-scale tables using batching

Casos de Uso

01Auditing and enforcing Row Level Security (RLS) for data privacy

02Performing zero-downtime index creation on high-traffic database tables

03Adding new features that require complex schema changes or new tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ak125/nestjs-remix-monorepo db-migration

For use in Claude.ai and ChatGPT