Name: supabase-arch
Author: YuDefine

Imported from YuDefine/nuxt-supabase-starter (template/.claude/skills/supabase-arch/SKILL.md). Install upstream with npx skills add YuDefine/nuxt-supabase-starter --skill supabase-arch. Copyright stays with the author.

Supabase 架構決策指南

資料存取模式已定義在 CLAUDE.md（Client 讀、Server 寫）。本 skill 提供架構決策指引。

Schema 邊界

core / auth: 授權相關（user_roles、allowed_emails、user_preferences、enum、函式）
app / 專案名稱: 業務資料表
public: 不存放業務資料；SDK 查詢使用 client.schema('core') 或 client.schema('app')

快速決策表

場景	方案
簡單 CRUD	Client SDK + RLS
跨表交易	Postgres RPC
第三方 API	Edge Function
Webhook	Edge Function
排程任務（DB 內部）	pg_cron
排程任務（外部邏輯）	Edge Function + Cron
即時更新	SDK + Realtime
複雜統計	Materialized View + pg_cron
權限繞過	RPC (Security Definer)
檔案處理	Edge Function (Stream)
敏感金鑰	Edge Function (環境變數)

需要更詳細的決策指引？→ references/decision-tree.md

效能評估

High Concurrency (>100 req/s)：讀取密集加 Redis/CDN 快取，寫入密集用 Message Queue
Standard：遵循快速決策表

檢查清單

安全性

RLS First：所有 Table 預設開啟 RLS
Never Trust Client：前端資料在 DB/Edge 層驗證
Service Role：僅在 Edge Function 或 RPC 內部使用

效能

Filter/Join 欄位建立 Index
避免 select('*')，明確指定欄位
外部請求設定 Timeout

Install supabase-arch and it becomes one more candidate the router can pick - when it fits.

A listing is a routing target with a manifest: what it does, which domains it covers, what it costs and who publishes it. Once installed it sits beside your own models and tools, is scored like any other candidate for each request, and shows up in the trace when it wins. Ratings come from workspaces that installed it, one per account.

{ "ocm": "1", "id": "yudefine-nuxt-supabase-starter-supabase-arch", "kind": "skill", "name": "supabase-arch", "description": "Supabase 架構決策指南。Use when planning new features, deciding between RPC vs Edge Function, choosing tech approaches, or asking architecture questions. Always use this skill for Supabase architecture decisions and technology routing.", "publisher": "YuDefine", "version": "1.0.0", "capabilities": { "domains": [ "coding" ], "tags": [ "skill-md", "github" ], "languages": [ "en" ] }, "quality_prior": 0.6, "examples": [ "Supabase 架構決策指南。Use when planning new features, deciding between RPC vs Edge Function, choosing tech approaches, or asking architecture questions. Always use this skill for Supabase architecture decisions and technology routing." ], "primary": false, "metadata": { "source": { "provider": "github", "repository": "https://github.com/YuDefine/nuxt-supabase-starter", "path": "template/.claude/skills/supabase-arch/SKILL.md", "ref": "3db2f949055de0ef6d5c38064cadf9267ad17869", "url": "https://github.com/YuDefine/nuxt-supabase-starter/blob/3db2f949055de0ef6d5c38064cadf9267ad17869/template/.claude/skills/supabase-arch/SKILL.md", "key": "YuDefine/nuxt-supabase-starter/template/.claude/skills/supabase-arch/SKILL.md" } }, "instructions": "# Supabase 架構決策指南\n\n資料存取模式已定義在 CLAUDE.md（Client 讀、Server 寫）。本 skill 提供架構決策指引。\n\n## Schema 邊界\n\n- **core / auth**: 授權相關（user_roles、allowed_emails、user_preferences、enum、函式）\n- **app / 專案名稱**: 業務資料表\n- **public**: 不存放業務資料；SDK 查詢使用 `client.schema('core')` 或 `client.schema('app')`\n\n## 快速決策表\n\n| 場景 | 方案 |\n| -------------------- | --------------------------- |\n| 簡單 CRUD | Client SDK + RLS |\n| 跨表交易 | Postgres RPC |\n| 第三方 API | Edge Function |\n| Webhook | Edge Function |\n", "cost": { "context_tokens": 338 } }

supabase-arch

About

Supabase 架構決策指南

Schema 邊界

快速決策表

效能評估

檢查清單

安全性

效能

Install supabase-arch and it becomes one more candidate the router can pick - when it fits.

Use it

Manifest

Reviews