migration

Create a new Supabase migration with RLS policies, update the hand-written Database types and the data model doc. Use for any schema change.

SKILL.md

GitHub
  1. Create supabase/migrations/<YYYYMMDDHHMMSS>_<snake_name>.sql (UTC timestamp). Never edit an existing migration.
  2. In the file: tables with venue_id + FK + created_at/updated_at, the set_updated_at trigger, indexes for every FK you will filter on, enable row level security, and policies using public.is_venue_staff(...) / public.is_night_participant(...). If the UI subscribes to the table, add it to supabase_realtime. End with a -- down: comment describing manual rollback.
  3. Update packages/db/src/database.types.ts: add the Row interface and the Tables entry.
  4. Update docs/DATA_MODEL.md: column table, RLS summary, and the Mermaid diagram.
  5. If Docker is available: pnpm db:reset and then pnpm db:types to regenerate types and confirm they match your hand-written version. If not, say so in the PR.
  6. Run pnpm check.

Related in data

electron-chromium-upgrade-electron-electron

Guide for performing Chromium version upgrades in the Electron project. Use when working on the roller/chromium/main bra...

by electron
119,879

qiuzhi

指导Claude按照二哥的风格撰写求职类文章，包括公司薪资爆料、年终奖盘点、求职攻略、offer选择建议等内容。

by itwanger
16,619

awesome-ai-agents-illacloud-illa-builder

The chat will provide safety guides, equipment suggestions, reviews, and techniques, with context-driven summary and mul...

by illacloud
12,356