Local authority
Local authority·Design and deployment·8 weeks

A RAG assistant on the deliberations, queryable by officers and elected representatives.

RAG assistant built on the corpus of deliberations and reports of the authority. Mistral model hosted in France, hybrid pgvector and Qdrant search, systematic citations pointing back to the source deliberation. No data leaves the sovereign infrastructure.

The context

The deliberations, minutes and reports of a local authority represent several thousand pages produced each year. Officers lose considerable time finding a past decision, its context and its regulatory framework. Use of a consumer assistant was ruled out, both for confidentiality reasons concerning some in-progress reports and for political positioning on the digital sovereignty of the authority.

The need

An assistant that ingests the deliberative corpus, keeps it updated automatically at each new session, and lets both officers and elected representatives find a deliberation, an argument or a piece of administrative case law within seconds. Every answer had to point to the exact deliberation with its date and number. The infrastructure had to be hosted with a French cloud provider, with no dependency on a provider subject to the Cloud Act.

What we delivered

An automated ingestion pipeline for deliberations, with extraction, chunking and embedding computation. Hybrid storage combining pgvector for structured metadata and Qdrant for semantic search. Mistral model hosted on OVHcloud in the Gravelines region. FastAPI API exposing the assistant to the authority's internal applications. Architecture document setting out data residency, the absence of Cloud Act exposure, and the mapping to AI Act and GDPR obligations for a public service use. Training of internal officers included in the delivery.

Results

recall@10 0.87
retrieval quality measured on an evaluation set
100%
answers cited with the source deliberation
100% EU
infrastructure hosted with a French provider
A similar project?
Scoping in 30 minutes
Assistant RAG sur délibérations pour collectivité | Ceres Broker