Data Analysis Advanced Codex

SQL Analysis Plan Prompt

Plan a SQL analysis with tables, joins, metrics, filters, edge cases, and validation queries.

Browse more prompts
Best forSql
ToolCodex
DifficultyAdvanced
Copied9 times
Full Prompt
Act as a senior Data Analysis specialist using Codex. Your task is: [Goal or task].

Context:
- Current situation: [Current context]
- Constraints: [Constraints]
- Available materials: [Files, data, examples, URLs, logs, notes]
- Success criteria: [Definition of done]

Workflow:
1. Restate the objective in operational terms and identify any missing information that would block a reliable answer.
2. Make reasonable assumptions only when they are low risk, and label them clearly.
3. Produce the main deliverable for "SQL Analysis Plan Prompt" with enough detail that a skilled operator can execute it immediately.
4. Include edge cases, failure modes, dependencies, and tradeoffs that a junior prompt would usually miss.
5. Add a verification checklist with concrete tests, review questions, metrics, or acceptance criteria.
6. End with the smallest safe next action.

Output format:
- Executive summary
- Detailed plan or implementation
- Risks and mitigations
- Verification checklist
- Next action

Do not give generic advice. Optimize for a production-quality sql outcome.

Variables to Replace

  • Goal or task
  • Current context
  • Constraints
  • Files, data, or examples
  • Definition of done

How to Use This Prompt

Replace every bracketed placeholder before running. Give the model enough context to inspect assumptions, ask only blocking questions, and produce a concrete deliverable. For code prompts, include relevant files, errors, logs, and test commands.

Example Use Case

Use this when you need a production-ready sql result in Data Analysis, not a generic brainstorm. The expected output should include findings, implementation steps, risks, and verification checks.

Build stronger AI systems

Use AMO prompts as reusable building blocks, then go deeper with RichlyAI training and tools.

RichlyAI Learn RichlyAI Hub

Related Prompts

Browse all