Postgres data modeling

Created by CodeCraft LLC

Design and review PostgreSQL data models (including Supabase)

Product and technology names are trademarks of their respective owners, used only to identify what this skill covers. CodeCraft LLC is not affiliated with or endorsed by them.

by Jace (@jamick)v1.2.0 · updated 2026-10-16Report copyright infringement

Description

Design and review PostgreSQL data models (including Supabase) — primary keys (UUIDv7/UUID vs identity), types (timestamptz, text with checks, numeric or integer cents for money), constraints as business rules, enums vs lookup tables vs CHECK, JSONB vs relational columns, multi-tenancy with tenant_id plus RLS, soft deletes and partial unique indexes, audit/history tables, created_at/updated_at handling, indexing foreign keys and query patterns, many-to-many join tables, full-text search, naming conventions, and avoiding EAV. Use whenever the user designs new tables or schemas, models a feature's data, asks "how should I store X", reviews an ERD or schema, or plans multi-tenant or marketplace data.

#backend#data#modeling#postgres

Included with all-access

$9.00 value as a single download

AiSkillz is in preview: browse the catalogue now - skill downloads and subscriptions open soon.

All skills are included with the all-access subscription

Changelog

v1.2.0Oct 16, 2026Latest

Added

references/schema-design-patterns.md: schema design patterns (normal forms, UUIDv7 keys, soft-delete options, audit columns, JSONB rules, naming) - merged from the former database-schema-design skill.

v1.1.0Oct 3, 2026

Changed

Checked against the official documentation (October 2026).
Added built-in uuidv7() (Postgres 18) and the uuidv4() alias to the key guidance.
Added Postgres 18 modelling features: virtual generated columns by default, RETURNING old/new, temporal WITHOUT OVERLAPS / PERIOD constraints.

v1.0.1Oct 3, 2026

Changed

Added a trademark notice to the README.

v1.0.0Oct 2, 2026

Added

First release.