Define database models and schemas with proper data types, constraints, relationships, and validation rules for PostgreSQL (Supabase/Bun.sql) and Firestore (Firebase). Use this skill when creating or modifying database models, ORM entity definitions, Prisma schemas, or Firestore document structures. Apply when working on model files (models/*.ts, entities/*.ts, schema.prisma, models/*.py, Models/*.cs), defining database relationships, setting up validation rules, or implementing data integrity constraints. This skill ensures snake_case naming for SQL and camelCase for NoSQL, required timestamps (created_at/updated_at), UUIDs for SQL and auto-generated IDs for Firestore, foreign key constraints with indexed columns, Row Level Security (RLS) policies for Supabase, strict Firestore security rules, normalized data for SQL (3NF) with denormalization for Firestore read performance, and pgvector setup for AI embeddings.
Define database models and schemas with proper data types, constraints, relationships, and validation rules for PostgreSQL (Supabase/Bun.sql) and Firestore (Firebase). Use this skill when creating or modifying database models, ORM entity definitions, Prisma schemas, or Firestore document structures. Apply when working on model files (models/*.ts, entities/*.ts, schema.prisma, models/*.py, Models/*.cs), defining database relationships, setting up validation rules, or implementing data integrity constraints. This skill ensures snake_case naming for SQL and camelCase for NoSQL, required timestamps (created_at/updated_at), UUIDs for SQL and auto-generated IDs for Firestore, foreign key constraints with indexed columns, Row Level Security (RLS) policies for Supabase, strict Firestore security rules, normalized data for SQL (3NF) with denormalization for Firestore read performance, and pgvector setup for AI embeddings.
Backend Models
When to use this skill:
When creating new database model or entity definitions
When modifying existing ORM models or Prisma schema definitions
When working on model files (models/.ts, entities/.ts, schema.prisma, models/.py, Models/.cs)
When defining relationships between database entities (one-to-many, many-to-many)
When adding database constraints (NOT NULL, UNIQUE, foreign keys)
When implementing model-level validation rules
When setting up timestamps (created_at, updated_at) on tables
When choosing appropriate data types for fields
When adding indexes to foreign keys or frequently queried columns
When balancing normalization with practical query performance needs
When configuring Supabase Row Level Security (RLS) policies
When writing Firestore security rules for document validation
When setting up pgvector columns and HNSW indexes for AI embeddings
When designing Firestore subcollections vs root collections
When implementing query-driven data modeling for NoSQL
This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to how it should handle backend models.
Instructions
For details, refer to the information provided in this file:
backend models
