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