database-migration

Database migrations for Supabase enforce UUID primary keys, created_at/updated_at audit columns, and foreign key relationships by default. Use this Skill to structure schema changes with built-in security best practices, ensuring consistency across development, staging, and production environments without manual repetition.

Row Level Security policies restrict data access based on user identity and roles. This Skill automates RLS policy creation and enforcement, guiding you to define policies for authenticated users and service roles, ensuring unauthorized access is prevented across your tables.

PostGIS extends Supabase with spatial data types and functions for location queries. This Skill streamlines PostGIS implementation, including spatial index creation and distance queries, so you can quickly add location-based searching without manual configuration.

Structured migration organization groups changes by type—tables, views, functions, triggers, policies, indexes—ensuring predictable, repeatable deployments. This Skill enforces organization standards so migrations stay consistent and safe when moving from development through production.

Manual configuration is error-prone and time-consuming. This Skill enforces safe service role usage patterns and automates RLS policy setup, reducing common security pitfalls and ensuring every table adheres to best practices without redundant setup.