paradedb
One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.
What is paradedb?
One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.
Overview of paradedb
What it is
ParadeDB is a Postgres extension that adds a custom index for full-text search, vector search, BM25 scoring, filters, facets, aggregations, and joins. It keeps application data and search in one database using standard SQL and ACID transactions. The project is built on Rust libraries: pgrx (Postgres–Rust bridge), Tantivy (full-text and vector search), and Apache DataFusion (OLAP processing).
Key features
- Full-text search with BM25 scoring, top K, highlighting, tokenizers, and token filters - Vector search - Hybrid search (combining full-text and vector)
- Filtering - Aggregates including columnar storage, bucket & metrics, and facets - JOINs
Use cases
ParadeDB is suited for applications that need both transactional data storage and search capabilities in a single Postgres database. Use cases include e‑commerce product search, content management systems, analytics dashboards, and any scenario requiring full-text search, vector similarity, or OLAP aggregations alongside standard relational data.
Getting started
To run ParadeDB locally with Docker and open a psql session: bash curl -fsSL https://paradedb.com/install.sh | sh For deployment, ParadeDB Cloud offers a fully managed experience; self‑hosted deployment options are also available.
License and pricing
ParadeDB Community is licensed under the GNU Affero General Public License v3.0 (AGPL-3.0). ParadeDB Enterprise is commercially licensed and included with ParadeDB Cloud; to self‑host Enterprise, contact sales.
Based on the project's public README and repository metadata.