Prompt

Code Review & DebuggingPromptIn a pack

Ecto Data Layer Review — Schemas, Changesets, Query Composition, N+1 Queries and Safe Migrations

Reviews an Elixir application's Ecto layer — schema and association design, changesets per use case, validation and constraint errors, preloading to avoid repeated queries, composable queries, transactions with Multi, and database migrations that are safe on large production tables.

  • Role-Based
  • Step-by-Step
  • Constraints
  • Structured Output

Opening lines · ~292 words in full

ROLE: You are an Elixir engineer who specialises in Ecto and PostgreSQL. Data layer problems — one changeset for every purpose, missing database constraints, queries in loops and locking migrations — cause most production incidents in otherwise healthy Phoenix apps, so you review …

Written by the PromptCorrectly team© 2026 PromptCorrectly · All rights reserved

How to use it

  1. Read it, then replace anything in [BRACKETS] with your details — the more concrete the context, the sharper the answer.
  2. Copy it (or download the .md) and paste it into the AI you already use — it knows your work, so that is where the prompt does the most.
  3. Want a sharper answer? Ask the AI to check its own draft against your brief before it replies — that is self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Step-by-Step

Forces explicit intermediate reasoning instead of jumping to a conclusion, which improves accuracy on hard tasks.

Learn this technique
Constraints

Sets the rules and boundaries — tone, length, what to avoid — that keep the output on-target.

Learn this technique
Structured Output

Pins the response to a defined structure so it drops straight into your workflow.

Learn this technique

Works with

Any chat AI — ChatGPT, Claude, Gemini, Copilot, Grok, Mistral or a local model. The structure does the work, so you are not tied to one vendor or one model version.

New to structured prompts? Start with how to prompt AI, the RCTCO prompt framework this prompt is built on, and role prompting examples.

More in Code Review & Debugging

Pull Request Review With Severity TriageReviews a pull request diff and returns issues bucketed by blocking, major, minor, and nit severity with concrete fixes.Root-Cause Analysis From a Stack TraceWalks a stack trace and surrounding code step by step to isolate the true root cause and propose a minimal verified fix.Security-Focused Code AuditAudits a code module against the OWASP Top 10 and common weakness patterns, reporting exploitability and remediation.Concurrency And Race Condition HunterInspects multithreaded or async code for races, deadlocks, and visibility bugs and proposes safe synchronization.