postgresql-table-design
OfficialRobust Postgres schema design.
Authorlinehaul-ai
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Establishes best practices for PostgreSQL table design, including normalization, data types, indexing, and constraints to ensure scalable, maintainable schemas.
Core Features & Use Cases
- Primary Keys & IDs: guidance on UUIDs vs BIGINT and when to use each.
- Normalization vs Denormalization: guidance on balancing data integrity and performance.
- Data Types & Indexing: recommended types and indexing strategies.
- Constraints & Auditing: NOT NULL, UNIQUE, CHECK, and audit columns.
- Real-world patterns and considerations for modeling core tables (e.g., loads, orders, users).
Quick Start
Use these guidelines to design a new table in your schema, including an id UUID with default gen_random_uuid(), created_at TIMESTAMPTZ, and updated_at fields.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgresql-table-design Download link: https://github.com/linehaul-ai/linehaulai-claude-marketplace/archive/main.zip#postgresql-table-design Please download this .zip file, extract it, and install it in the .claude/skills/ directory.