---
title: "PostgreSQL Table Design - Air Market"
description: "You are laying out tables in Postgres, and the choices you make now are the ones you will live with. This covers picking data types, adding constraints, indexing, and the patterns that keep queries f…"
canonical: "https://airmarket.ai/app/postgresql-table-design"
---

[Air Market](/) / [Data & Analytics](/category/data) / PostgreSQL Table Design

Skill by [Seth Hobson](/@wshobson)

# PostgreSQL Table Design

Get the schema right before the data piles up

## What this does

You are laying out tables in Postgres, and the choices you make now are the ones you will live with. This covers picking data types, adding constraints, indexing, and the patterns that keep queries fast, plus the database's more advanced features. Reach for it when designing a new schema or reviewing one before it ships.

### Top 3 things it does for you

- Design a new Postgres schema
- Review a schema someone else wrote
- Pick the right data types and constraints

## Information

**PostgreSQL Table Design at a glance**

|  |  |
| --- | --- |
| Kind | Skill |
| Publisher | [Seth Hobson](/@wshobson) |
| Category | [Data & Analytics](/category/data) |
| Works with | Agent Skills - an open standard supported by 40+ agents |
| Size | 16 KB |
| Licence | MIT |
| Repository | [wshobson/agents](https://github.com/wshobson/agents/tree/ece811f23310a37ceb43496dbac0e244fe6845b6/plugins/database-design/skills/postgresql) |
| GitHub stars | 39,077 (as of Nov 2026) |
| Installs | 28,772, counted by skills.sh (Nov 2026) |

## Security report

**Verified.** AIR scanned this exact version of PostgreSQL Table Design and flagged nothing. AIR's verdict: **safe**.

**What PostgreSQL Table Design's check was run against**

|  |  |
| --- | --- |
| Commit | ece811f23310a37ceb43496dbac0e244fe6845b6 |
| Content hash | 6595033920569dd882d155090b3797e86d6f4fb7c1793475716d5b9297f9ab5c |
| Files read | [Browse the files at this exact commit](https://github.com/wshobson/agents/blob/ece811f23310a37ceb43496dbac0e244fe6845b6/plugins/database-design/skills/postgresql/SKILL.md) |

A scan is named by the exact content it read, not by a version number. A different version is a different artifact, and nothing here applies to a version AIR has not scanned.

[Read the full security report for PostgreSQL Table Design](/security/postgresql-table-design)

## About PostgreSQL Table Design

This is for designing or reviewing a schema specifically for PostgreSQL. It covers best practices, data types, indexing, constraints, performance patterns, and the database's advanced features.

Reach for it whether you are laying out new tables or going over an existing design.

## What's inside

- SKILL.md - instructions

## Questions

### Is PostgreSQL Table Design safe to install?

AIR scanned this exact version of PostgreSQL Table Design and flagged nothing. AIR's verdict: safe. The verdict is named by the content that was read, at commit ece811f23310, so it cannot drift onto a version nobody scanned. The full report is at https://airmarket.ai/security/postgresql-table-design.

### How do I install PostgreSQL Table Design?

Open https://airmarket.ai/app/postgresql-table-design on Air Market and use the install action: Air Market hands Claude a prompt naming this exact skill, and Claude sets it up. Source, pinned to the exact commit this listing describes: https://github.com/wshobson/agents/tree/ece811f23310a37ceb43496dbac0e244fe6845b6/plugins/database-design/skills/postgresql. Install from that link, not the branch.

## Related on Air Market

- [More Data & Analytics listings](/category/data)
- [Everything by Seth Hobson](/@wshobson)

---

Canonical URL: <https://airmarket.ai/app/postgresql-table-design>