Design Postgres Tables
timescale/pg-aiguide/skills/design-postgres-tablesby timescale187be00d317a51210c132010d947f4546ffb5eefApache-2.0Listed Oct 9, 2026Updated Oct 9, 2026
Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables, order tables, reference tables, or JSONB schemas - Understand PostgreSQL best practices for normalization, constraints, or indexing - Design update-heavy, upsert-heavy, or OLTP-style tables **Keywords:** PostgreSQL schema, table design, data types, PRIMARY KEY, FOREIGN KEY, indexes, B-tree, GIN, JSONB, constraints, normalization, identity columns, partitioning, row-level security Comprehensive reference covering data types, indexing strategies, constraints, JSONB patterns, partitioning, and PostgreSQL-specific best practices.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| SKILL.md | 16.5 KB | text/markdown |
Source and attribution
Source:timescale/pg-aiguideinskills/design-postgres-tablesat commit187be00
License: Apache-2.0
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from timescale/pg-aiguide
Setup Timescaledb Hypertables
timescale
Guides creation of TimescaleDB hypertables, compression, retention policies, continuous aggregates and indexes for insert-heavy time-series data.
Pgvector Semantic Search
timescale
Guides setup and tuning of pgvector vector similarity search in PostgreSQL for embeddings, RAG and semantic search.
More in Software Development
Playground
anthropics
Builds self-contained interactive HTML playgrounds with controls, live preview, and copyable prompt output.
M5 Onboard
anthropics
Provisions M5Stack ESP32 boards by detecting them on USB, flashing UIFlow 2.0 firmware, and installing a MicroPython app bundle.
Cardputer Buddy
anthropics
Guides iterating on a Cardputer-Adv MicroPython app bundle: adding apps, pushing files over USB-serial, tailing logs, and running REPL commands.
Web Design Guidelines
vercel-labs
Reviews UI code against Web Interface Guidelines fetched from a remote source and reports findings as file:line entries.
Vercel React Native Skills
vercel-labs
React Native and Expo best-practice rules covering list performance, animation, navigation, UI patterns, state, and monorepo setup.
Vercel React Best Practices
vercel-labs
Vercel's React and Next.js performance guidelines, organized as 70 rules for writing, reviewing, and refactoring code.