Skip to content
Thinkwise

Problems, solved end to end

Named engagements with a defined scope, a team behind them and an outcome to hit - the work you can put a contract around.

Records Intelligence

Agentic RAG over decades of records.

ARCHIVECITED ANSWER

Delivered for a large Australian metropolitan council: years of scattered records turned into an archive staff can ask questions of, with every answer traceable to the report it came from.

Decades of records, none of them searchable

The engagement

What was in the way?

Years of inspection reports, compliance files, contracts and spreadsheets sat scattered and unsearchable. Staff spent hours each week digging through archives to answer routine questions, and knowledge left when people did.

We built an Agentic RAG application. Staff upload records; the system embeds them for semantic search and pairs a structured database alongside the vector store, so numeric data keeps its meaning and trends are answered from real figures, not guesses.

What was in the way

  • Scattered records - inspection reports, compliance files, contracts and spreadsheets, none of it searchable

  • Hours lost weekly - staff digging through archives to answer routine questions

  • Knowledge walked out - what people knew left when they did

What we built

  • Agentic RAG - staff upload records, the system embeds them for semantic search

  • A structured database alongside the vector store - numeric data keeps its meaning

  • Trends answered from real figures, not guesses

What it runs on

AI & technology
  • Claude Sonnet
  • Titan Embed v2
  • OpenSearchVector store
  • DuckDBStructured data
  • AWS LambdaServerless layer
  • Amazon S3
  • React
  • Amazon CognitoSSO
  • Microsoft Entra IDSSO

What changed for the council

Business outcomes
  • Reporting turnaround fell from hours or days to minutes

  • Executives self-serve answers mid-meeting

  • Every figure is traceable to its source report

  • Institutional knowledge now survives staff turnover

Ask your own archive a question

If your records hold answers nobody can reach, this is the shape of the fix. Tell us what you are sitting on.