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".
Source facts
- Repository
- codejunkie99/prompt-skills
- Last source activity
- April 26, 2026 at 10:42
- Detected SKILL.md language
- English
- Stars
- 16
- Forks
- 1
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Showing SKILL.md
SKILL.md
Source instructions · Read-only preview- name
- database-schema-designer
- description
- 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".
# 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
View on GitHub