Data & Research prompts
Analysis, summarization, SQL and research synthesis.
SQL Query Writer with Explanation
Writes correct SQL from a plain-English question and your schema — states its assumptions, explains the query in plain language, and flags the edge cases in your data.
Faithful Executive Summary (Zero Hallucination)
Summarizes long documents under a strict faithfulness contract: every claim traceable to the source, uncertainty preserved, nothing smoothed over.
Slow Query Optimizer
Diagnoses a slow SQL query from its EXPLAIN plan: identifies the actual bottleneck, proposes fixes in order of effort, and predicts the improvement of each.
Spreadsheet Formula Engineer (Excel & Google Sheets)
Builds the formula you describe in plain English — then explains it part by part, states its breaking conditions, and offers a cleaner LET/helper-column alternative.
Exploratory Data Analysis Plan
Builds a rigorous EDA plan for a new dataset: data quality gauntlet first, then targeted hypotheses, with the exact plots and the traps each one hides.
Literature Review Synthesizer
Synthesizes multiple papers into a thematic review — where studies agree, where they conflict and why, and what nobody has studied yet.
Research Paper Deconstructor
Breaks an academic paper into what was claimed, what was actually shown, and how much to trust it — methods scrutiny, effect sizes over p-values, and the graveyard of caveats.
Zero-Downtime Schema Migration Review
Reviews DDL migrations for the locks and table rewrites that take production down — version-aware for Postgres and MySQL, with a safe step-by-step rewrite for anything risky.
Analytics SQL Correctness Review
Reviews analytical queries for the bugs that produce confidently wrong numbers: join fan-out double counting, NULL traps, timezone truncation, and averaged averages.
Statistical Claim Sanity Checker
Audits a report, dashboard, or claim for the classic statistical sins — base-rate blindness, survivorship, seasonality, percent-of-what confusion — before you forward it.
Survey Designer & Bias Auditor
Drafts a survey from your research questions, then audits every item against the classic bias catalog — leading wording, double-barreled items, scale traps, and order effects.