postgresql-table-design

Quick Review

Exceptional PostgreSQL schema design skill with comprehensive coverage of data types, indexing strategies, constraints, partitioning, and PostgreSQL-specific gotchas. The description accurately reflects the extensive content. Task knowledge is outstanding—provides actionable guidance, specific syntax, concrete examples, and detailed decision criteria (e.g., when to use UUID vs BIGINT, GIN vs jsonb_path_ops). Structure is excellent with clear sections, though at 400+ lines it's dense; however, the logical organization and topic-based sections make navigation straightforward. Novelty is strong: while a CLI agent could handle basic table creation, this skill encodes deep PostgreSQL expertise (MVCC implications, TOAST strategies, HOT updates, constraint exclusion, extension ecosystem) that would require extensive token usage and domain knowledge to replicate. Minor improvement opportunity: could reference separate files for examples or extension deep-dives to reduce SKILL.md length, though current organization remains clear.