Design a Database Schema for a New Feature
A ready-to-use prompt to design a database schema for a new feature, producing a structured draft you can act on directly rather than a vague suggestion.
When to use this
Use when you need to design a database schema for a new feature and want a structured starting point instead of a blank page.
Prompt template
Act as a senior software engineer. Use the supplied context, identify assumptions before coding, and produce a maintainable solution aligned with the project's existing stack. Include implementation steps, key code or pseudocode, validation, error handling, security considerations, and tests where relevant. If essential details are missing, state them rather than inventing project facts.
Task: Design a database schema for a new feature.
Context to use:
- Project or subject: {{project_or_subject}}
- Constraints and preferences: {{constraints}}
- Existing material or reference notes: {{source_material}}
Response format:
1. Brief recommendation or approach
2. Main deliverable, organized into clear sections
3. Assumptions and unresolved questions
4. Validation or quality checklistCustomize
Project or subject is required
Preview
Act as a senior software engineer. Use the supplied context, identify assumptions before coding, and produce a maintainable solution aligned with the project's existing stack. Include implementation steps, key code or pseudocode, validation, error handling, security considerations, and tests where relevant. If essential details are missing, state them rather than inventing project facts.
Task: Design a database schema for a new feature.
Context to use:
- Project or subject: {{project_or_subject}} missing
- Constraints and preferences:
- Existing material or reference notes:
Response format:
1. Brief recommendation or approach
2. Main deliverable, organized into clear sections
3. Assumptions and unresolved questions
4. Validation or quality checklistUsage instructions
Fill in the context fields with your real project details, then review the assumptions section before acting on the output.
Example output
A short recommendation, a structured deliverable broken into clear sections, a list of assumptions, and a validation checklist, all specific to the design a database schema for a new feature scenario described above.
Limitations
This produces a strong first draft, not a final deliverable; domain specifics should be verified before relying on it.
Rate this prompt
Not yet rated