supabase-db
Supabase项目的PostgreSQL约定概述。当需要时使用:(1) 数据库设计原则概述,(2) 理解紧配合设计理念,(3) 标准表结构快速参考
📖 中文导读:Supabase项目的PostgreSQL约定概述。当需要时使用:(1) 数据库设计原则概述,(2) 理解紧配合设计理念,(3) 标准表结构快速参考 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: supabase-db description: "PostgreSQL conventions overview for Supabase projects. Use when: (1) Need overview of database design principles, (2) Understanding tight-fit design philosophy, (3) Quick reference for standard table structure" license: Proprietary. LICENSE.txt has complete terms
PostgreSQL Conventions for Supabase
Overview of database design principles for Supabase projects.
Environment: PostgreSQL 17 on Supabase.
Key Principles
- Consistency - All objects follow predictable naming patterns
- Self-documenting - Names indicate purpose and type
- Type safety - Suffixes indicate data types
- Tight-fit design - Only add confirmed requirements
Tight-Fit Design
MUST NOT add speculative columns:
| Don't Add Speculatively | Add When |
|---|---|
deleted_at |
Soft delete confirmed |
created_by, updated_by |
Audit trail required |
metadata jsonb |
Flexible data needed |
| Indexes | Query patterns known |
Standard Table Structure
CREATE TABLE tb_examples (
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
);
Related Skills
| Skill | Use For |
|---|---|
| supabase-migration | Creating migrations, naming conventions, security patterns |
| supabase-seeding | Populating test data, bulk loading |
| supabase-bootstrap | Setting up new projects, tooling config |