What problem does it solve? Writing Supabase migrations by hand often leads to missing Row Level Security policies, undocumented tables, inconsistent naming, and schema drift that breaks shared databases. This Skill enforces the ICONSA team's migration conventions so every DDL change is safe, documented, and reviewable. ## Core Features & Use Cases - Convention-enforced DDL: Generates CREATE TABLE, ALTER TABLE, CREATE POLICY, CREATE TRIGGER, and seed INSERT statements with mandatory RLS, COMMENT ON TABLE, updated_at triggers, and timestamptz columns. - Pre-flight safety checks: Verifies backlog blockers in docs/STATUS.md, confirms schema design approval, and prevents dangerous operations like DROP SCHEMA on the shared project without explicit confirmation. - Helper reuse and review workflow: Reuses existing hr.* helper functions instead of redefining them, runs Supabase advisors and reviewer subagents, and requires a CHANGELOG entry before completion. - Use Case: When asked to add a new table for HR ticket attachments, the Skill produces a numbered migration with RLS policies using hr.is_hr_admin(), comments, and a matching CHANGELOG entry. ## Quick Start Ask the agent to create a Supabase migration for a new table or schema change, for example: create a migration adding an attachments table with RLS policies.
