db-domain-modeling

Start by identifying core entities, their attributes, and relationships through structured questions, then map each entity to a table with UUID primary keys, foreign keys, and constraints. This Skill walks through that process step by step and outputs a schema document plus a migration file.

Create a junction table with foreign keys to both entities, a composite primary key on the pair, and indexes on both columns for bidirectional queries. Optional attributes like role or priority can be stored directly on the junction table.

Yes, the session generates RLS policies for Supabase, including per-user isolation using auth.uid(), admin override policies via JWT role claims, and public-read/authenticated-write patterns. It also covers multi-tenant organization isolation.

Business rules are translated into CHECK constraints, UNIQUE constraints, and triggers. Examples include preventing negative order totals, requiring titles on published posts, and blocking updates to soft-deleted records via a trigger function.

Connection failures are handled with retry logic using exponential backoff up to three attempts. Query syntax errors return detailed messages with suggested fixes, and transaction failures roll back automatically to preserve data integrity.