Supabase Migration Deep Dive

What it does

This skill provides a deep dive into Supabase migrations, enabling you to understand and execute database schema changes effectively. It allows for the creation, execution, and rollback of migration files within a Supabase project. The skill facilitates managing complex database transformations with version control and automated deployment capabilities.

When to use it

• You need to update your Supabase database schema (e.g., adding new tables or columns).
• You want to automate the process of applying database changes across different environments (development, staging, production).
• You're troubleshooting issues related to database migrations and need assistance with rollback procedures.
• You are collaborating on a project where multiple developers manage the Supabase schema.

Key capabilities

• Creation of new migration files
• Execution of pending migrations
• Rollback of applied migrations
• Management of migration versions

Example prompts

• "Create a new migration file to add a 'status' column to the 'orders' table."
• "Run all pending Supabase migrations."
• "Roll back the last applied migration."

Tips & gotchas

This skill requires familiarity with basic SQL and the structure of a Supabase project. Ensure your environment is properly configured with access to your Supabase database before using this skill.