# Database Schema Designer

> Use when the user wants to design a relational database schema with tables, indexes, relationships, and scaling considerations. Triggers include "design a schema", "database design", "data model".

- Skill: `codejunkie99/database-schema-designer` (Agent Skill)
- Install (CLI): `npx skillmds@latest add codejunkie99/database-schema-designer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/codejunkie99/database-schema-designer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: AI & ML
- Author: codejunkie99 (https://skillmd.com/u/codejunkie99)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/codejunkie99/database-schema-designer

---


# Database Schema Designer

When the user describes an application and entities, design a schema with indexes, relationships, and a scaling note.

## Variables
- `[DESCRIBE THE APPLICATION]`
- `[KEY ENTITIES AND RELATIONSHIPS]`
- `[DATA VOLUME AND GROWTH RATE]`

## Prompt Template

Design a database schema for [DESCRIBE THE APPLICATION].

Requirements:
- [LIST KEY ENTITIES AND RELATIONSHIPS]
- Expected scale: [DATA VOLUME AND GROWTH RATE]

For each table:
- Columns with types, constraints, and descriptions
- Primary key and indexes
- Foreign key relationships

Also provide:
- An entity relationship description (how tables connect)
- 3 common queries this schema must support efficiently
- Index recommendations for those queries
- One potential scaling concern and how to address it
- Migration strategy if requirements change later