supabase-migration-writer

What problem does it solve?

This Skill streamlines the complex and error-prone process of managing Supabase database schemas, ensuring data integrity and application stability.

Core Features & Use Cases

• Database Migrations: Create, apply, and rollback SQL migrations for Supabase.
• Schema Management: Add or modify tables, columns, and Row Level Security (RLS) policies.
• RPC Functions: Define and manage server-side functions for data operations.
• Type Synchronization: Ensures frontend TypeScript types stay in sync with the database schema.
• Use Case: When adding a new user_preferences table with RLS policies, this Skill guides you through writing the SQL migration, creating the necessary RLS, and updating the generated TypeScript types to prevent build errors.

Quick Start

Use the supabase-migration-writer skill to create a new SQL migration file for adding a 'user_notes' table with 'user_id', 'content', and 'created_at' columns, including RLS policies for user-specific access.