Skip to main content
Enterprise Edition

The knowledge base requires Aicser Enterprise Edition.

Knowledge Base

The knowledge base lets you upload documents that the AI references when answering questions. Use it to provide business context — metric definitions, data dictionaries, terminology — that helps the AI generate more accurate queries.

Supported formats

  • PDF
  • DOCX (Microsoft Word)

How it works

When you upload a document:

  1. Aicser extracts the text
  2. The text is split into chunks and converted to vector embeddings
  3. Embeddings are stored in PostgreSQL using pgvector (or JSONB cosine similarity as a fallback)

When you ask a question, Aicser retrieves the most relevant chunks and includes them as context in the AI prompt. This is Retrieval-Augmented Generation (RAG).

Uploading documents

  1. Go to Knowledge Base in the sidebar
  2. Click Upload Document
  3. Select a PDF or DOCX file
  4. Wait for processing to complete

Use cases

  • Data dictionary — explain what each table and column means
  • Business glossary — define company-specific terms
  • Metric definitions — specify how KPIs are calculated