How does iDBQuery connect to my databases and files?
iDBQuery connects to your data through a guided connection screen: enter credentials for a database, or upload a spreadsheet, PDF or folder. It supports MySQL, PostgreSQL, MongoDB, Excel, CSV, Google Sheets, PDFs and REST APIs, then reads each source's structure automatically with nothing to install.
Connecting a source in iDBQuery takes a few clicks, not a project. You pick the source type and provide what it needs:
- Databases (MySQL, PostgreSQL, MongoDB): host, port, database name and read-only credentials.
- Files (Excel, CSV, PDFs): drag and drop, or point iDBQuery at a whole folder.
- Google Sheets: paste a share link.
- REST APIs: give the endpoint and authentication, and iDBQuery pulls the data on a schedule you set.
The moment a source is connected, iDBQuery introspects it — reading every table, column and type for databases, and the headers and content for files. It saves that structure as a schema memory so it always knows what lives where. You connect once; from then on you just ask questions in plain language. Read-only credentials are enough for everything iDBQuery does, so it never has to write back to your systems. Nothing is installed on your servers, and you can connect several sources at once and query across all of them together.
Updated 2026-06-22