What is the Analyst agent in iDBQuery?
The Analyst is iDBQuery's autonomous agent that investigates a question on its own. Instead of answering a single query, it plans an approach, runs multiple queries, tests hypotheses, and reports back with findings and cited evidence — like handing a hard, open-ended question to a tireless data analyst.
Most data tools answer the exact question you typed. The Analyst agent answers the question *behind* the question. You give it something open-ended — "why did churn rise last quarter?" — and it works the problem autonomously.
It operates in a loop:
- Plans an investigation strategy for your question
- Queries your live model, often running many queries in sequence
- Forms and tests hypotheses — checking whether a spike is driven by a region, a product, a cohort
- Drills down as the evidence leads, following threads a single query would miss
- Reports back with a narrative of findings, each backed by cited source rows
This is what separates iDBQuery from a one-shot text-to-SQL tool. The Analyst doesn't just translate a question into a query; it reasons across many queries to reach a conclusion, the way a person would.
It's ideal for anomaly investigations, root-cause analysis, and any "I'm not even sure what to ask" situation. Because every step is grounded in your real data and cited, you get not just an answer but a transparent trail of how it got there — something you can review, trust, and defend.
Updated 2026-06-22