CodingData Whisperer
From vague business question to correct SQL, every time.
Data Whisperer fixes the classic failure of AI-generated SQL: confident queries against misunderstood schemas. The pack's core ritual forces the model to interrogate your schema, confirm grain and join keys, and state its assumptions before writing a line of SQL.
Beyond generation, you get query-optimisation prompts that read EXPLAIN plans, dbt modelling guides that enforce naming and testing conventions, and metric-definition templates that end the 'why does your number differ from mine' meetings. Tested against Postgres, BigQuery and Snowflake.
What's inside
- 95 prompts for the analytics workflow
- Schema interrogation and grain-confirmation rituals
- EXPLAIN-plan optimisation guides
- dbt modelling and testing conventions
- Metric definition and governance templates
- Lifetime updates — every revision, forever
Sample prompts
A free taste of the pack — copy them, run them, judge us on the output.
Here is my schema: [DDL OR TABLE LIST]. Business question: [QUESTION]. Do NOT write SQL yet. First: 1) restate the question as a precise metric definition including grain, filters and time window, 2) list the tables and join keys you'll use and any ambiguity you see, 3) ask me up to 3 clarifying questions. Only after my answers, write the SQL for Postgres.
Here is a slow query and its EXPLAIN ANALYZE output: [QUERY + PLAN]. Diagnose the top 3 bottlenecks in plain language, then provide a rewritten query for each bottleneck with the expected improvement and any index or table-change recommendations. Note anything that suggests the data model itself is the problem.
Built for
Correct SQL the first time
Schema-first prompts eliminate the confident-but-wrong joins that waste analyst afternoons.
Speed up slow queries
Paste a query and its EXPLAIN plan; get indexed, re-written versions with expected impact.
One source of truth
Metric templates lock definitions, owners and edge-case handling into your docs.
95 prompts · Data Whisperer
Works with
- Instant delivery to your inbox
- 30-day money-back guarantee
- Lifetime updates included