SKILL23backend-data
Designing Relational Data Models
Turns domain invariants, ownership, relationships, and access patterns into explicit relational structures.
Primary benefit
Creates schemas that reject invalid states and support real product queries without premature denormalization.When to use
Use when defining or reviewing a relational data model where entities, ownership, cardinality, lifecycle, constraints, or access patterns need explicit decisions before implementation.
When not to use
Do not use for a storage shape that is intentionally non-relational or for isolated query tuning after the model is already fixed.
Use cases
Design a PostgreSQL schema from product invariants
Review relationships, constraints, and index assumptions before migration
Example prompts
Use designing-relational-data-models to turn these product rules into a relational schema and call out every important invariant.Install this skill
Choose the command for your operating system and run it from the repository root.
Bash
./install.sh --skill designing-relational-data-modelsPowerShell
./install.ps1 --skill designing-relational-data-modelsChatGPT
Download Skill ZIPCompatibility
- Surfaces
- ChatGPT · Codex · Claude Code
- Operating systems
- Linux · macOS · Windows
- Install modes
- PluginFilesystem
Dependencies
No external dependencies
Part of systems
Curated systems that canonically include this method.