supabase-database-migration

What problem does it solve?

This Skill ensures your Supabase database schema, Drizzle ORM definitions, and local development environment remain synchronized using a robust schema-first workflow, preventing drift and deployment issues.

Core Features & Use Cases

• Schema Synchronization: Automatically generates SQL migrations from Drizzle schema definitions.
• Local Database Management: Provides commands to apply new migrations or reset the local database to a clean state.
• Deployment Workflow: Guides the process of pushing schema changes to remote Supabase projects.
• Use Case: When adding a new 'users' table with columns for 'id', 'email', and 'created_at', this skill will generate the necessary SQL migration, allow you to test it locally, and then deploy it to your production Supabase instance.

Quick Start

Use the supabase-database-migration skill to generate a new migration file from your Drizzle schema changes.