ChatGPT prompt for code generation: Migration Script (Advanced)
ChatGPT · Code Generation · Advanced
You are a senior specialist using ChatGPT for code generation, specifically migration script.
Job: forward and back.
Audience: dba. Constraint: idempotent.
Working style: precise and demanding. Optimize for constraints, evaluation, and edge cases.
Process:
1. Restate the brief in one sentence and list missing facts as questions.
2. Draft the artifact.
3. Stress-test it against the constraint.
4. Return a final version plus 3 numbered improvements.
Output contract: use headings, short paragraphs, and concrete examples. No filler. No invented statistics.
If information is missing, make the smallest reasonable assumption and label it.Use this ChatGPT code generation template when dba need migration script with the rule: idempotent. Teams report saving 15–30 minutes per task when prompts include constraints up front. The advanced version uses precise and demanding language and targets constraints, evaluation, and edge cases.
When to use this prompt
When dba tackle migration script inside code generation, the hard part is not the model — it is the brief. Functions, refactors, tests, and architecture sketches. This prompt encodes that context so ChatGPT does not guess. Bookmark this page if you run migration script weekly.
Why this prompt works
- Names a clear job so ChatGPT does not wander into generic advice.
- Separates draft from critique so you can steal the structure later.
- Asks for a self-check pass, which cuts hallucinated details.
- Uses precise and demanding language that matches how practitioners actually brief work.
- Locks the audience (dba) before style so tone stays honest.
How to use it in ChatGPT
For code generation work, paste chatgpt is a conversational language model used for drafting, research, coding, and structured thinking as a one-line reminder above the prompt. This Advanced path is for dba who care about forward and back. If the first answer is vague, reply with the constraint again: idempotent. Name the success metric aloud: forward and back. If the draft cannot pass it, do not polish prose yet. Functions, refactors, tests, and architecture sketches. Keep that context in the thread when you iterate.
Ask for a checklist dba would use. Then grade the draft against forward and back. For migration script in code generation, the failure mode is usually no example. This prompt blocks that by design — especially "idempotent". Expect two minutes customizing and two minutes editing for Advanced output. OpenAI models still need your facts for migration script; they cannot invent metrics or brand rules. developers teams bookmark slug migration-script-advanced when constraints, evaluation, and edge cases matters.
Step-by-step
- Open ChatGPT and paste the prompt block unchanged.
- Replace placeholders with your project facts (dba, offer, timeline).
- Confirm the constraint is still visible: idempotent.
- For code generation work, paste a rubric and ask for a self-score.
- Reply with one fix list, then regenerate the final version only.
Example output
Example output shape: H1 with Migration Script, 3 short sections, bullet list of recommendations, closing line that states idempotent. Facts you supply appear; nothing invented.
Common mistakes
- Using the Advanced prompt but editing it into a vague one-liner.
- Skipping the audience (dba) and hoping ChatGPT infers it.
- Deleting "idempotent" to save space — that is usually the whole point.
Expert notes
OpenAI users working on migration script in code generation should treat "idempotent" as non-negotiable. Functions, refactors, tests, and architecture sketches. When dba run the Advanced variant, they usually care about constraints, evaluation, and edge cases more than length.
If text output feels generic, re-paste idempotent as the first follow-up message — do not rewrite the whole prompt.
Comparison / variations
| Approach | When | Tweak |
|---|---|---|
| Bare request | You only need a spark | Write a migration script piece. |
| This prompt | You need a usable draft | Role, constraint, steps, and output contract included. |
| Plus examples | Voice must match yours | Paste 120 words of your writing or a still you like, then rerun in ChatGPT. |
Key takeaways
- Keep idempotent visible in the prompt, not only in your head.
- Compare against other ChatGPT angles on the same use case before you standardize.
- Ship a draft, then tighten. Do not chase a perfect first token.
- State the job (forward and back) in one line before any style talk.
- ChatGPT improves when you paste a real snippet or reference still.
FAQ
- What is a ChatGPT prompt for migration script?
- It is a structured brief that tells ChatGPT how to produce code generation output for dba. This advanced version stresses constraints, evaluation, and edge cases and keeps "idempotent" in the instructions.
- How do I customize this ChatGPT code generation prompt?
- Swap project nouns, paste one real example, and leave the process steps intact. The constraint "idempotent" should stay unless your brief truly changed.
- Why use the advanced angle for migration script?
- Different angles solve different failures. Advanced helps when dba need constraints, evaluation, and edge cases. It is not longer for its own sake — each line has a job.
- Is this ChatGPT prompt updated for 2026?
- Yes. Pages follow our SEO Bible, refresh on a rolling schedule, and include current best practices for OpenAI models. Always verify facts before client delivery.