Do You Actually Need a Vector Database? An Insurance Reality Check

Somewhere in every insurer's 2026 roadmap is a line item for a vector database, because that's what you buy when you're "doing AI." Sometimes it's the right call. Often it's a solution bought ahead of the problem — an expensive piece of infrastructure adopted because it's fashionable, then underused because nobody stopped to ask what question it was meant to answer. Here's an honest reality check before you sign the contract.

What a vector database is actually for

A vector database stores embeddings — numerical representations of text (or images) — and finds items by semantic similarity rather than exact keywords. Ask "what's my excess for water damage?" and it can retrieve the relevant policy clause even if the document says "escape of water" and "deductible." That semantic retrieval is the engine behind RAG — feeding a language model the right context so it answers from your documents instead of hallucinating. For genuine natural-language search over large unstructured corpora, it's the right tool.

The key phrase is large unstructured corpora. That's where vector search earns its keep. Outside that, it's often overkill.

When you don't need one

  • Your data is structured. If the question is "what's the sum insured on policy 12345?", that's a database lookup, not a similarity search. A shocking number of "AI" projects reach for vectors to answer questions a SQL query answers better, faster, and exactly.
  • Your corpus is small. A few hundred documents don't need a dedicated vector store. Postgres with the pgvector extension handles modest embedding workloads comfortably, and you avoid running a whole new piece of infrastructure.
  • Keyword search would do. If users search for known terms and codes, a good full-text index is cheaper, simpler, and more precise. Semantic search shines on fuzzy natural language, not exact-term lookup.
  • You haven't solved retrieval quality. A vector database doesn't make retrieval good. Bad chunking, missing metadata, and no re-ranking produce confidently-wrong answers no matter how fancy the store.

The trap: infrastructure before use case

The failure pattern is buying the vector database first and then hunting for something to point it at. You end up running, securing, and paying for a specialized system that serves one half-finished chatbot. The right order is the opposite: identify a real natural-language-over-documents problem, prototype retrieval on the simplest thing that works (often pgvector), and only graduate to a dedicated vector database when scale or performance genuinely demands it. Most insurers never hit that ceiling for their first several use cases.

The questions to ask first

  1. Is the question semantic or exact? Similarity search vs lookup. Be honest — a lot of it is lookup.
  2. How big is the corpus, really? Thousands of documents rarely justify dedicated infrastructure.
  3. Have we solved chunking, metadata, and re-ranking? Retrieval quality lives here, not in the store.
  4. Would pgvector do for now? Start there; migrate only when you've proven you need to.

None of this is anti-vector-database. It's pro-solving-the-right-problem. The reason RAG projects underdeliver in insurance is almost never the choice of vector store — it's the document engineering underneath it: extraction, structure-aware chunking, metadata, and knowing when a plain query beats a similarity search. That foundational work — figuring out what your data actually is and the simplest architecture that answers the real question — is what we focus on with insurers at IntelliBooks.

Buy the vector database when the problem asks for it. Not because the roadmap has a slot for one.

Comments

Popular posts from this blog

Why Your Insurance Data Warehouse Didn't Fix Anything

Straight-Through Processing: From 10% to 90%

Embedded Insurance: Why the API Is the Easy Part