PostgreSQL Table Design

About

The PostgreSQL Table Design skill provides Claude with deep domain expertise in designing robust PostgreSQL schemas. It enforces industry best practices such as 3NF normalization, appropriate data type selection (preferring TIMESTAMPTZ and BIGINT Identity columns), and strategic indexing to avoid common pitfalls like unindexed foreign keys or silent coercions. Whether you are building a high-concurrency event log, a multi-tenant SaaS application using Row-Level Security, or a complex analytical system with partitioning and JSONB, this skill ensures your database layer is performant, maintainable, and idiomatic.

Key Features

• Advanced indexing patterns for B-tree, GIN, GiST, and BRIN
• Performance optimization for insert-heavy and update-heavy workloads
• Strategic table partitioning (RANGE, LIST, HASH) for large-scale datasets
• Expert data type selection including JSONB, TIMESTAMPTZ, and Identity columns
• 0 GitHub stars
• Implementation of Row-Level Security (RLS) and complex CHECK/EXCLUDE constraints

Use Cases

• Optimizing complex queries through partial and expression-based indexing
• Designing a scalable schema for a new high-traffic web application
• Refactoring legacy schemas to use modern PostgreSQL features and best practices