# zombodb/zombodb

Making Postgres and Elasticsearch work together like it's 2023

Repository: https://github.com/zombodb/zombodb
Canonical: https://ross.abutalabs.com/products/zombodb
Homepage: https://www.zombodb.com/
Language: PLpgSQL
License: NOASSERTION
License Family: other
Topics: postgres, elasticsearch, postgresql, text-search, sql
Archived: true
Last push: 2025-03-01T19:28:06+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 9, release rhythm 16, longevity 100
- inputs: {"age_days": 4065, "days_push": 550, "days_rel": 550, "gap_med": 118, "n_releases_24m": 2}
- flags: archived, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 4719, forks 213 (observed 2026-08-28T04:08:57.495309+00:00)

## What it is
ZomboDB is a native Postgres extension, written in Rust with PGRX, that uses Elasticsearch as a Postgres index type to bring powerful text search and analytics to relational data. It manages remote Elasticsearch indices transactionally via standard SQL commands like CREATE INDEX, with its own ZQL query language and query builder API.

## Use cases
- add full-text search to postgres tables
- query postgres data with elasticsearch
- keep elasticsearch index in sync with postgres transactions
- run aggregations and analytics on relational data via elasticsearch
- search across multiple postgres tables with cross-index joins
- use elasticsearch query DSL from SQL

## When to choose
- you already run Postgres and Elasticsearch and want transactionally-correct search without building sync pipelines
- you want to manage search indices entirely through SQL
- you need Elasticsearch aggregations, scoring, and highlighting over relational data

## When to avoid
- you don't use Postgres or don't want an Elasticsearch dependency
- you need a simple standalone search engine without a database
- you require official binary installs without sponsoring the project

## Facets
- artifact type: library
- maturity: active
- function: search-engine, database, database-driver
- domain: databases, developer-tools
- platform: windows, rust, self-hosted
- tags: postgres-extension, elasticsearch, full-text-search, zql, index-access-method, sql, search, linux, macos

## Member repositories
- zombodb/zombodb (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:57.495309+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-29T18:19:06.457463+00:00, confidence not recorded.
  - readme: https://github.com/zombodb/zombodb (fetched 2026-08-28T04:08:57.495309+00:00, sha 6d2e968d93ca)
- Data as of 2026-08-30T08:39:29.467469+00:00.