---
name: design-postgres-tables
slug: postgres-table-design
score: 55
rubric: 1.0
provenance: verified-org
publisher: TigerData (Timescale)
license: Apache-2.0
capability: read-only
canonical: https://top-agent-skills.com/skill/postgres-table-design
---

# design-postgres-tables

Schema design decisions made explicitly: data types, key strategy, JSONB versus columns, and when partitioning earns its complexity.

## Install

### Claude Code

```bash
npx skills add timescale/pg-aiguide --skill design-postgres-tables
```

## Best 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

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.

## Compatibility

claude-code

## Metadata

- Categories: databases-schemas
- Surfaces: claude-code
- Tags: Schema design, PostgreSQL, JSONB
- Setup time: 1 min
- Complexity: Low
- Last update: 2026-06-26
- Verified: —
- Source: https://github.com/timescale/pg-aiguide/tree/main/skills/design-postgres-tables
- Docs: https://github.com/timescale/pg-aiguide/blob/main/skills/design-postgres-tables/SKILL.md

---

_Indexed by Top Agent Skills. Score breakdown: https://top-agent-skills.com/about/methodology_