CASCADE SOLUTIONS
All projects

CASE STUDY · RAG & AI

Internal AI assistant for a social services provider

Development of an internal RAG system providing employees with situation-specific access to policies, process documentation, and operational guidance.

PythonTypeScriptFastAPINext.jsOllamaPostgreSQLVercelDockerMicrosoft Azure

The challenge

In the daily work of a social-services organisation, employees often need to determine quickly which internal procedure applies to a specific situation—for example, after an accident involving a company vehicle or when handling a particular client situation.

The required information exists in internal documents but is not always immediately accessible. Different repository structures and extensive policies increase search effort, especially in time-critical situations.

The solution

The RAG system makes internal documents searchable through a straightforward chat interface. Employees can describe their situation in natural language and receive a contextual answer based on approved company documents.

Every response includes references to the underlying sources, allowing employees to verify the guidance directly against the currently applicable policy.

Technical architecture

A Next.js interface provides an accessible entry point for employees. The Python backend uses FastAPI to process documents, perform semantic retrieval, and prepare relevant context for Ollama.

The modular architecture supports operation in controlled infrastructure. PostgreSQL manages documents and metadata, while Docker enables reproducible deployment of the individual components.

Outcome

Employees gain faster access to binding internal information without manually searching through folder structures and long documents. Combining a concrete response with source references supports consistent and verifiable action in daily operations.

Core capabilities

  • AI-assisted access to internal policies and procedures
  • Situation-specific guidance for company-vehicle incidents
  • Retrieval of guidance for specific client situations
  • Automated extraction and indexing of internal documents
  • Source-grounded answers with document references
  • Integration with the organisation’s document structure

Planning a similar system?

I build custom RAG systems and internal AI chatbots around your documents, processes, and privacy requirements.

Explore RAG systems