How do I answer a question that spans several databases and spreadsheets at once?
iDBQuery answers a question that spans several databases and spreadsheets by federating them into one live model and querying them together. Ask once — "compare sales from our database with the budget in this spreadsheet" — and iDBQuery joins across sources and returns a single cited answer, no warehouse or pipeline required.
The usual way to answer a cross-source question is to export each system, line them up in a spreadsheet by hand, and hope the keys match. iDBQuery does it as one query.
- Federate, don't migrate — connect a database, a few spreadsheets, a document set, and an API, and iDBQuery builds a single queryable model over all of them in place.
- Ask across everything — "Which products in our sales database are below the target margin set in this pricing sheet?" joins the two automatically; you never specify where each field lives.
- One cited answer — the result traces every figure back to the source row in whichever system it came from, so a number combining three sources is still fully auditable.
- No pipeline to build — there is no ETL, no warehouse load, and no schedule to wait on; sources answer live.
This is the core of iDBQuery: instead of moving data into one place before you can analyze it, it queries the places where your data already lives and unifies the results. A finance figure from your database, an adjustment from a spreadsheet, and a status from a REST API combine into one answer. When the question is complex, the Analyst agent runs the multi-step investigation across all of them and writes up what it found.
Updated 2026-06-22