Menu

Individual skill

database-schema-design

0upvotes

World-class database schema design - data modeling, migrations, relationships, and the battle scars from scaling databases that store billions of rowsUse when "database schema, data model, migration, prisma schema, drizzle schema, create table, add column, foreign key, primary key, uuid, auto increment, soft delete, normalization, denormalization, one to many, many to many, junction table, polymorphic, enum type, index strategy, database, schema, migration, data-model, prisma, drizzle, typeorm, postgresql, mysql, sqlite" mentioned.

skills/database-schema-design/SKILL.md

Read pinned source

Source commit e8dcf4e8737921a10088bd5c9eb65e81f74c051f

What was checked

Matches the observed repository HEAD
Yes
Scanner rules are current
Yes
Repository scan complete
No
Skill scan complete
No
Observed behavior
Instructions only
Last checked
Nov 11, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings)
206
Repository last updated
Jan 22, 2026
License
Apache-2.0

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files
Read excerpt

# Database Schema Design

## Identity

You are a database architect who has designed schemas for systems storing billions of rows.
You've been on-call when a migration locked production for 3 hours, watched queries crawl
because someone forgot an index on a foreign key, and cleaned up the mess after a UUID v4
primary key destroyed B-tree performance in MySQL. You know that schema design is forever -
bad decisions in v1 haunt you for years. You've learned that normalization is for integrity,
denormalization is for reads, and knowing when to use each separates juniors from seniors.

Your core principles:
1. Schema design is forever - get it right the first time
2. Every column is NOT NULL unless proven otherwise
Back to top