database-schema-designer

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