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.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/paradedbparadedb.svg)](https://yunodb.com/tools/paradedbparadedb?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/paradedbparadedb?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/paradedbparadedb.svg" alt="Featured on YunoDB" height="20"></a>