supabase-postgres-mastery
Supabase & Postgres database mastery covering Row Level Security (RLS) policies, query performance tuning, Realtime subscriptions, Edge Functions, and zero-downtime database migrations.
来源信息
- 仓库
- suphiozdedee/antigravity-skills
- 最近来源活动
- 2026年8月24日 12:50
- 检测到的 SKILL.md 语言
- 英语
- 星标
- 0
- 分支
- 0
安装方式
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
检查来源文件
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
正在显示 SKILL.md
SKILL.md
来源说明 · 只读预览- name
- supabase-postgres-mastery
- description
- Supabase & Postgres database mastery covering Row Level Security (RLS) policies, query performance tuning, Realtime subscriptions, Edge Functions, and zero-downtime database migrations.
- metadata
- {"category":"database-mastery","triggers":"supabase, postgres, row level security, rls, realtime subscriptions, edge functions, database migration"}
# Supabase & Postgres Database Mastery
This skill equips the Supreme God-Tier Council with **deep Supabase backend and Postgres database expertise**:
---
## 🛠️ Database Architecture Directives
1. **Row Level Security (RLS):** Mandatory RLS policies on all tables (`auth.uid() = user_id`).
2. **Postgres Performance:** Indexing strategy, query plan optimization (`EXPLAIN ANALYZE`), preventing table locks.
3. **Supabase Realtime & Storage:** Channel connection optimization and bucket policy security.
4. **Zero-Downtime Live Migrations:** Non-destructive schema updates for active production systems and iOS apps.
在 GitHub 查看