Skip to Content

LLM PgVector

by
Odoo
v 18.0 Third Party 42
Download for v 18.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Community Apps Dependencies
Lines of code 5111
Technical Name llm_pgvector
LicenseLGPL-3
Websitehttps://github.com/apexive/odoo-llm
Versions 16.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Community Apps Dependencies
Lines of code 5111
Technical Name llm_pgvector
LicenseLGPL-3
Websitehttps://github.com/apexive/odoo-llm
Versions 16.0 18.0
PostgreSQL Vector Extension

LLM PgVector

Vector field and search capabilities using pgvector.

Use PostgreSQL as your vector store — no external services needed

Native PostgreSQL
Efficient Search
Open Source

What is pgvector?

Vector similarity search for PostgreSQL

pgvector is a PostgreSQL extension that adds support for vector similarity search. This module implements vector storage directly in your Odoo database, eliminating the need for external vector database services. Your embeddings stay alongside your data.

Features

Vector capabilities built into PostgreSQL

Variable Dimensions

Vector field type supporting variable dimensions to match your embedding model requirements.

Embedding Storage

Store and retrieve embeddings for knowledge chunks directly in PostgreSQL.

Vector Index Management

Manage vector indexes for optimized search performance on large datasets.

Efficient Vector Search

Perform fast similarity searches leveraging pgvector's optimized algorithms.

Why PgVector?

Benefits of using PostgreSQL for vectors

No Extra Services

Use your existing PostgreSQL database. No need to deploy and maintain separate vector databases.

Data Locality

Embeddings stay in your database alongside your business data. Better for security and compliance.

Transactional

Vector operations participate in PostgreSQL transactions. ACID guarantees for your AI data.

Technical Details

Requirements and dependencies

Module Information

Dependencies:

llm, llm_knowledge, llm_store

Python Packages:

pgvector, numpy

PostgreSQL Extension:

pgvector (auto-installed)

License:

LGPL-3

LLM PgVector

PostgreSQL vector storage for Odoo

Developed by Apexive Solutions LLC

Licensed under LGPL-3 • © 2025 All rights reserved.

github.com/apexive/odoo-llm
hello@apexive.com

pgvector Provider for Odoo LLM

PostgreSQL-native vector storage using pgvector extension.

Module Type: 🗄️ Vector Store (PostgreSQL Native)

Architecture

┌───────────────────────────────────────────────────────────────┐
│                    Used By (RAG Modules)                      │
│        ┌───────────────┐           ┌───────────────┐         │
│        │ llm_knowledge │           │llm_assistant  │         │
│        │   (RAG)       │           │  (with RAG)   │         │
│        └───────┬───────┘           └───────┬───────┘         │
└────────────────┼───────────────────────────┼─────────────────┘
                 └─────────────┬─────────────┘
                               ▼
              ┌───────────────────────────────────────────┐
              │             llm_store                     │
              │        (Vector Store API)                 │
              └─────────────────────┬─────────────────────┘
                                    │
                                    ▼
              ┌───────────────────────────────────────────┐
              │      ★ llm_pgvector (This Module) ★       │
              │         pgvector Implementation           │
              │  🐘 PostgreSQL │ Native │ No Extra Server │
              └─────────────────────┬─────────────────────┘
                                    │
                                    ▼
              ┌───────────────────────────────────────────┐
              │             PostgreSQL + pgvector         │
              │           (Your Odoo Database)            │
              └───────────────────────────────────────────┘

Installation

What to Install

For RAG with PostgreSQL vectors:

# 1. Install pgvector extension on PostgreSQL
# See: https://github.com/pgvector/pgvector

# 2. Install the Odoo module
odoo-bin -d your_db -i llm_knowledge,llm_pgvector

Auto-Installed Dependencies

  • llm (core infrastructure)
  • llm_store (vector store abstraction)

Why Choose pgvector?

Feature pgvector
Integration 🐘 Uses your Odoo PostgreSQL
Extra Server ❌ Not needed
Simplicity ✅ No external dependencies
Scale 📊 Good for moderate datasets

Vector Store Comparison

Feature llm_pgvector llm_qdrant llm_chroma
Server 🐘 PostgreSQL 🔷 Qdrant 🌈 Chroma
Setup Easy Moderate Moderate
Scale Medium High Medium
Best For Simple RAG Large scale Development

Common Setups

I want to... Install
Simple RAG llm_knowledge + llm_pgvector
Chat + RAG llm_assistant + llm_openai + llm_knowledge + llm_pgvector

Features

  • Native PostgreSQL vector storage
  • Cosine similarity search
  • Collection-specific indices
  • Metadata filtering
  • Uses existing Odoo database connection

Configuration

  1. Ensure pgvector extension is installed on your PostgreSQL server
  2. Install the module
  3. Configure vector store in LLM > Configuration > Vector Stores
  4. Set up knowledge base with pgvector as the storage backend

Technical Specifications

  • Version: 18.0.1.0.0
  • License: LGPL-3
  • Dependencies: llm, llm_store
  • Python Packages: pgvector, numpy

License

LGPL-3

© 2025 Apexive Solutions LLC

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.