# What is a vector database?

> A vector database stores embeddings so AI can find content by meaning. What it is, how it differs from a spreadsheet, and when a small business needs one.

Source: https://learn.ynteractive.com/content/glossary/vector-database · Updated 2026-10-01 · Free from Stepthrough (https://learn.ynteractive.com)

[AI basics](https://learn.ynteractive.com/content/glossary#topic-ai-basics) · [AI glossary](https://learn.ynteractive.com/content/glossary)

Updated October 1, 2026 · By [Robert Breen](https://learn.ynteractive.com/content/about)

A vector database stores embeddings, the numeric fingerprints of text or images, and finds the ones closest in meaning to a question. AI tools use it to pull the most relevant passages from a large collection of documents before writing an answer.

## Why it matters for a small business

A spreadsheet or regular database is great when you know exactly what you are looking for: the row where Status is Draft, every deal at Fernhill Lawn Care. A vector database answers a fuzzier question: which of these thousands of notes, emails or manuals are about something like this? That is the question an AI assistant needs answered before it can respond from your own material.

Most small businesses do not need one at the start. A system prompt, a short knowledge file or a Google Sheet covers a lot. A vector database becomes worth it when your reference material is too big to paste, changes often, and has to be searched by meaning, such as a growing library of support answers or past job notes.

## In a real lesson: Build an n8n AI Agent That Writes Deal Follow-Ups

Stepthrough's live lessons do not build a vector database, but the [deal follow-up agent lesson](https://learn.ynteractive.com/content/n8n-ai-agent-sales-deal-follow-ups) shows the kind of storage it would sit beside. You build an n8n agent for Northwind Scheduling Software, a made-up software company, and give it a Google Sheets Tool set to **Append Row**. Each follow-up becomes a row with columns for Prospect, Company, Stage, Follow-up Message and Next Step.

That sheet is ordinary structured storage. You can filter it by Stage or find every row for Maple Row Cleaning, because you know the exact values. It cannot answer "which past follow-ups were about a prospect who went quiet after seeing pricing?" unless someone typed those exact words.

A vector database handles that second kind of question. In n8n you would add a vector store node with an embeddings model, load past follow-ups into it, and connect it to the agent as a tool, so a request like Jen Walsh's "quiet since pricing" can pull similar past cases before the agent writes.

[Try this lesson free](https://learn.ynteractive.com/modules/n8n-ai-agent-sales) or [read the step-by-step guide](https://learn.ynteractive.com/content/n8n-ai-agent-sales-deal-follow-ups).

## Common confusions

### Vector database vs Google Sheets

[Google Sheets](https://learn.ynteractive.com/content/glossary/google-sheets) stores rows and columns you look up by exact values. A vector database stores meaning and finds near matches. Many automations use both: the sheet for records, the vector store for searching text.

### Vector database vs agent memory

[Agent memory](https://learn.ynteractive.com/content/glossary/agent-memory) like n8n's Simple Memory keeps the recent conversation. A vector database holds a large, lasting collection of documents to search. One remembers the chat; the other is a library.

## Tips

- Start with a knowledge file or a pasted reference; move to a vector database only when the material is too big or changes too often.
- Plan how documents get updated or removed, or the store will keep returning stale answers.

## Related terms

[Embeddings](https://learn.ynteractive.com/content/glossary/embeddings) · [Retrieval-augmented generation (RAG)](https://learn.ynteractive.com/content/glossary/rag) · [Knowledge base](https://learn.ynteractive.com/content/glossary/knowledge-base) · [Google Sheets (as an automation database)](https://learn.ynteractive.com/content/glossary/google-sheets) · [Agent memory](https://learn.ynteractive.com/content/glossary/agent-memory)

## Where to learn more

[n8n tutorials](https://learn.ynteractive.com/content/tool/n8n)

## Frequently asked questions

**Does n8n support vector databases?**

Yes. n8n has vector store nodes for several databases, plus a simple in-memory option, and embeddings nodes to go with them. You connect them to an AI Agent so it can search your documents.

**Is a vector database the same as a regular database?**

No. A regular database finds exact matches in structured fields. A vector database finds items with similar meaning, which suits search over text.

[All AI glossary terms, A to Z](https://learn.ynteractive.com/content/glossary) · [Free prompt templates](https://learn.ynteractive.com/content/prompts)