One query to rule them all

| Documentation | Blog | Discord |

Korvus is a search SDK that unifies the entire RAG pipeline in a single database query. Built on top of Postgres with bindings for Python, JavaScript and Rust, Korvus delivers high-performance, customizable search capabilities with minimal infrastructure concerns.

https://github.com/postgresml/korvus/assets/19626586/2b697dc6-8c38-41a7-8c8e-ef158dacb29b

🦅 What is Korvus?

Korvus is an all-in-one, open-source RAG (Retrieval-Augmented Generation) pipeline built for Postgres. It combines LLMs, vector memory, embedding generation, reranking, summarization and custom models into a single query, maximizing performance and simplifying your search architecture.

🔠 Languages

Korvus provides SDK support for multiple programming languages, allowing you to integrate it seamlessly into your existing tech stack:

• Python: PyPI Package
• JavaScript: npm Package
• Rust: Crates.io Package
• C: Build from source

🏆 Why Korvus?

Korvus stands out by harnessing the full power of Postgres for RAG operations:

1. Postgres-Native RAG: Korvus leverages Postgres' robust capabilities, allowing you to perform complex RAG operations directly within your database. This approach eliminates the need for external services and API calls, significantly reducing latency and complexity many times over.

2. Single Query Efficiency: With Korvus, your entire RAG pipeline - from embedding generation to text generation - is executed in a single SQL query. This "one query to rule them all" approach simplifies your architecture and boosts performance.

3. Scalability and Performance: By building on Postgres, Korvus inherits its excellent scalability and performance characteristics. As your data grows, Korvus grows with it, maintaining high performance even with large datasets.

⚡ Key Features

• Simplified Architecture: Replace complex service oriented architectures with a single, powerful query.
• High Performance: Eliminates API calls and data movement for faster processing and greater reliability.
• Open Source: Improve your developer experience with open source software and models that run locally in Docker too.
• Multi-Language Support: Use Korvus with Python, JavaScript and Rust. Open an issue to vote for other language support.
• Unified Pipeline: Combine embedding generation, vector search, reranking, and text generation in one query.
• Postgres-Powered: Under the hood, Korvus operations are powered by efficient SQL queries on a time-tested database platform.

🧩 System Architecture

Korvus utilizes PostgresML's pgml extension and the pgvector extension to compress the entire RAG pipeline inside of Postgres.

🚀 Get Started

📋 Prerequisites

To use Korvus, you need a Postgres database with pgml and pgvector installed. You have two options:

1. Self-hosted: Set up your own database with pgml and pgvector.

   • For instructions, see our self-hosting guide.

2. Hosted Service: Use our managed Postgres service with pgml and pgvector pre-installed.

   • Sign up for PostgresML Cloud.

🏁 Quick Start

1. Install Korvus:

pip install korvus

2. Set the KORVUS_DATABASE_URL env variable:

export KORVUS_DATABASE_URL="{YOUR DATABASE CONNECTION STRING}"

3. Initialize a Collection and Pipeline:

from korvus import Collection, Pipeline
import asyncio

collection = Collection("korvus-demo-v0")
pipeline = Pipeline(
    "v1",
    {
        "text": {
            "splitter": {"model": "recursive_character"},
            "semantic_search": {"model": "Alibaba-NLP/gte-base-en-v1.5"},
        }
    },
)

async def add_pipeline():
    await collection.add_pipeline(pipeline)

asyncio.run(add_pipeline())

4. Insert documents:

   
   async def upsert_documents():
   documents = [
       {"id": "1", "text": "Korvus is incredibly fast and easy to use."},
       {"id": "2", "text": "Tomatoes are incredible on burgers."},
   ]
   await collection.upsert_documents(documents)

asyncio.run(upsert_documents())

5. Perform RAG
```python
async def rag():
    query = "Is Korvus fast?"
    print(f"Querying for response to: {query}")
    results = await collection.rag(
        {
            "CONTEXT": {
                "vector_search": {
                    "query": {
                        "fields": {"text": {"query": query}},
                    },
                    "document": {"keys": ["id"]},
                    "limit": 1,
                },
                "aggregate": {"join": "\n"},
            },
            "chat": {
                "model": "meta-llama/Meta-Llama-3-8B-Instruct",
                "messages": [
                    {
                        "role": "system",
                        "content": "You are a friendly and helpful chatbot",
                    },
                    {
                        "role": "user",
                        "content": f"Given the context\n:{{CONTEXT}}\nAnswer the question: {query}",
                    },
                ],
                "max_tokens": 100,
            },
        },
        pipeline,
    )
    print(results)

asyncio.run(rag())

🔍 The Power of SQL

While Korvus provides a high-level interface in multiple programming languages, its core operations are built on optimized SQL queries. This approach offers several advantages:

• Transparency: Advanced users can inspect and understand the underlying queries.
• Customizability: Extend Korvus's capabilities by modifying or adding to its SQL operations.
• Performance: Benefit from PostgreSQL's advanced query optimization capabilities.

Don't worry if you're not a SQL expert - Korvus's intuitive API abstracts away the complexity while still allowing you to harness the full power of SQL-based operations.

📘 Documentation

For comprehensive documentation, including API references, tutorials, and best practices, visit our official documentation.

🌐 Community

Join our community to get help, share ideas, and contribute:

• Discord
• Twitter

🤝 Contributing

We welcome contributions to Korvus! Please read our Contribution Guidelines before submitting pull requests.

Korvus is maintained by PostgresML. For enterprise support and consulting services, please contact us.