Postgresql Table Design

PostgreSQL Table Design provides guidance on schema design best practices for PostgreSQL databases, covering primary keys, normalization, data types, indexing strategies, constraints, and PostgreSQL-specific behaviors. It serves database architects and developers who need to design or review PostgreSQL schemas by helping them avoid common pitfalls like missing foreign key indexes, premature denormalization, and misunderstandings about PostgreSQL's MVCC storage model and type coercion rules. The skill solves the problem of creating maintainable, performant database schemas that follow PostgreSQL conventions and leverage its specific features effectively.

install copies · 90 days. Times the install command was copied on this site in the last 90 days, bots filtered.: 20
skills.sh installs: 28.7K
GitHub stars: 42.4K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add wshobson/agents --skill postgresql-table-design --agent claude-code

Installs into .claude/skills of the current project.

Files

PostgreSQL Table Design

When to Use

Designing a new PostgreSQL schema, or reviewing one before it ships.
Choosing column types, keys, constraints, or indexes for PostgreSQL specifically.
Deciding whether and how to partition a large table, or how to store semi-structured data.
Planning a schema change on a live database without downtime.

The rules and decision points for a PostgreSQL schema. The full data-type catalog, workload patterns (update-heavy, insert-heavy, upsert, schema evolution), extensions, JSONB indexing, and worked DDL examples are in references/details.md; open it when a section below points there.