HR & People Data · iDBQuery
people analytics software, answered: ask your HR data in plain English
iDBQuery is people analytics software that lets HR teams chat with their own data. Ask about headcount, attendance, turnover, or payroll the way you'd say it out loud, and iDBQuery writes the SQL, runs it, and hands back the answer — as a number, a table, a chart, or a full dashboard. There is no query language to learn and no ticket to file with IT.
Headcount, attendance, and turnover — without IT. HR people data lives across an HRIS, payroll exports, attendance logs, and a stack of spreadsheets, and the answers usually wait on someone who can write a query. iDBQuery connects to those sources directly, infers the schema, resolves the joins for you, and lets you ask the question yourself — so you get a defensible attrition number or a real-time headcount before the meeting, not after it.
The HR questions iDBQuery answers in plain English
HR runs on recurring questions that take seconds to query and days to get answered. iDBQuery lets you type the question conversationally — across headcount, attendance, turnover, and payroll — and returns the answer already shaped as the clearest chart or table.
- "What's our headcount by department and location this month versus last quarter?"
- "Which teams have the highest 12-month attrition, and is it voluntary or involuntary?"
- "Show me absence and late-arrival trends by site over the last 90 days."
- "What's the average tenure of people who left in the last year?"
- "Where is overtime concentrated, and how does it track against payroll cost?"
Connect every HR data source — HRIS, payroll, attendance, spreadsheets
People data is scattered by design: the HRIS holds the org, payroll lives in another system, attendance comes off a separate clock, and half the analysis still happens in Excel. iDBQuery connects to all of it — upload a file or paste a connection string, and the schema auto-detects.
Because it builds cross-source dashboards, you can put headcount from your HRIS database next to cost from a payroll export and attendance from a CSV in a single view, without an integration project.
- SQL databases behind your HRIS or core HR system — MySQL, PostgreSQL, SQL Server, Oracle, Snowflake, BigQuery, and more
- Payroll and headcount exports as Excel, CSV, or Google Sheets
- Attendance and time logs from spreadsheets or your HR database
- Policy and offer documents in PDF or Google Docs
- Cross-source dashboards that combine HRIS, payroll, and attendance in one view
No SQL, no IT ticket — schema and joins handled for you
The reason headcount and turnover questions stall is that someone has to know the table structure and write the join. iDBQuery removes that step: it infers the schema automatically and resolves joins and foreign keys on its own, so it understands how employees, departments, contracts, and attendance records relate without you mapping them.
That means an HR business partner can answer a turnover question directly, instead of opening a ticket and waiting on the data team for a one-off chart.
- Natural language to SQL — you write the question, iDBQuery writes the query
- Automatic schema detection across your HR tables and files
- AI-driven join resolution so employee, payroll, and attendance data line up correctly
- Self-service answers for HRBPs and people-ops, no analyst in the loop
- Charts and dashboards produced from the answer, not built by hand
Built for the sensitivity of people data
People data is some of the most sensitive a company holds, so iDBQuery is built to query it carefully. Credentials are encrypted at rest, and a read-only mode means iDBQuery can answer questions against your HR systems without the ability to change a single record.
Scheduled distribution closes the loop for recurring HR reporting: a monthly headcount and attrition dashboard or a weekly attendance summary can be built once and sent out automatically to the people who need it.
- Encrypted credentials stored at rest
- Read-only mode — query your HR systems without write access
- Scheduled report and dashboard distribution for monthly HR reviews
- One dashboard your whole HR team can return to, always current
Start free, and grow into the wider iDBQuery family
You can put your first HR questions to iDBQuery on the free tier — 1M tokens a month, 3 data sources, and 5 saved reports, with no credit card. That's enough to connect your HRIS, a payroll export, and an attendance file and start asking real questions.
iDBQuery is one conversational engine used across many domains — finance, sales, HR, healthcare, government, education, and research — and, through its SiteMind sub-product, construction site intelligence, clash detection, and BIM cost tracking. HR teams in firms that build also get the people-data answers here and the project-data answers in SiteMind from the same platform.
- Free tier: 1M tokens/month, 3 data sources, 5 saved reports, no credit card
- Connect an HRIS, a payroll export, and an attendance file in three steps
- Same engine spans finance, sales, HR, healthcare, government, education, and research
- SiteMind extends iDBQuery to construction — site intelligence, clash detection, BIM cost tracking
- Built and supported by Intrazero, Cairo-headquartered and founded in 2016
FAQ
What is people analytics software?
People analytics software helps HR teams turn headcount, attendance, turnover, and payroll data into answers and dashboards. iDBQuery does this conversationally: you ask a question about your people data in plain English, it writes the SQL, runs it, and returns the answer as a number, chart, or dashboard — no query language and no IT ticket required.
Can iDBQuery answer headcount, attendance, and turnover questions without IT?
Yes. That's the point of using iDBQuery for HR data — headcount, attendance, and turnover without IT. You ask in plain English, and iDBQuery generates the SQL, resolves the joins across your HR tables, and returns the answer, so an HR business partner can get an attrition or headcount figure directly instead of filing a ticket.
Do I need to know SQL to analyze HR data with iDBQuery?
No. iDBQuery is built so HR and people-ops don't have to write SQL. You type the question the way you'd say it, and iDBQuery auto-detects the schema, resolves the joins between employees, departments, payroll, and attendance, writes the query, and gives you the answer.
What HR data sources does iDBQuery connect to?
iDBQuery connects to the SQL database behind your HRIS or HR system (MySQL, PostgreSQL, SQL Server, Oracle, Snowflake, BigQuery, and more), to payroll and headcount exports in Excel, CSV, or Google Sheets, to attendance logs, and to documents in PDF or Google Docs. It can combine them in one cross-source dashboard.
Is iDBQuery safe to use on sensitive employee data?
iDBQuery stores credentials encrypted at rest and offers a read-only mode, so it can answer questions against your HR systems without the ability to change any record. Combined with scheduled distribution for recurring reports, it lets HR query sensitive people data in a controlled way.
Is there a free version of iDBQuery for HR teams?
Yes. iDBQuery has a free tier with 1M tokens per month, 3 data sources, and 5 saved reports, with no credit card required. That's enough for an HR team to connect their HRIS, a payroll export, and an attendance file and start asking headcount and turnover questions right away.
Ask your people data, not your IT team
See how iDBQuery turns your HRIS, payroll exports, and attendance logs into plain-English answers and dashboards — headcount, attendance, and turnover, without IT. Start free or talk to the Intrazero team.
Request a demo