Doltgres

active

by DoltHub · since 2023 · also known as DoltgreSQL

Version-controlled SQL database with PostgreSQL compatibility: branch, diff and merge your tables.

relationaldocumentdatabase engineopen source (permissive)emerging

Overview

Doltgres (DoltgreSQL) is DoltHub's PostgreSQL-flavored sibling of Dolt. It reuses Dolt's prolly-tree storage engine and Git-style commit graph, but speaks the PostgreSQL wire protocol and dialect, so psql, Postgres drivers and ORMs can connect while you branch, diff, merge and time-travel over tables with SQL functions. It reached 1.0 in August 2026 and DoltHub now calls it production-ready, though its Postgres coverage (extensions, some types and catalog behavior) is still narrower than real PostgreSQL. It suits teams in the Postgres ecosystem that need data versioning and review workflows more than raw throughput.

Strengths & trade-offs

Strengths

  • +Git-style branch, diff and merge of tables from SQL
  • +Point-in-time queries against any commit
  • +Works with psql and standard Postgres drivers
  • +Shares Dolt's mature versioned storage engine
  • +Clone and push databases between remotes

Trade-offs

  • −Only a subset of PostgreSQL extensions, types and catalog features
  • −Slower than PostgreSQL for high-volume OLTP
  • −Young 1.x product with a short production record
  • −No horizontal scaling

Great for

  • +Versioned reference data for Postgres-based apps
  • +Reproducible ML datasets
  • +Safe data migrations tested on branches
  • +Agent or CI sandboxes that branch data

Think twice for

  • −Apps relying on Postgres extensions such as PostGIS or pgvector
  • −High-throughput transactional systems
  • −Large analytical workloads

Capabilities

Native or official first-party support · 10 of 25 tracked

✓Transactions
✓Joins
✓Secondary indexes
✓JSON
✓Triggers
✓Durable persistence
✓Compression
✓Role-based access
✓Time travel
✓Branching
–Full-text search
–Vector search
–Geospatial
–Change data capture
–Stored procedures
–Materialized views
–TTL / expiry
–Pub/Sub
–Columnar storage
–In-memory
–Encryption at rest
–Online schema changes
–Streaming ingest
–Offline sync
–Runs in WebAssembly

Scale & consistency

Comfortable data size
Small · ≤ 100 GB
Horizontal scaling
None
Multi-region
Read replicas
Transactions
Full ACID
Consistency
Strong
Schema
Strict
Architecture
Single node, Primary replica, Client server
Query languages
SQL

Single primary with replicas via remotes; history grows with commits.

Deployment

Self-hosted Vendor-managed cloud Serverless Embedded Edge Kubernetes operator

Ecosystem

compatible withPostgreSQL
apis & protocolsPostgreSQL wire protocol, Dolt SQL functions (dolt_commit, dolt_merge)
client languagesGo, Python, Java, JavaScript, C#, Ruby

Alternatives to Doltgres

Compare all→
DoltRelational18.2

MySQL-compatible SQL database you can branch, diff, merge and clone like a Git repository.

doltgres vs dolt →
PostgreSQLRelational93.2

The extensible, standards-first open-source relational database.

doltgres vs postgresql →
NeonRelational30.4

Serverless Postgres with copy-on-write branching and scale-to-zero, now part of Databricks.

doltgres vs neon →
XataRelational7.4

Open-source Postgres platform with storage-level copy-on-write branching, scale-to-zero and anonymized clones.

doltgres vs xata →
SupabaseRelational54.3

Open-source Postgres backend platform: database, auth, storage, realtime and edge functions in one project.

doltgres vs supabase →
VitessRelational21.2

CNCF-graduated sharding and clustering layer that makes a fleet of MySQL servers look like one database.

doltgres vs vitess →

Doltgres FAQ

What is Doltgres?

Doltgres is a relational database by DoltHub, first released in 2023. Doltgres (DoltgreSQL) is DoltHub's PostgreSQL-flavored sibling of Dolt. It reuses Dolt's prolly-tree storage engine and Git-style commit graph, but speaks the PostgreSQL wire protocol and dialect, so psql, Postgres drivers and ORMs can connect while you branch, diff, merge and time-travel over tables with SQL functions. It reached 1.0 in August 2026 and DoltHub now calls it production-ready, though its Postgres coverage (extensions, some types and catalog behavior) is still narrower than real PostgreSQL. It suits teams in the Postgres ecosystem that need data versioning and review workflows more than raw throughput.

Is Doltgres open source?

Yes. Doltgres is open source. License: Apache License 2.0.

Does Doltgres support ACID transactions?

Yes. Doltgres supports full ACID transactions, with strong consistency.

Does Doltgres scale horizontally?

Doltgres does not scale horizontally; it runs on a single node, so you scale it up rather than out. It is comfortable at small scale (≤ 100 GB). It supports cross-region read replicas.

How can I run Doltgres?

You can self-host it.

What is Doltgres best for?

Doltgres is a strong fit for versioned reference data for Postgres-based apps, reproducible ML datasets and safe data migrations tested on branches. Think twice for apps relying on Postgres extensions such as PostGIS or pgvector.

What are the best alternatives to Doltgres?

Common alternatives to Doltgres include Dolt, PostgreSQL, Neon, Xata and Supabase. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.

How popular is Doltgres?

Doltgres ranks #270 of 844 databases on the WhichDB Score (12.3/100), and #86 among relational databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.