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".

codejunkie99 f613207 1.1 KB Updated

File contents

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

codejunkie99/prompt-skills/tree/main/technical/database-schema-designer commit f613207258

Frequently asked questions

npx skillmds@latest add codejunkie99/database-schema-designer