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.
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  method: derived
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/paradedb.png
tags:
- Search
- Full-Text Search
- Analytics
- PostgreSQL
- Database
- Elasticsearch Alternative
created: '2026-06-20'
modified: '2026-06-20'
specificationVersion: '0.23'
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/_original/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/_original/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
  - Interfaces
  tags_raw:
  - 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/_original/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: VulnerabilityDisclosure
  url: security/paradedb-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/paradedb-domain-security.yml
- url: https://paradedb.com/blog
  type: Blog
- 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