paradedb/paradedb

One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.

What it solves

ParadeDB eliminates the need to maintain a separate search engine alongside a primary database. It allows developers to store application data, perform full-text search, execute vector retrieval, and run complex aggregations all within a single Postgres instance, removing the overhead of deploying second systems and syncing data between them.

How it works

ParadeDB extends Postgres by integrating high-performance Rust libraries directly into the database engine. It uses pgrx to bridge Postgres and Rust, Tantivy to power full-text and vector search, and Apache DataFusion to handle OLAP (analytical) processing.

Who it’s for

Developers and database administrators who want to combine transactional data storage with powerful search and analytics capabilities without the complexity of managing multiple database technologies.

Highlights

  • Unified Storage: Combines application data, full-text search, and vector retrieval in one place.
  • Advanced Search: Supports BM25 scoring, Top K results, highlighting, and hybrid search.
  • Analytical Power: Includes columnar storage, facets, and metrics for fast aggregations.
  • Broad Integration: Works with popular ORMs like Drizzle, Django, and SQLAlchemy, and integrates with AI agents via MCP and Cursor plugins.

Related

  • Project
    ChuckHend/pg_vectorize

    A Postgres server and extension that automates text-to-embedding transformation and orchestration for vector, full-text, and hybrid search to enable RAG.

  • Project
    supervc-stack/VectorChord-bm25

    A PostgreSQL extension that implements the BM25 ranking algorithm and Block-WeakAnd indexing to provide native, high-performance full-text search and relevance scoring.

  • Project
    pgvector/pgvector

    An open-source PostgreSQL extension that enables vector similarity search, allowing users to store embeddings and perform nearest neighbor queries within their relational database.

  • Project
    pgvector/pgvector-node

    A JavaScript/TypeScript client library that enables Node.js, Deno, and Bun applications to use the pgvector PostgreSQL extension for storing and querying vector embeddings.

  • Project
    pgvector/pgvector-go

    A Go client library providing support for the pgvector PostgreSQL extension to enable vector similarity search and storage in Go applications.