# design-postgres-tables

> Use this skill for general PostgreSQL table design.

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.

- Type: Skill
- Made by: timescale
- Category: Databases
- Formats: Skills
- Version: 20d8acb
- Source: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables
- Page: https://pluginboard.ai/skills/design-postgres-tables

## Works with

- ChatGPT
- Claude
- Gemini
- GitHub Copilot
- Cursor
- Claude Code
- Codex
- Antigravity
- Gemini CLI
- Replit
- OpenClaw
- OpenCode
- Hermes Agent

## Install

### ChatGPT

In ChatGPT: Download the design-postgres-tables folder and zip it, then Plugins → Skills → Create → Upload from your computer. Business and Enterprise plans.

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Claude

In Claude (web or desktop): Download the design-postgres-tables folder and zip the folder itself, then upload it in Customize → Skills.

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Gemini

In Gemini: Download the design-postgres-tables folder, then at gemini.google.com click Customize → Skills → Create → Upload and pick the folder (or a .zip of it).

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### GitHub Copilot

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.copilot/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Cursor

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.cursor/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Claude Code

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.claude/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Codex

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.agents/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Antigravity

In Antigravity: Copy the design-postgres-tables folder into ~/.gemini/config/skills (Antigravity app and IDE) or ~/.gemini/antigravity-cli/skills (Antigravity CLI).

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Gemini CLI

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.gemini/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Replit

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables .agents/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### OpenClaw

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.openclaw/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### OpenCode

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.config/opencode/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

### Hermes Agent

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.hermes/skills/design-postgres-tables
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/design-postgres-tables

---
From Pluginboard (https://pluginboard.ai).