Can iDBQuery combine several databases and spreadsheets in one answer?
Yes — iDBQuery builds one live queryable model across all your connected sources, so a single question can join, say, a Postgres database, a SQL warehouse and an Excel spreadsheet at once. You ask in plain language and iDBQuery reasons across them together, citing each figure to its source.
This is iDBQuery's core idea: rather than querying sources one at a time, it stitches them into one live queryable model you can ask a single question against.
- Connect each source once. A MySQL or Postgres database, a warehouse like Snowflake or BigQuery, an Excel/Google Sheet, a CRM over the REST API connector — each connects with the standard flow and gets introspected.
- Ask one cross-source question. For example: *"For each region, show pipeline from the CRM, invoiced revenue from the warehouse, and this month's targets from the planning spreadsheet."*
- iDBQuery joins them for you. It works out how the sources relate (using the semantic layer), writes the SQL, runs it across all of them, and returns a single cited table, chart or live dashboard.
The differentiator versus a traditional stack: there's no ETL, no staging database, and no need to load everything into one warehouse first — iDBQuery queries each source in place and federates the results. And because every figure is cited back to the exact source row and system it came from, a number that blends a database and a spreadsheet is still fully auditable. It's ideal for reconciling systems that disagree, or for reports that have always required manually copying between tools. Deploy in the cloud, your VPC, or air-gapped, and every connected source stays where it lives.
Updated 2026-06-22
Related questions
- Can iDBQuery query several different sources at the same time?
- How do I answer a question that spans several databases and spreadsheets at once?
- Can I connect a data warehouse to iDBQuery?
- How do I reconcile numbers that disagree between two systems?
- Do I need to build a pipeline or ETL before connecting a source?