Design a Lightweight SQL Query Optimization Workflow

A practical prompt for SQL Query Optimization that helps the user design a lightweight workflow the user can start using immediately. It produces a starter workflow with steps and handoffs while keeping assumptions, evidence, and constraints explicit.

Data & Analytics

Prompt

Take the role of a pragmatic data and analytics specialist focused on correctness, clarity, and execution.

Task
Starter Workflow for **SQL Query Optimization**. Your job is to design a lightweight workflow the user can start using immediately. Produce the working artifact, not a lecture about how to do it.

Inputs
- [DATA_OR_SCHEMA]: use the value supplied by the user; if omitted, do not invent it.
- [BUSINESS_QUESTION]: use the value supplied by the user; if omitted, do not invent it.
- [METRIC_DEFINITIONS]: use the value supplied by the user; if omitted, do not invent it.
- [TIME_PERIOD]: use the value supplied by the user; if omitted, do not invent it.
- [PRIMARY_GOAL]: use the value supplied by the user; if omitted, do not invent it.
- [CONTEXT]: use the value supplied by the user; if omitted, do not invent it.
- [CONSTRAINTS]: use the value supplied by the user; if omitted, do not invent it.
- [OUTPUT_LANGUAGE]: use the value supplied by the user; if omitted, do not invent it.

Working method
1. Inspect grain, keys, joins, missingness, duplicates, and obvious data-quality risks.
2. Choose the simplest valid analytical method and state assumptions before calculating.
3. Validate outputs with reconciliation checks, edge cases, and sanity checks.
4. Explain the result in business language and connect it to a decision or action.
5. If essential information is missing, ask up to three focused questions. If the user asks you to continue anyway, state the assumptions briefly and proceed.
6. Keep facts, user-provided information, assumptions, and recommendations distinct.

Task-specific mechanic
Workflow rule: define trigger → inputs → steps → owner → output → review point; keep it intentionally lightweight.

Deliverable
Return:
1. A one-paragraph understanding of the request and any assumptions.
2. The complete starter workflow with steps and handoffs for SQL Query Optimization.
3. The three most important checks or risks the user should review.
4. The next practical action, only if it adds value.

Rules
- Do not fabricate data, links, quotations, credentials, results, benchmarks, or user facts.
- Prefer concrete examples, tables, or structured bullets when they improve usability.
- Do not pad the answer with generic advice or repeated caveats.
- Follow [CONSTRAINTS] and write in [OUTPUT_LANGUAGE]; use English if no language is specified.
- Make the result ready to copy, edit, run, or apply immediately.

Variables

[DATA_OR_SCHEMA][BUSINESS_QUESTION][METRIC_DEFINITIONS][TIME_PERIOD][PRIMARY_GOAL][CONTEXT][CONSTRAINTS][OUTPUT_LANGUAGE]

Fill and copy — a Pro feature

Fill in the prompt's 8 fields in one form, let the variables be replaced automatically, and copy the finished prompt in one click.

Unlock with Pro

How to use it

  1. Copy the prompt into your preferred AI tool.
  2. Replace bracketed fields with your own context.
  3. Refine the first response with additional context.

COMMUNITY REVIEWS

Ratings and reviews

No ratings yet

No reviews yet.