paradedb

Search without a second system.
One Postgres for your application data, full-text search, vector retrieval, and aggregations.

Website • Docs • Community • Blog • Changelog

     

--- ## Installation To install ParadeDB locally in a fresh Docker container and drop straight into a `psql` session: ```bash curl -fsSL https://paradedb.com/install.sh | sh ``` When you're ready to deploy, check out our [hosting options](https://www.paradedb.com/docs/operate/deploy/overview). ## What is ParadeDB? [ParadeDB](https://paradedb.com) 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](https://www.paradedb.com/docs/concepts/full-text/overview) - [x] [BM25 Scoring](https://www.paradedb.com/docs/reference/full-text/score) - [x] [Top K](https://www.paradedb.com/docs/reference/full-text/top-k) - [x] [Highlighting](https://www.paradedb.com/docs/reference/full-text/highlight) - [x] [Tokenizers & Token Filters](https://www.paradedb.com/docs/reference/tokenizers/overview) - [x] [Vector Search](https://www.paradedb.com/docs/reference/vector/overview) - [x] [Hybrid Search](https://www.paradedb.com/docs/reference/hybrid/overview) - [x] [Filtering](https://www.paradedb.com/docs/reference/filtering/overview) - [x] [Aggregates](https://www.paradedb.com/docs/reference/aggregates/overview) - [x] [Columnar Storage](https://www.paradedb.com/docs/reference/indexing/columnar) - [x] [Bucket & Metrics](https://www.paradedb.com/docs/reference/aggregates/overview) - [x] [Facets](https://www.paradedb.com/docs/reference/aggregates/facets) - [x] [JOINs](https://www.paradedb.com/docs/reference/joins/overview) Star and watch this repository to follow along. See our [current projects](https://github.com/paradedb/paradedb/projects?query=is%3Aopen) and [long-term roadmap](https://www.paradedb.com/docs/project/roadmap). ## How It Works ParadeDB integrates battle-tested Rust libraries for search and analytics inside Postgres, contributing upstream whenever possible. Our primary dependencies are: - [pgrx](https://github.com/pgcentralfoundation/pgrx) — bridges Postgres and Rust - [Tantivy](https://github.com/quickwit-oss/tantivy) — powers full-text and vector search - [Apache DataFusion](https://github.com/apache/datafusion) — handles OLAP processing For a deeper dive, see our [architecture docs](https://www.paradedb.com/docs/concepts/architecture) or [CMU Database Group talk](https://db.cs.cmu.edu/events/building-blocks-paradedb-philippe-noel/). ## Integrations ParadeDB integrates with the tools you already use, with more on the way. ### ORMs & Frameworks - [Drizzle](https://github.com/paradedb/drizzle-paradedb) - [Django](https://github.com/paradedb/django-paradedb) - [SQLAlchemy](https://github.com/paradedb/sqlalchemy-paradedb) - [Rails](https://github.com/paradedb/rails-paradedb) - [EF Core](https://github.com/paradedb/efcore-paradedb) - More coming (Prisma, and others) ### AI Agents - [Agent Skills](https://github.com/paradedb/agent-skills) - [MCP Integration](https://www.paradedb.com/docs/start/ai-agents) - [Cursor Plugin](https://cursor.com/marketplace/parade-db) ### PaaS & Cloud Platforms - [Railway](https://www.paradedb.com/docs/operate/deploy/cloud-platforms/railway) - [Render](https://www.paradedb.com/docs/operate/deploy/cloud-platforms/render) - [Fly.io](https://www.paradedb.com/docs/operate/deploy/cloud-platforms/fly) - [DigitalOcean](https://www.paradedb.com/docs/operate/deploy/cloud-platforms/digitalocean) - [Dokku](https://www.paradedb.com/docs/operate/deploy/cloud-platforms/dokku) - More coming (Heroku, and others) ## Community & Support - [Slack](https://paradedb.com/slack) — ask questions, share what you're building - [GitHub Discussions](https://github.com/paradedb/paradedb/discussions) — longer-form Q&A - [GitHub Issues](https://github.com/paradedb/paradedb/issues/new/choose) — bug reports and feature requests - [Email](mailto:[email protected]) — enterprise support and commercial licensing ## Contributing We welcome contributions of all sizes! Check out our [good first issues](https://github.com/paradedb/paradedb/labels/good%20first%20issue) to get started. For larger contributions, we recommend discussing them with us in [Slack](https://paradedb.com/slack) first. See our [Contributing Guide](/CONTRIBUTING.md) and [Code of Conduct](/CODE_OF_CONDUCT.md) for details. ## License ParadeDB Community is licensed under the [GNU Affero General Public License v3.0](LICENSE). For [ParadeDB Enterprise](https://www.paradedb.com/docs/operate/deploy/enterprise) licensing, contact [[email protected]](mailto:[email protected]).