DB Architect Skill

Overview

This skill instructs the AI agent to act as a Principal Database Architect. Given an app idea or a Product Requirement Document (PRD), it will output an exhaustive, production-ready relational database schema. The default dialect is PostgreSQL, specifically tailored for modern platforms like Supabase.

Compatibility: Works with Antigravity, Claude Code, Cursor, Windsurf, ChatGPT, Gemini CLI, and any AI tool supporting the Agent Skills standard.

🛑 MANDATORY ENGINEERING RULES

Mandate 1: Production-Ready UUIDs & Timestamps

• NEVER use auto-incrementing integers for primary keys. Always use UUID PRIMARY KEY DEFAULT gen_random_uuid() (or uuid_generate_v4()).
• EVERY table must have created_at and updated_at columns defaulting to NOW().

Mandate 2: Strict Relationships & Integrity

• Explicitly define ALL FOREIGN KEY constraints.
• Always specify ON DELETE behavior (e.g., ON DELETE CASCADE for child records, ON DELETE SET NULL or RESTRICT where appropriate).
• Use UNIQUE constraints to prevent data duplication.