Skip to content
PromptPilot AI

Coding & Technology prompt builder

Say what you want in plain words, pick your AI, and get a clear, structured prompt. Everything runs in your browser. No sign-up or API key needed.

Plain language is fine. This is the only required field.

2. Which AI will you use?
Chat assistants
Search
Image & video
Coding tools

Using: Coding › Database optimization

Output language
More options: audience, tone, language, format, context

Your prompt

For ChatGPT

Optimize this slow MySQL query on the orders table · Coding › Database optimization

Regenerate cycles through alternative structures for the same inputs. These actions are rule-based and instant: no AI API is called, and your inputs are kept when you switch platforms.

## Role
You are a database engineer. You give specific, practical guidance for my exact situation and explain trade-offs in a sentence, not a lecture.

## Task
Optimize this slow MySQL query on the orders table.
Success looks like: Improve schema or query performance with measurable evidence.

## If details are missing
I haven't told you these yet, so assume:
- Relevant code: I'll paste code when you ask; don't guess at code you haven't seen
- Constraints: keep changes minimal and consistent with typical conventions for the stack
State these assumptions in one line at the top of your answer. If one would change the answer a lot, ask me about it first.

## Steps
1. Understand the data and access patterns
2. Inspect the query plan (ask me to run EXPLAIN)
3. Propose indexes or rewrites with trade-offs
4. Explain how to verify the improvement

## Constraints
- Don't invent APIs, functions or library options; say if you're unsure a method exists in my version
- Show complete, runnable code for changed parts, not fragments with "..."
- No filler: skip intros, restating my request and closing summaries
- Don't invent facts, statistics, quotes, sources or details about me; flag anything I should verify

## Output format
- Analysis
- recommended changes
- verification steps

## Before you answer, check
- Code compiles/runs for the stated version
- Edge cases and error handling are covered
- Explains how to verify the change
1438 chars · ~360 tokens (rough)

Copies your prompt and opens the official site in a new tab. You may need to paste it yourself (Ctrl/⌘ + V). Nothing is sent to the AI by us.

Export and standing instructions

SKILL.md is an Agent Skill file (name + description frontmatter) for Claude and other agents that support skills.

Paste into a new ChatGPT chat, or into a custom GPT's instructions.

## Role
You are a database engineer. You give specific, practical guidance for my exact situation and explain trade-offs in a sentence, not a lecture.

## Task
Optimize this slow MySQL query on the orders table.
Success looks like: Improve schema or query performance with measurable evidence.

## If details are missing
I haven't told you these yet, so assume:
- Relevant code: I'll paste code when you ask; don't guess at code you haven't seen
- Constraints: keep changes minimal and consistent with typical conventions for the stack
State these assumptions in one line at the top of your answer. If one would change the answer a lot, ask me about it first.

## Steps
1. Understand the data and access patterns
2. Inspect the query plan (ask me to run EXPLAIN)
3. Propose indexes or rewrites with trade-offs
4. Explain how to verify the improvement

## Constraints
- Don't invent APIs, functions or library options; say if you're unsure a method exists in my version
- Show complete, runnable code for changed parts, not fragments with "..."
- No filler: skip intros, restating my request and closing summaries
- Don't invent facts, statistics, quotes, sources or details about me; flag anything I should verify

## Output format
- Analysis
- recommended changes
- verification steps

## Before you answer, check
- Code compiles/runs for the stated version
- Edge cases and error handling are covered
- Explains how to verify the change
Before vs after

Before · what you typed

Optimize this slow MySQL query on the orders table

9 words

After · your prompt

## Role
You are a database engineer. You give specific, practical guidance for my exact situation and explain trade-offs in a sentence, not a lecture.

## Task
Optimize this slow MySQL query on the orders table.
Success looks like: Improve schema or query performance with measurable evidence.

## If details are missing
I haven't told you these yet, so assume:
- Relevant code: I'll paste code when you ask; don't guess at code you haven't seen

244 words · full prompt above

What we added

  • Expert role: database engineer
  • Success criterion: what a great answer must achieve
  • Stated assumptions: sensible defaults you can correct
  • Step-by-step workflow: 4 steps for this task type
  • Constraints: 4 rules (length, clichés, no invented facts)
  • Output format: 3 sections defined
  • Self-check: the AI reviews its answer before replying
Optional: polish with an AI model. Generating above never calls an AI. If you want an LLM to rewrite this prompt, use the Enhancer with your own API key (billed by your provider; we don't store it).

Make it more specific

Answering any of these improves the result. Or press “Add missing context” to insert [placeholders] and have the AI ask you.

  • ○ Can you paste the relevant code?
  • ○ Any constraints (existing architecture, performance, deadlines)?
  • ○ What format and length do you want?

Prompt checklist

29/100

A completeness checklist, not a prediction of output quality.

  • Clear goal
  • Context: Add background the AI can't guess.
  • Audience: Who is the result for?
  • Output format: Name the format and length (a sensible default is used otherwise).
  • Tone or constraints: Add a tone or at least one rule.
  • Example / reference: An example of good output improves consistency.

Prefer fixed templates? Try the classic template builder.

Platform guides: ChatGPT · Claude · Gemini · Grok · Other AI assistant · Perplexity · Cursor / coding agents · Claude Code · Midjourney · Image · Video