postgresql-table-design

What the skill teaches

A schema design skill for PostgreSQL from a large community collection of Claude Code plugins. When an agent designs or reviews a schema, it applies a set of rules: primary key choices, normalising before denormalising, NOT NULL and defaults, indexing foreign keys and real access paths, and preferred column types for time, money, text and numbers. It also lists PostgreSQL-specific gotchas such as identifier case and how unique constraints treat nulls, and covers partitioning, semi-structured data and changing a live schema without downtime. A reference file holds the full type catalogue, workload patterns, JSONB indexing and worked DDL examples.

Capabilities

Details