← Prompt Library / Engineering
Review a schema design for integrity, query patterns, and future pain: keys, indexes, nullability, and the migrations you'll regret not planning.
Review this schema: {{schema}} (tables/DDL). How it will be queried: {{query_patterns}}. Expected scale: {{scale}}.
Check: primary key choices, foreign keys and cascade behaviour (deliberate or accidental?), nullability (every nullable column is a promise of NULL-handling everywhere), data types (money as integer cents? timestamps with zones?), indexes vs my stated query patterns (missing? redundant?), naming consistency, and where denormalisation is or isn't justified at my scale. Flag the future migrations this design makes painful, and the 'we'll fix it later' choices that never get fixed.
Fields like {{ this }} are placeholders — replace them with your own details, or let Aria ask you for them.
This prompt runs with Aria connected to your email, files, CRM and 40+ other services — and you can schedule it to run automatically.
Start Free WeekReview a diff for correctness, security, and readability issues.
Get a plain-English walkthrough of unfamiliar code.
Generate thorough unit tests for a function.
Diagnose an error systematically: likely causes ranked with reasoning, the cheapest test for each, a...
Build a regular expression from a plain-English requirement — explained token by token, tested again...
Turn a plain-English data question into a working SQL query — with the assumptions stated, a readabl...