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

•

Database Management

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

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.

Key Features

01Built-in Row Level Security (RLS) policy templates for secure data access

021 GitHub stars

03Automated migration file generation with standardized timestamp naming

04Remote migration status tracking and environment repair tools

05Local database testing and environment reset workflows via Supabase CLI

06Safe schema modification patterns for columns, indexes, and constraints

Use Cases

01Initializing new database tables with predefined security policies and relationships

02Synchronizing local development database states with production using migration versioning

03Executing zero-downtime schema updates like adding nullable columns or new indexes

Key Features

01Built-in Row Level Security (RLS) policy templates for secure data access

021 GitHub stars

03Automated migration file generation with standardized timestamp naming

04Remote migration status tracking and environment repair tools

05Local database testing and environment reset workflows via Supabase CLI

06Safe schema modification patterns for columns, indexes, and constraints

Use Cases

01Initializing new database tables with predefined security policies and relationships

02Synchronizing local development database states with production using migration versioning

03Executing zero-downtime schema updates like adding nullable columns or new indexes