Coding
Database Schema Migration with Backfill Plan
Database Schema Migration with Backfill Plan turns technical context into clear code, diagnosis, or implementation guidance with clear constraints and an explicit output.
The prompt
Database Schema Migration with Backfill Plan guides the model through a defined task while preserving the source prompt's useful structure and constraints. Use it when planning, writing, reviewing, or debugging software and you want a response that is easier to evaluate and act on.
text prompt
You are a principal software engineer.
Model guidance (Claude 4.6):
- Use extended thinking and set effort to max for planning and tricky parts.
- Prefer small, safe patches and explicit tradeoffs when choices exist.
- If the provided context is large, start by building an index of what matters before editing.
Task:
Design and implement a schema migration for the change described. Include migrations, backfill job, verification queries, and rollback plan.
Inputs:
- Current schema and constraints: {{currentSchema}}
- Desired schema change and rationale: {{desiredChange}}
- Downtime tolerance and traffic profile: {{trafficConstraints}}
Output format:
1. Brief plan (max 10 bullets).
2. Assumptions and open questions (if any).
3. File change list (add, modify, delete) with rationale.
4. Patch set: provide complete file contents for every changed file, each in its own code block labeled with the file path.
5. Tests: commands to run, plus any new tests added.
6. Risk notes: what could break, and how to roll back.
Constraints:
- Keep changes minimal and consistent with the existing style.
- Do not introduce new dependencies unless explicitly allowed.
- If you are unsure about a detail, state it and choose a safe default.
Tune the prompt, not the plumbing.
Every control comes from this prompt’s content schema. Changes stay in your browser and update instantly.
Customized prompt1260 characters
You are a principal software engineer.
Model guidance (Claude 4.6):
- Use extended thinking and set effort to max for planning and tricky parts.
- Prefer small, safe patches and explicit tradeoffs when choices exist.
- If the provided context is large, start by building an index of what matters before editing.
Task:
Design and implement a schema migration for the change described. Include migrations, backfill job, verification queries, and rollback plan.
Inputs:
- Current schema and constraints: a specific current schema
- Desired schema change and rationale: a specific desired change
- Downtime tolerance and traffic profile: a specific traffic constraints
Output format:
1. Brief plan (max 10 bullets).
2. Assumptions and open questions (if any).
3. File change list (add, modify, delete) with rationale.
4. Patch set: provide complete file contents for every changed file, each in its own code block labeled with the file path.
5. Tests: commands to run, plus any new tests added.
6. Risk notes: what could break, and how to roll back.
Constraints:
- Keep changes minimal and consistent with the existing style.
- Do not introduce new dependencies unless explicitly allowed.
- If you are unsure about a detail, state it and choose a safe default.
Useful structure, room to move.
Database Schema Migration with Backfill Plan guides the model through a defined task while preserving the source prompt's useful structure and constraints. Use it when planning, writing, reviewing, or debugging software and you want a response that is easier to evaluate and act on.
The prompt establishes the job first, then supplies concrete decisions a model can act on. The variables preserve that structure while letting you change the subject, context, or output.
Related prompts
Code Review with Risk Scoring and Patch Suggestions
Code Review with Risk Scoring and Patch Suggestions turns technical context into clear code, diagnosis, or implementation guidance with clear constraints and an explicit output.
ChatGPTClaudeGemini
Debugging Triage from Logs and Stack Traces
Debugging Triage from Logs and Stack Traces turns technical context into clear code, diagnosis, or implementation guidance with clear constraints and an explicit output.
ChatGPTClaudeGemini
Dependency Upgrade and Breaking Change Mitigation
Dependency Upgrade and Breaking Change Mitigation turns technical context into clear code, diagnosis, or implementation guidance with clear constraints and an explicit output.
ChatGPTClaudeGemini
Error Handling and Retry Policy Refactor
Error Handling and Retry Policy Refactor turns technical context into clear code, diagnosis, or implementation guidance with clear constraints and an explicit output.
ChatGPTClaudeGemini