PP

paradedb/paradedb

Developer tools
9.4K stars Quality 66 Trend 88AGPL-3.0

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

Overview

Search without a second system. One Postgres for your application data, full-text search, vector retrieval, and aggregations. Website • Docs • Community • Blog • Changelog To install ParadeDB locally in a fresh Docker container and drop straight into a psql session: When you're ready to deploy, check out our hosting options. ParadeDB upgrades Postgres with a custom index for fast full-text and vector search, BM25 scoring, filtering, and aggregations. Your application data and search engine live in one database, with no second system to deploy and nothing to sync. - [x] Full-Text Search - [x] BM25 Scoring - [x] Top K - [x] Highlighting - [x] Tokenizers & Token Filters - [x] Vector Search - [x] Hybrid Search - [x] Filtering - [x] Aggregates - [x] Columnar Storage - [x] Bucket & Metrics - [x] Facets - [x] JOINs Star and watch this repository to follow along. See our current projects and long-term roadmap.

README

Just use Postgres. One Postgres for your application data, full-text search, vector retrieval, and aggregations.

Website • Docs • Community • Blog • Changelog

     


Installation

To run ParadeDB locally with Docker and open a psql session:

curl -fsSL https://paradedb.com/install.sh | sh

When you’re ready to deploy, get started on ParadeDB Cloud for a fully managed experience, or explore our self-hosted deployment options.

What is ParadeDB?

ParadeDB upgrades Postgres with a custom index for fast full-text and vector search, BM25 scoring, filters, facets, aggregations, and joins. Built as a Postgres extension, it keeps your application data and search engine in one database with standard SQL and ACID transactions.

Star and watch this repository to follow along. See our current projects and long-term roadmap.

How It Works

ParadeDB integrates battle-tested Rust libraries for search and analytics inside Postgres, contributing upstream whenever possible. Our primary dependencies are:

For a deeper dive, see our architecture docs or CMU Database Group talk.

Integrations

ParadeDB integrates with the tools you already use, with more on the way.

ORMs & Frameworks

AI Agents

PaaS Providers

Community & Support

Contributing

We welcome contributions of all sizes! Check out our good first issues to get started. For larger contributions, we recommend discussing them with us in Slack first. See our Contributing Guide and Code of Conduct for details.

License

ParadeDB Community is licensed under the GNU Affero General Public License v3.0.

ParadeDB Enterprise is commercially licensed and included with ParadeDB Cloud. To self-host ParadeDB Enterprise, contact sales.

View this README on GitHub

Recommended Tools

Try a different keyword or remove a filter.

Install

npx skillfish add paradedb/paradedb