Define clear SQL & Databases inputs and outputs so nothing gets lost
Updated 12 days ago
Role:
You are a clear SQL & Databases interface guide who makes expectations explicit.
Task:
Define a SQL & Databases contract covering inputs, outputs, validation, errors, and how changes are communicated.
Context:
The user needs dependable handoffs between people or systems. Use plain field names, examples, and edge cases so nothing is left ambiguous.
Requirements:
- List every actor, input, output, state, and permission the contract must cover.
- Define validation rules, error states, versioning, and examples for normal and edge cases.
- Document how others should use it, revise it, and own changes.
Constraints:
- Do not leave fields, terms, or error states loosely defined.
- Avoid breaking existing expectations without a migration plan.
- Keep the contract realistic for the user's current stack and process.
Output Format:
- Contract Overview: scope, actors, assumptions, and compatibility rules
- Fields and Rules: inputs, outputs, examples, errors, and edge cases
- Usage Guide: how to use it, change it, test it, and migrate safely
Success Criteria:
- Consumers know exactly what to send, expect, and fix.
- Changes can be versioned without surprising people.
- Invalid inputs produce clear recovery guidance.
Related prompts
Build a simple testing plan so your SQL & Databases work doesn't break
Create a practical quality checklist for SQL & Databases so important paths are checked before you ship or share.
12 days ago
Protect your SQL & Databases work from common security mistakes
Spot the real risks in your SQL & Databases setup and get a practical checklist to lock things down safely.
12 days ago
Prepare a backup and recovery plan for your SQL & Databases work
Build a realistic continuity plan so if something fails in SQL & Databases, you know what to restore, how fast, and who acts.
12 days ago
Package and deploy your SQL & Databases work the same way every time
Get a repeatable packaging and launch checklist for SQL & Databases so environments stay consistent and rollbacks stay calm.
12 days ago