Repolode
postgres-ai

postgres-ai/database-lab-engine

DBLab Engine creates thin clones and branches of PostgreSQL databases in seconds, for dev, test, and CI/CD environments.

Open-source alternative to:Delphix

Stars
2,776
Forks
89
Open issues
14
Last commit
2 days ago

What is it?

DBLab Engine is a server for cloning and branching PostgreSQL databases. It uses copy-on-write storage, either ZFS (default) or LVM, so a full-size clone of a large database is created in seconds and consumes little extra disk space. Multiple independent clones can run side by side on one machine.

The main use cases are development, QA, and staging environments built on production-like data, SQL query optimization against real-size tables, and automated database migration tests in CI/CD pipelines. Clones are exposed through a web UI, an API, and a CLI, and the project provides Docker packaging for its components.

Source databases can be self-managed PostgreSQL or managed services such as AWS RDS, GCP Cloud SQL, and Azure. Data can be retrieved either physically (pg_basebackup, WAL-G, pgBackRest) or logically (dump and restore). Supported PostgreSQL versions are 10 through 18.

Key features

  • 01Clones a PostgreSQL database in seconds using ZFS or LVM copy-on-write snapshots.
  • 02Supports PostgreSQL 10 through 18, including managed cloud services.
  • 03Provides physical and logical data provisioning, with periodic refresh and point-in-time recovery in physical mode.
  • 04Offers UI, API, and CLI access, with Docker packaging for all components.
  • 05Includes a clone major-version upgrade command built on pg_upgrade.
  • 06Exposes health and Prometheus metrics endpoints for monitoring.

Use cases

  • Giving developers and QA teams full-size, production-like database copies for testing.
  • Running SQL query optimization against real data volumes without loading production.
  • Testing database schema migrations automatically in CI/CD pipelines.
  • Validating changes suggested by LLMs against real database schemas.

Topics

FAQ

What is database-lab-engine?
DBLab Engine creates thin clones and branches of PostgreSQL databases in seconds, for dev, test, and CI/CD environments. DBLab Engine is a server for cloning and branching PostgreSQL databases. It uses copy-on-write storage, either ZFS (default) or LVM, so a full-size clone of a large database is created in seconds and consumes little extra disk space. Multiple independent clones can run side by side on one machine.
Is database-lab-engine free to use? What license does it have?
database-lab-engine is open source under the Apache-2.0 license. Check the license terms before using it in commercial products.
Is database-lab-engine still maintained?
Actively maintained. The last commit to database-lab-engine was on Oct 16, 2026.
What can I use database-lab-engine for?
Giving developers and QA teams full-size, production-like database copies for testing. Running SQL query optimization against real data volumes without loading production. Testing database schema migrations automatically in CI/CD pipelines. Validating changes suggested by LLMs against real database schemas.
Where can I get database-lab-engine?
The source code and installation instructions are on GitHub: https://github.com/postgres-ai/database-lab-engine

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects