# paradedb/paradedb

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

Repository: https://github.com/paradedb/paradedb
Canonical: https://ross.abutalabs.com/products/paradedb
Homepage: https://paradedb.com
Language: Rust
License: AGPL-3.0
License Family: copyleft
Topics: sparse-vector, hybrid-search, bm25, full-text-search, analytics, olap, htap, real-time-analytics, aggregations, similarity-search, postgresql, vector-database, vector-search, postgresql-extension, search-engine, mpp, columnar-storage, semantic-search, distributed-search, rust
Last push: 2026-08-26T23:57:26+00:00

## Health v2 (maintenance only)
Score: 91/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 87, longevity 82
- inputs: {"age_days": 1160, "days_push": 7, "days_rel": 6, "gap_med": 4, "n_releases_24m": 140}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 9199, forks 440 (observed 2026-08-28T04:10:28.843518+00:00)

## What it is
ParadeDB is a Postgres extension (pg_search) that adds a custom index for fast full-text search, vector search, BM25 scoring, filtering, and aggregations directly inside PostgreSQL. It lets teams run application data and search workloads in one database instead of syncing to an external engine like Elasticsearch.

## Use cases
- add full-text search to my postgres database
- replace elasticsearch with postgres
- run vector similarity search in postgres
- hybrid keyword and semantic search in one database
- bm25 relevance scoring with sql
- avoid syncing postgres data to a separate search engine
- real-time analytics and aggregations on postgres
- build rag retrieval over application data

## When to choose
- Postgres is already your primary database and you want search without a second system
- You've outgrown tsvector or pgvector performance or features
- You want to eliminate ETL pipelines syncing data to Elasticsearch
- You need BM25, vector, and hybrid search with transactional guarantees in standard SQL

## When to avoid
- You don't use PostgreSQL as your database
- You need a standalone search engine decoupled from your OLTP database
- You require managed cloud search today (ParadeDB Cloud is still in waitlist)
- You need Postgres versions older than 15 or unsupported platforms without building from source

## Facets
- artifact type: plugin
- maturity: active
- function: search-engine, vector-database, database, database-driver, analytics
- domain: databases, analytics, developer-tools
- platform: windows, self-hosted, cloud, rust, cpp
- tags: postgresql-extension, pg_search, bm25, full-text-search, hybrid-search, vector-search, columnar-storage, htap, elasticsearch-alternative, sql, search, retrieval-augmented-generation, linux, macos, docker

## Member repositories
- paradedb/paradedb (main) score 91

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:10:28.843518+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:23:18.778616+00:00, confidence not recorded.
  - readme: https://github.com/paradedb/paradedb (fetched 2026-08-28T04:10:28.843518+00:00, sha ada873a9c2b3)
  - homepage: https://paradedb.com (fetched 2026-08-29T08:23:19.147283+00:00, sha b541e792325f)
  - site_page: https://www.paradedb.com/docs/welcome/introduction (fetched 2026-08-29T08:23:19.156655+00:00, sha aa4721c699f3)
  - site_page: https://www.paradedb.com/docs/documentation/getting-started/install (fetched 2026-08-29T08:23:19.158601+00:00, sha 350319ac626f)
  - site_page: https://www.paradedb.com/docs/deploy/self-hosted/extension (fetched 2026-08-29T08:23:19.160103+00:00, sha 8f0a0c58f228)
  - site_page: https://www.paradedb.com/docs/documentation/getting-started/ai-agents (fetched 2026-08-29T08:23:19.161953+00:00, sha 44396d35586f)
  - site_page: https://www.paradedb.com/docs/documentation/getting-started/environment (fetched 2026-08-29T08:23:19.164167+00:00, sha 3ca3707c289b)
  - site_page: https://www.paradedb.com/docs/changelog (fetched 2026-08-29T08:23:19.167227+00:00, sha b75763b210ac)
- Data as of 2026-08-30T08:39:29.467469+00:00.