PostgreSQL Table Design skill: what it does and how to install it
Designs and reviews PostgreSQL schemas with guidance on data types, constraints, indexes, partitioning and performance patterns.
Summary generated from the skill's documentation.
Install
$ npx skills add wshobson/agents --skill postgresql-table-designRun it in a terminal. If your agent is already running, start a new session so it picks the skill up.
About this skill
What it does. Guides PostgreSQL schema design and review, covering keys, data types, constraints, foreign-key indexes, JSONB, partitioning and workload-specific patterns. It provides SQL examples and directs deeper work to reference material for extensions, storage, row-level security and safe schema changes.
When to use it. For new schemas, pre-release reviews, type or index decisions, large-table partitioning, semi-structured data and live migrations that require minimal downtime.
History
Repo stars
40.5k+245 since 5 Oct 2026
Stars are counted for the whole repository, which holds 26 skills.
Show as a table
| Date | Repo stars |
|---|---|
| 12 Oct 2026 | 40,457 |
| 11 Oct 2026 | 40,368 |
| 10 Oct 2026 | 40,319 |
| 9 Oct 2026 | 40,307 |
| 8 Oct 2026 | 40,296 |
| 7 Oct 2026 | 40,267 |
| 6 Oct 2026 | 40,238 |
| 5 Oct 2026 | 40,212 |
Installs
27.1k
Tracking since . A chart appears once there are 7 days of data.
Installs via skills.sh
Similar skills
- PostgreSQL OptimizationOptimises PostgreSQL queries and schemas using advanced data types, indexes, extensions and database performance monitoring.
- Database Schema DesignerDesigns SQL and NoSQL database schemas: normalisation, indexing, constraints and migration patterns.
- SQL ProOptimizes SQL queries and database schemas across PostgreSQL, MySQL, SQL Server and Oracle using execution plans, indexes and set-based patterns.