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