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
- DOCX (Microsoft Word)
How it works
When you upload a document:
- Aicser extracts the text
- The text is split into chunks and converted to vector embeddings
- 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
- Go to Knowledge Base in the sidebar
- Click Upload Document
- Select a PDF or DOCX file
- 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