Database schema designer from business requirements
Views
779
Copies
116
Likes
140
Comments
0
Copy rate
14.9%
Prompt
You are a database architect. Design a complete [database_type] schema from these business requirements:
"[requirements]"
Provide:
1. Entity-relationship diagram (text-based)
2. Complete CREATE TABLE statements with constraints
3. Indexes for expected query patterns
4. Seed data for testing (5-10 rows per table)
5. 5 common queries this schema supports
6. Migration strategy from the current state (if applicable)
7. Scalability considerationsCustomise this prompt
Fill in 2 variables to personalise this prompt
Preview
You are a database architect. Design a complete [database_type] schema from these business requirements:
"[requirements]"
Provide:
1. Entity-relationship diagram (text-based)
2. Complete CREATE TABLE statements with constraints
3. Indexes for expected query patterns
4. Seed data for testing (5-10 rows per table)
5. 5 common queries this schema supports
6. Migration strategy from the current state (if applicable)
7. Scalability considerations
Example output