Database Migration Skill - Supabase PostgreSQL

What problem does it solve?

This Skill provides expert guidance and reusable patterns for managing Supabase PostgreSQL database migrations, ensuring data integrity, security, and efficient schema evolution.

Core Features & Use Cases

• Migration Templates: Standardized SQL templates for creating tables, indexes, triggers, and RLS policies.
• RLS Policy Patterns: Pre-built Row Level Security policies for common access control scenarios (user-owned, role-based, related resources).
• Indexing Strategies: Guidance on optimizing query performance through effective indexing.
• Use Case: When adding a new feature that requires a new table, use the provided template to create the table, define necessary indexes, and implement robust RLS policies to secure the data from the outset.

Quick Start

Use the database migration skill to create a new table for user profiles with standard timestamps and RLS policies.