ParadeDB is a Rust Postgres extension that adds a custom index for BM25 full-text search, vector search, filters, facets, aggregations and joins. Search runs inside Postgres with standard SQL and ACID transactions, so no separate search engine is needed. It builds on pgrx, Tantivy and Apache DataFusion, and offers ORM integrations plus agent skills and MCP docs.
Who it is for: Teams adding search and vector retrieval to an existing Postgres
Strengths
Search and application data share one Postgres with ACID transactions
Covers BM25, vector and hybrid search, facets and aggregates in SQL
ORM integrations for Drizzle, Django, SQLAlchemy, Rails and EF Core
Built on Tantivy and DataFusion rather than a custom engine
Weaknesses
Community edition is AGPL-3.0; Enterprise needs a commercial license
Self-hosting Enterprise requires contacting sales
No embedding or document ingestion pipeline included
xerjElasticsearch-compatible search server that auto-indexes folders for coding agents
Live demo ↗
(opens in a new tab)18.8k stars+15,424 (+452%) in 30 daysApache-2.0
86 out of 100score
2
llm-appYAML-configured RAG server that keeps a vector database synced with a document folder58.7k stars+111 (+0.2%) in 30 daysMIT