ParadeDB is a PostgreSQL extension that adds fast full-text, vector, and analytics search directly inside Postgres.
- for
- Developers and teams needing search/analytics without a separate Elasticsearch cluster.
- pricing
- free
- license
- AGPL-3.0
- v0.25.1023 days ago
- v0.26.0-rc.1a month ago
- v0.25.9a month ago
Key features
- Postgres extension — Installs as a native extension, no side-car process, using CREATE EXTENSION pg_search.
- Unified index — Creates an inverted, vector and columnar index on tables with CREATE INDEX USING paradedb.
- SQL-based search — Search is expressed as standard WHERE clauses, supporting joins, CTEs, JSONB, etc.
- ACID & replication — Full transaction support and high-availability via physical replication and read replicas (Enterprise).
- Tunable BM25 & typo tolerance — Provides Elasticsearch-style ranking, fuzzy, phrase and regex queries.
- Zero ETL — Keeps application data in-place; no separate search cluster or data sync required.
Use cases
- Add real-time full-text search to an existing Postgres app without a separate Elasticsearch cluster
- Perform vector similarity search alongside relational queries in the same database
- Accelerate join-heavy analytics queries that include text filters and facets
ParadeDB FAQ
How do I install ParadeDB?+
Run the provided install script or add the extension with CREATE EXTENSION pg_search in any self-managed Postgres instance.
Do I need a separate server for search?+
No, ParadeDB runs as a native index inside Postgres, eliminating the need for an external Elasticsearch cluster.
Can I use ParadeDB with existing tables?+
Yes, it works on existing tables without schema changes; you just create a ParadeDB index on the table.
Is ParadeDB open source?+
Yes, the extension is open source and available on GitHub.
What high-availability options are available?+
Physical replication and read replicas are supported in the Enterprise plan.
Does ParadeDB support vector search?+
Yes, it provides vector search alongside full-text search using a unified index.
Summarized by DevHunt from paradedb.com · Sep 28, 2026. Details may change; check the official site.
