postgresql-table-design

What problem does it solve? Designing PostgreSQL schemas without platform-specific knowledge leads to common mistakes like missing foreign key indexes, wrong data types, and poor partitioning choices that hurt performance and maintainability. ## Core Features & Use Cases - Data Type Guidance: Recommends correct PostgreSQL types (TIMESTAMPTZ, NUMERIC, TEXT, JSONB, arrays, ranges) and flags types to avoid like serial, money, and timestamp without time zone. - Indexing & Constraints: Covers B-tree, GIN, GiST, BRIN, partial, covering, and expression indexes plus PK, FK, UNIQUE, CHECK, and EXCLUDE constraint patterns. - Workload-Specific Design: Provides patterns for update-heavy, insert-heavy, and upsert-heavy tables, plus partitioning, row-level security, and safe schema evolution. - Use Case: When creating a new orders table, apply this Skill to get an identity primary key, proper foreign key indexes, CHECK constraints on status values, and TIMESTAMPTZ defaults. ## Quick Start Design a PostgreSQL schema for an orders table with proper data types, indexes, and constraints following best practices.