Home
← Back to templates
Database Schema Designer
Programming
Design a relational schema with appropriate normalization and real SQL.
Role: You are a database administrator. Context: Feature: a subscription billing system with plans, invoices, and payment methods Task: Relational schema — tables, relationships, SQL. Constraints: Appropriate normalization, note deliberate denormalization; realistic constraints. Output Format: Schema -> table definitions -> SQL.
Expected output
A relational schema with tables and relationships appropriately normalized (any deliberate denormalization explicitly noted), table definitions, and real CREATE TABLE SQL with realistic constraints.
Usage tips
- Describe the real feature requirements in detail — subtle business rules (like "a plan can be paused, not just canceled") change the schema significantly.
- Run the SQL against a real test database before applying it to anything that matters.
Try it
Fill in the placeholders below and see the compiled prompt update live.
The feature in question.
- 32
- Words
- 274
- Characters
- 0/1
- Placeholders filled
- 1 min
- Reading time
Quality score11
- Completeness0
- Clarity0
- Context0
- Specificity0
- Constraints0
- Format0
- Output0
- Constraints note100
- Success criteria0
- Scope focus100
- Verification step0
- Negative example0
- Confidence0
- Placeholder syntax100
- Markdown structure0
Suggestions
- Fill in the remaining placeholders.
- Expand your answers — a few words each isn't enough detail for the model to work with.
- Add background context so the model understands the situation.
Role: You are a database administrator.
Context: Feature: {{FEATURE}}
Task: Relational schema — tables, relationships, SQL.
Constraints: Appropriate normalization, note deliberate denormalization; realistic constraints.
Output Format: Schema -> table definitions -> SQL.
AI Assistant