Ask your assessment data anything — in plain English
AI Insights turns natural-language questions into safe, org-scoped queries against your hiring and L&D assessment results. No SQL, no waiting on the analytics team, no exports. Ask in plain English; get a markdown table back in seconds.
Already a customer? Sign in to your dashboard
What AI Insights actually does
Natural-language to validated SQL
An LLM turns your question into a PostgreSQL query against a curated set of read-only views. The query is comment-stripped and validated server-side — only SELECT, only the assessment views, no system catalogs, no file or network access — before it ever hits the database.
9 curated assessment views
Hiring candidates and L&D participants with full competency scores and bands; per-section breakdowns for case studies, SJTs, MCQs and voice interviews; job profiles and L&D assessments with aggregated stats; reviewer notes; and the competency requirements per job. Every view is automatically filtered to your organisation.
Markdown answers, not raw rows
Kaairo's AI doesn't dump query output at you. It presents results as clean markdown tables and lists, flags low scores constructively, and explicitly refuses to make hiring or promotion recommendations — those calls stay with your team. If the results are empty, it tells you so and suggests a modified question.
The analytics layer your HR data has been missing
HR and recruiting teams have rich assessment data and no easy way to interrogate it. Dashboards answer fixed questions; spreadsheets are stale the moment they're exported. AI Insights closes the gap.
Answer the question you actually have
Dashboards show what the product team decided to show. AI Insights answers what you ask: 'What's the average overall score for our last 3 PM hires?', 'Which competencies separate Superior from Established candidates in the Sales role?', 'Show me top performers in each of the last 5 L&D campaigns.'
No SQL, no analytics-team dependency
Hiring leaders and L&D managers can answer their own questions in seconds. Frees the analytics team to work on harder problems — and frees the leadership team from waiting in queue for one-off reports.
Hiring and L&D data, side by side
Most HR analytics tools silo hiring from learning. AI Insights queries both, with parallel views (ai_insights_hiring_v and ai_insights_lnd_v) and shared scoring bands — so 'Compare our PM candidates to our PM employees on Strategic Thinking' is a one-line question.
Read-only, by design
AI Insights can read, never write. Every query is validated to start with SELECT or WITH, contain no mutation keywords, and reference only the allowlisted views. Even the AI cannot accidentally modify your data.
Org-isolated at the database layer
Multi-tenant isolation is enforced by the database RPC that executes the query — not by the prompt. Even a perfectly crafted prompt cannot reach another organisation's data; the org_id scope is applied server-side before the query runs.
Built on your assessments, not a generic data warehouse
AI Insights knows what 'top performer' means, what the competency framework is, how bands are computed, and how proctoring flags work — because the views and glossary are purpose-built for assessment data. No semantic-layer setup required.
Three steps from question to answer
No dashboard configuration, no setup, no SQL. Open the chat and type.
Type your question in plain English
Open AI Insights from your org dashboard. Ask anything assessment-related — completion rates, top performers, competency averages, per-section breakdowns, candidate notes search, proctoring flags. If the question can be answered from your data, AI Insights will generate the query.
Validation, then execution
The generated SQL is validated server-side — SELECT-only, comment-stripped, table allowlist enforced. The query then runs via a Postgres RPC that scopes every result to your organisation. You never see the SQL unless you want to.
Get a clean, scoped answer
Results come back as markdown tables and lists with score bands (Superior 80-100, Established 60-79, Developing 40-59, Limited 0-39), constructive framing on low scores, and explicit refusal to make hiring or promotion calls — those stay with your team. Ask follow-up questions in the same conversation.
Powerful queries with hard-coded safety
AI Insights ships with multi-layer guardrails so the only thing the model can do is help you read your own data.
SELECT-only, mutation keywords blocked
Server-side validation rejects any query that doesn't start with SELECT or WITH, or that contains insert, update, delete, drop, create, alter, truncate, grant, revoke or copy — even when those keywords are hidden inside comments. Comments are stripped before validation runs.
View allowlist, not raw tables
Queries can only read from nine purpose-built ai_insights_* views. Direct access to underlying tables, pg_catalog, information_schema, auth schema, or any function that touches the filesystem or network (pg_read_file, dblink, lo_import) is blocked.
Tenant scope at the RPC layer
Even if a query reaches Postgres, it runs inside exec_ai_insight_query which applies the org_id filter before executing. The LLM cannot escape the tenant boundary; the database enforces it.
Owner and manager only
AI Insights is gated to org owners and managers. Members do not see the page. Combined with the Enterprise+ tier requirement, access is limited to the people who already have visibility into the underlying data.
No fabrication, no recommendations
The synthesis prompt is explicit: never fabricate numbers; only use what came back from the query. Never make hiring or promotion recommendations. Present data, let humans decide. AI Insights is a fast analyst, not a decision-maker.
Explore Related Solutions
Discover more ways Kaairo can help your organization hire and develop talent.
Frequently Asked Questions
What kinds of questions can I ask AI Insights?
Anything that can be answered from your hiring and L&D assessment data. Typical examples: 'How many candidates completed assessments this month?', 'Top 3 performers for each of the last 3 hiring assessments', 'Average score by department', 'What competency scores does Priya have?', 'Interview performance for the PM role', 'Score breakdown by test type for Software Engineer candidates'. If a question is outside the scope of the assessment views, AI Insights returns NOT_ANSWERABLE rather than guessing.
Which data is available to query?
Nine curated views covering: hiring candidates with overall scores, bands, competency breakdowns, dimension scores, and proctoring flags; L&D participants with the same shape; voice interview scores with strengths and areas for improvement; per-section results (case study, SJT, MCQ, interview); job profiles and L&D assessments with aggregated stats; reviewer notes; and the competency requirements per job.
Can AI Insights modify my data?
No. Validation rejects any query that contains insert, update, delete, drop, create, alter, truncate, grant, revoke or copy — including when those keywords are hidden inside SQL comments. The query must start with SELECT or WITH. Even the AI cannot accidentally change anything.
Can the AI see data from other organisations?
No. Queries are executed via a Postgres RPC that applies your org_id as a hard filter at the database layer — not via the prompt. Multi-tenant isolation is enforced by the database, not the model. A perfectly crafted prompt cannot cross the tenant boundary.
Who in my organisation can use AI Insights?
Org owners and managers. Members are redirected away from the page. AI Insights is also tier-gated to Enterprise+, so the people who can access it already have full visibility into the underlying assessment data.
What model is used and how is it kept consistent?
Kaairo runs AI Insights on GPT-4o-mini at temperature 0.0 (deterministic) with structured prompts that include the schema, a glossary, and example queries. The same question gets the same SQL every time, so the same data gets the same answer.
Does AI Insights replace dashboards?
No — it complements them. Dashboards are still the right surface for the metrics you check every day. AI Insights is for the questions that come up once and don't justify building a new dashboard: a specific role, a specific date range, a specific competency combination, a one-off comparison.
Is AI Insights included in all plans?
AI Insights is available on the Enterprise+ plan. Custom Analytics — scatter plots, correlation matrices, and side-by-side candidate radar comparisons — is available on Enterprise and Enterprise+.
See AI Insights answer your data questions
Request a demo and we'll show you AI Insights running on a realistic assessment dataset configured to look like yours.
Talk to us about your team
Share a few details about your org and what you're trying to solve. We'll follow up with a short call or an async walkthrough of how Kaairo can plug into your hiring, benchmarking, or L&D workflows.