design-postgres-tables
Schema design decisions made explicitly: data types, key strategy, JSONB versus columns, and when partitioning earns its complexity.
Install
$ npx skills add timescale/pg-aiguide --skill design-postgres-tablesBest for
Designing a new schema, or reviewing one before it accumulates the data that makes changing it expensive.
Not ideal for
Applying a migration to an existing live table — reach for the migration skill instead, which covers the locking behaviour this one does not.
About this skill
Use when designing PostgreSQL tables and schemas — choosing data types, primary and foreign keys, B-tree versus GIN indexes, JSONB versus columns, normalization level, partitioning strategy, and row-level security. Trigger on new table design, data modelling, or reviewing an existing schema for correctness and performance.
Score breakdown
Score breakdown
rubric 1.0Composite 0–100 score derived from 9 verifiable signals. See the rubric →
Related skills
PlanetScale's schema branching and index-aware queries, packaged for agents.
Supabase done right. RLS policies, edge functions, realtime, auth — in idiomatic patterns.
Prisma migrations and queries by the book. Index-aware, migration-safe, type-correct.
