Research & Academia · iDBQuery
Research Data Analytics in Plain English with iDBQuery
iDBQuery brings research data analytics to institutional research offices, grants teams, and faculty — without anyone writing a line of SQL. Your institution's research lives in too many places: an IR warehouse here, a grants spreadsheet there, survey exports, a publications database, and a pile of CSVs from the last study. iDBQuery turns all of it into a conversation. You ask in plain English, it auto-generates the SQL, resolves the joins across your tables, and hands back the answer as a number, a chart, or a dashboard.
Your institution's research is intelligence, not a spreadsheet. Instead of waiting on the data team to pull funding totals or publication counts, a research administrator asks the question directly and gets a live answer. iDBQuery detects your schema automatically, understands the foreign keys between grants, awards, and investigators, and combines sources you could never join by hand — so reporting season stops being a scramble.
The questions a research office actually asks
Research and academic teams don't think in tables and joins — they think in grants, papers, cohorts, and outcomes. iDBQuery lets them ask in exactly those terms and writes the SQL underneath, inferring how your grants, awards, publications, and investigator tables relate.
- "How much grant funding did each department win this fiscal year versus last?"
- "List our publications from the last 3 years by faculty, with citation counts."
- "Which active awards have under 90 days of runway left and an unspent balance?"
- "What's the response rate on the student-experience survey by college and term?"
- "Show co-authorship across departments for the last grant cycle."
Connects to every source your research lives in
Institutional research is scattered by nature. iDBQuery connects across SQL and NoSQL databases, spreadsheets, and documents at once, and resolves the joins between them — so a grants spreadsheet, a publications database, and a survey export can answer a single question together.
You connect in seconds: upload a file or paste a connection string, and iDBQuery auto-detects the schema. No data warehouse project, no modelling phase.
- SQL databases your IR/ERP stack runs on — PostgreSQL, MySQL, SQL Server, Oracle, Snowflake, BigQuery, Redshift, and more
- MongoDB for document-style research and study data
- Excel, CSV, and Google Sheets — grant trackers, budget sheets, survey exports
- PDFs and Google Docs — protocols, reports, and proposal documents
- Cross-source dashboards that join funding, output, and survey data in one view
From a question to a shared, scheduled dashboard
iDBQuery follows three steps — Connect, Ask, Share — so a one-off question becomes a recurring deliverable. Build a research-output or funding dashboard once, then schedule it to distribute itself to deans, PIs, or a board on the cadence you set.
That turns the quarterly research report, the grants pipeline review, and the annual publications roundup from manual data-pulls into dashboards that keep themselves current.
- Connect: upload files or paste a connection string; the schema auto-detects
- Ask: type questions in English, get answers plus charts
- Share: build dashboards and schedule report distribution to stakeholders
- Self-updating views for funding, publications, and survey programs
- One source of truth for reporting season, not a fresh export each time
Built for sensitive institutional data
Research data includes human-subjects survey responses, grant financials, and unpublished results — none of which should be flowing through ad-hoc exports. iDBQuery stores connection credentials encrypted at rest and can operate in read-only mode, so analysts get answers without write access to live systems.
Backed by Intrazero, a Cairo-headquartered enterprise software company founded in 2016, iDBQuery is built with native Arabic and English from the ground up — fitting institutions that report in both.
- Encrypted credentials stored at rest
- Read-only mode — query without exposing systems to writes
- Native Arabic and English interface
- Built and supported by Intrazero
Start free, prove the value
You don't need a procurement cycle to find out whether iDBQuery fits your research office. The free tier lets a team connect their real grants sheet and IR extract and ask real questions on day one.
And iDBQuery is one product across many verticals — the same engine serves Construction through its SiteMind sub-product (site-intelligence mapping, clash detection, BIM cost tracking from IFC, BCF, Speckle, and Autodesk APS), alongside Finance, Sales, HR, Healthcare, Government, and Education — so what works for research scales with the rest of your institution.
- 1M tokens per month, free
- 3 data sources and 5 saved reports on the free tier
- No credit card to start
- Connect a real grants sheet plus an IR extract and ask on day one
FAQ
What is research data analytics with iDBQuery?
Research data analytics with iDBQuery means asking your institution's research data — grants, publications, survey results, and institutional-research datasets — in plain English instead of writing SQL. iDBQuery auto-generates the query, resolves the joins across your sources, and returns the answer as a number, chart, or dashboard.
Can iDBQuery analyze grants and funding data?
Yes. Point iDBQuery at your grants spreadsheet, awards database, or finance system and ask questions like funding won by department, awards nearing their end date, or unspent balances. It infers the foreign keys between grants, awards, and investigators and writes the SQL for you.
Does iDBQuery work with survey and publications data?
Yes. iDBQuery connects to survey exports (Excel, CSV, Google Sheets), publications databases, and document sources like PDFs and Google Docs. You can ask about survey response rates by college or list publications by faculty with citation counts, and combine those with funding data in a single dashboard.
Do researchers need to know SQL to use iDBQuery?
No. iDBQuery is built so research administrators, grants officers, and faculty never write SQL. You type the question the way you'd say it, and iDBQuery auto-detects the schema, generates the SQL, resolves the joins, and runs it — so non-analysts get answers themselves.
Is institutional research data kept secure in iDBQuery?
Yes. iDBQuery stores connection credentials encrypted at rest and supports read-only mode, so analysts can query live systems without write access. That suits sensitive institutional data such as human-subjects survey responses, grant financials, and unpublished results.
Is there a free way to try iDBQuery for research?
Yes. iDBQuery's free tier includes 1M tokens per month, 3 data sources, and 5 saved reports, with no credit card required. A research office can connect a real grants sheet and an IR extract and start asking questions the same day.
Turn your institution's research into intelligence
See how iDBQuery lets your research office ask grants, publications, and survey data in plain English — and build cross-source dashboards in minutes. Start free or talk to the Intrazero team.
Request a demo