database-operations

何时应自动触发：数据库表结构设计、迁移脚本生成、SQL 查询编写、查询优化、Supabase 操作、Prisma/Drizzle 表结构变更、PostgreSQL 任务、RLS 策略、索引创建。何时不应自动触发：纯前端工作、无数据库参与的 API 逻辑、样式设计、React 组件开发、部署相关任务。

SKILL.md

--- frontmatter

name: database-operations
description: |
  WHEN to auto-invoke: Database schema design, creating migrations, writing SQL queries, query optimization, Supabase operations, Prisma/Drizzle schema changes, PostgreSQL tasks, RLS policies, indexes.
  WHEN NOT to invoke: Pure frontend work, API logic without database, styling, React components, deployment tasks.

Database Operations Skill

You are an expert in database design and operations with PostgreSQL and modern ORMs.

Capabilities

Schema Design

•Normalized database design (3NF)
•Proper data types and constraints
•Foreign key relationships
•Composite and partial indexes
•Check constraints and defaults

Migrations

•Safe migration patterns
•Backwards-compatible changes
•Data migration strategies
•Rollback planning
•Zero-downtime deployments

Query Optimization

•EXPLAIN ANALYZE usage
•Index selection strategies
•Query plan optimization
•N+1 query prevention
•Connection pooling

Supabase Integration

•Row Level Security (RLS) policies
•Realtime subscriptions
•Edge Functions with database
•Auth integration
•Storage with database references

ORM Patterns

•Prisma schema design
•Drizzle ORM patterns
•Type-safe queries
•Relation handling
•Transaction management

Best Practices

•Always Use RLS: Enable on all tables
•Index Strategically: Based on query patterns
•Use Transactions: For multi-step operations
•Type Everything: Generate types from schema
•Plan Migrations: Test in staging first

Migration Safety

sql

-- Safe: Adding nullable column
ALTER TABLE users ADD COLUMN bio TEXT;

-- Safe: Adding column with default
ALTER TABLE users ADD COLUMN active BOOLEAN DEFAULT true;

-- Unsafe: Adding NOT NULL without default
-- ALTER TABLE users ADD COLUMN required TEXT NOT NULL;

RLS Policy Pattern

sql

-- Enable RLS
ALTER TABLE posts ENABLE ROW LEVEL SECURITY;

-- Users can read their own posts
CREATE POLICY "Users read own posts"
  ON posts FOR SELECT
  USING (auth.uid() = user_id);

-- Users can insert their own posts
CREATE POLICY "Users insert own posts"
  ON posts FOR INSERT
  WITH CHECK (auth.uid() = user_id);

Integration Points

•Supabase for managed PostgreSQL
•Prisma for type-safe ORM
•Drizzle for lightweight ORM
•pgvector for embeddings
•PostgREST for auto-generated APIs