Does this skill work with the Supabase CLI?

Yes, it is designed to work alongside the Supabase CLI, leveraging commands like 'migration new', 'db reset', and 'db push' for a standard workflow.

What should I do if my production migration is out of sync?

The skill provides guidance on using the 'migration repair' command to manually mark migrations as applied and resolve versioning conflicts.

How does this skill handle existing database data?

The skill follows safe modification patterns, such as adding nullable columns before applying constraints, to ensure schema changes don't cause data loss or migration failures.

Can it help me with Row Level Security (RLS)?

Yes, it includes specific patterns for enabling RLS on tables and creating policies that restrict access based on authenticated user IDs.

Does it support local development testing?

Absolutely. The workflow emphasizes testing migrations locally using 'npx supabase db reset' to ensure SQL scripts are valid before they are pushed to live environments.

Supabase Migrations & Schema Management

Name: Supabase Migrations & Schema Management
Author: JaveedIshaq

byJaveedIshaq

•

Gestión de Bases de Datos

Manages Supabase database schemas and migrations through automated CLI commands and best-practice SQL patterns.

Acerca de

This skill streamlines the database development lifecycle within the Supabase ecosystem, enabling Claude to generate, test, and deploy schema migrations safely. It facilitates the creation of version-controlled migration files, the implementation of Row Level Security (RLS) policies, and the execution of complex schema changes like adding columns or indexes. By enforcing a test-driven local development workflow, it helps developers maintain database integrity and minimize risks when pushing changes to production environments.

Características Principales

Built-in Row Level Security (RLS) policy templates for secure data access
1 GitHub stars
Automated migration file generation with standardized timestamp naming
Remote migration status tracking and environment repair tools
Local database testing and environment reset workflows via Supabase CLI
Safe schema modification patterns for columns, indexes, and constraints

Casos de Uso

Initializing new database tables with predefined security policies and relationships
Synchronizing local development database states with production using migration versioning
Executing zero-downtime schema updates like adding nullable columns or new indexes

Acerca de

Características Principales

Built-in Row Level Security (RLS) policy templates for secure data access
1 GitHub stars
Automated migration file generation with standardized timestamp naming
Remote migration status tracking and environment repair tools
Local database testing and environment reset workflows via Supabase CLI
Safe schema modification patterns for columns, indexes, and constraints

Casos de Uso

Initializing new database tables with predefined security policies and relationships
Synchronizing local development database states with production using migration versioning
Executing zero-downtime schema updates like adding nullable columns or new indexes