What is a data source in iDBQuery?
A data source in iDBQuery is any single system or file you connect — a MySQL or Postgres database, a MongoDB store, an Excel or CSV file, a folder of PDFs, or a REST API. Each source you add becomes part of the one live model you can query together.
In iDBQuery, a data source is one connected origin of data. You can add as many as you need, and they don't have to be the same kind — that's the point.
Supported source types include:
- Databases — MySQL, PostgreSQL and MongoDB, connected directly so queries hit the live system.
- Spreadsheets and files — Excel, CSV and Google Sheets uploaded or linked in.
- Documents — PDFs and scanned files, including whole folders ingested with OCR so their contents become queryable.
- APIs — REST endpoints connected as a live source, with recurring sync to stay current.
When you connect a source, iDBQuery introspects its structure, captures the schema, and folds it into the single live model alongside everything else you've connected. From that point on, you don't think in terms of individual sources when you ask a question — you ask in plain language and iDBQuery decides which sources to reach into, queries them in place, and returns one cited answer.
This mix-and-match design is what lets a single question span, for example, a production database, a finance spreadsheet and a contract PDF at the same time — no separate exports, no manual stitching.
Updated 2026-06-22