xtdb/xtdb

Health v2 · maintenance only

Flags: no_readme

Adoption not part of the score

3045 stars · 192 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

XTDB is an open-source (MPL-2.0) immutable, bitemporal SQL database built on Apache Arrow and S3-compatible storage. It automatically retains full data history, supports SQL:2011 temporal queries, and connects via Postgres wire-compatible and FlightSQL interfaces.

Use cases

• query the past state of my data with time travel
• build an auditable system of record without handcrafted audit tables
• run bitemporal SQL reporting with backdated corrections
• store immutable records for data compliance
• connect a Postgres client to a temporal database
• report on business state as-of a past timestamp

When to choose

• you need automatic full history retention and as-of queries
• compliance or audit requires bitemporal reporting
• you want Postgres-compatible SQL over immutable, cloud-native storage

When to avoid

• you need heavy mutable OLTP workloads with frequent updates
• you require a mature ecosystem of tooling and extensions like Postgres
• you need low-latency transactional writes at very high throughput

Facets

application · maturity active

database search-engine databases analytics developer-tools jvm self-hosted cloud sql bitemporal temporal-database immutable-database time-travel audit clojure apache-arrow postgres-wire-compatible flightsql docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="xtdb/xtdb")