ParadeDB

aid: paradedb
url: https://raw.githubusercontent.com/api-evangelist/paradedb/refs/heads/main/apis.yml
name: ParadeDB
kind: company
description: ParadeDB is an open-source Postgres extension stack (pg_search for BM25
  full-text search and pg_analytics for columnar OLAP) that turns PostgreSQL into a
  real-time search and analytics engine, positioned as an Elasticsearch alternative.
  Its interface is SQL over the PostgreSQL wire protocol - custom operators (@@@) and
  paradedb.* functions - not a REST API.
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/apis-json-logo.jpg
tags:
- Search
- Full-Text Search
- Analytics
- PostgreSQL
- Database
- Elasticsearch Alternative
created: '2026-06-20'
modified: '2026-06-20'
specificationVersion: '0.19'
apis:
- aid: paradedb:pg_search
  name: ParadeDB pg_search (Full-Text Search)
  tags:
  - Full-Text Search
  - BM25
  - Search
  - SQL
  image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/apis-json-logo.jpg
  humanURL: https://docs.paradedb.com/documentation/full-text/overview
  baseURL: postgresql://
  properties:
  - url: https://docs.paradedb.com/documentation/full-text/overview
    type: Documentation
  - url: https://docs.paradedb.com/documentation/getting-started/quickstart
    type: APIReference
  - url: https://github.com/paradedb/paradedb
    type: GitHub
  - url: openapi/paradedb-openapi.yml
    type: OpenAPI
  description: BM25 full-text search inside Postgres via the pg_search extension, built
    on Tantivy. Consumed as SQL over the PostgreSQL wire protocol - BM25 indexes are
    created with CREATE INDEX ... USING bm25, queried with the @@@ operator, and scored
    or highlighted with paradedb.score() and paradedb.snippet(). No REST API.
- aid: paradedb:analytics
  name: ParadeDB Analytics (pg_analytics)
  tags:
  - Analytics
  - OLAP
  - Columnar
  - SQL
  image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/apis-json-logo.jpg
  humanURL: https://docs.paradedb.com/documentation/aggregates/overview
  baseURL: postgresql://
  properties:
  - url: https://docs.paradedb.com/documentation/aggregates/overview
    type: Documentation
  - url: https://github.com/paradedb/paradedb
    type: GitHub
  - url: openapi/paradedb-openapi.yml
    type: OpenAPI
  description: Columnar storage, fast aggregates, and OLAP-style analytics over Postgres
    data, powered by Apache DataFusion and Postgres parallel workers. Accessed entirely
    through standard SQL aggregate queries over the PostgreSQL wire protocol - there
    is no REST interface.
- aid: paradedb:postgres-sql-interface
  name: ParadeDB Postgres SQL Interface
  tags:
  - PostgreSQL
  - SQL
  - Wire Protocol
  - Interface
  image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/apis-json-logo.jpg
  humanURL: https://docs.paradedb.com/welcome/introduction
  baseURL: postgresql://
  properties:
  - url: https://docs.paradedb.com/welcome/introduction
    type: Documentation
  - url: https://github.com/paradedb/paradedb
    type: GitHub
  - url: openapi/paradedb-openapi.yml
    type: OpenAPI
  description: The primary integration surface for ParadeDB - the PostgreSQL wire protocol
    itself. Any standard Postgres client, driver, or ORM (psql, libpq, Drizzle, Django,
    SQLAlchemy, Rails, EF Core) connects over the wire protocol and invokes ParadeDB
    features as SQL functions, operators, and index access methods. ParadeDB exposes
    no HTTP/REST or WebSocket API.
common:
- type: GitHubOrganization
  url: https://github.com/paradedb
- type: LinkedIn
  url: https://www.linkedin.com/company/paradedb
- type: Website
  url: https://www.paradedb.com
- type: Documentation
  url: https://docs.paradedb.com
- type: Plans
  url: plans/paradedb-plans-pricing.yml
- type: RateLimits
  url: rate-limits/paradedb-rate-limits.yml
- type: FinOps
  url: finops/paradedb-finops.yml
maintainers:
- FN: Kin Lane
  email: kin@apievangelist.com