Supabase Schema & RLS Pack

Multi-tenant Postgres schema patterns and a real RLS policy library — not the toy examples in the docs.

Everything Chris has learned modelling multi-tenant Postgres for Sovren Sports and TradePass, distilled into a SKILL.md the AI can lean on.

キットの内容

• Tenant model decisions — schema-per-tenant vs. tenant_id column with worked tradeoffs
• Reusable RLS helper functions: is_member_of, has_role, is_owner
• Policy patterns: public read, member read, owner write, service-role bypass
• Migration discipline — review checklist + rollback recipes
• An auditable seed pattern that survives staging refreshes

受け取るファイル

すべてのキットには4つの標準フォーマット — SKILL.md、最適化パック、Custom GPT用プロンプト、プラットフォーム別クイックスタート — に加えて、このキット専用のリファレンス資料が付属します。

• · SKILL.md
• · memory.md
• · optimization-pack.md
• · custom-gpt-instructions.md
• · quick-start.md
• · patterns/tenant-models.md
• · patterns/rls-policy-library.md
• · patterns/migration-discipline.md
• · examples/0001_init_example.sql