Database Lab Engine (DLE) is an open-source (AGPLv3) technology that allows blazing-fast cloning of Postgres databases of any size in seconds. This helps solve many problems such as:

• build dev/QA/staging environments involving full-size production-like databases,
• provide temporary full-size database clones for SQL query analysis optimization (see Joe bot),
• automatically verify database migrations (DB schema changes) and massive data operations in CI/CD pipelines to minimize risks of downtime and performance degradation.

As an example, cloning a 10 TiB PostgreSQL database can take less than 2 seconds.

• How it works
• Database Migration Testing
• SQL Optimization with Joe Bot
• Case Study: Qiwi (How Qiwi Controls the Data to Accelerate Development)
• Case Study: GitLab (How GitLab iterates on SQL performance optimization workflow to reduce downtime risks)

Please support the project giving a GitLab star! It's on the main page, at the upper right corner:

• Database Lab documentation
• Questions & answers

• Database Lab tutorial for any PostgreSQL database
• Database Lab tutorial for Amazon RDS

• DLE components
• DLE configuration reference
• DLE API reference
• Client CLI reference

• How to install Database Lab with Terraform on AWS
• How to install and initialize Database Lab CLI
• How to manage DLE
• How to work with clones

• DLE Docker images
• Extended Docker images for PostgreSQL (with plenty of extensions)
• SQL Optimization chatbot (Joe Bot)
• DB Migration Checker

Open an Issue to discuss ideas, open a Merge Request to propose a change.

See our GitLab Container Registry to find the images built for development branches.

1. Install golangci-lint: https://github.com/golangci/golangci-lint#install

• Community Slack
• Twitter