postgresql-table-design
Best practices for PostgreSQL table design, including normalization, indexing, data types, and performance optimization.
Install
npx skills add https://github.com/wshobson/agents --skill postgresql-table-designStats
| Total installs | 9,672 |
| Weekly installs | 9.6K |
| GitHub stars | 32.4K |
| First seen | Jan 20, 2026 |
| Source | @wshobson/agents |
Summary
- Prioritize normalization to 3NF; denormalize only when join performance is proven problematic and measured for ROI.
- Use BIGINT GENERATED ALWAYS AS IDENTITY for primary keys unless global uniqueness or opacity requires UUID; always add indexes on foreign key columns.
- Choose data types carefully: TIMESTAMPTZ for events, NUMERIC for money, TEXT for strings, JSONB for semi-structured data; avoid TIMESTAMP, VARCHAR(n), SERIAL, and MONEY type.
- Index strategically for actual query patterns: B-tree for equality/range, GIN for JSONB/arrays/full-text, GiST for ranges/geometry, BRIN for large time-series data.
- Partition tables >100M rows by range (time) or hash; use TimescaleDB for time-series automation; separate hot/cold columns and minimize indexes for insert-heavy workloads.
Tags
Related skills
| Skill | Installs | vs postgresql-table-design |
|---|---|---|
| sql-optimization-patterns | 7,652 | -2,020 |
| backend-testing | 11,809 | +2,137 |
| sql-optimization | 8,296 | -1,376 |
| ef-core | 7,528 | -2,144 |
| snowflake-semanticview | 7,572 | -2,100 |
FAQ
- How many installs does postgresql-table-design have?
- postgresql-table-design has 9,672 total installs and 9.6K installs this week.
- Where is postgresql-table-design hosted?
- postgresql-table-design is published by @wshobson/agents at https://github.com/wshobson/agents.
- How many GitHub stars does postgresql-table-design have?
- postgresql-table-design has 32.4K GitHub stars.
- When was postgresql-table-design first indexed?
- OrangeBot.AI first indexed postgresql-table-design on Jan 20, 2026.
- How do I install postgresql-table-design?
- Run: npx skills add https://github.com/wshobson/agents --skill postgresql-table-design