What is Bytebase
Bytebase is an open-source database DevOps tool, it's the GitLab for managing databases throughout the application development lifecycle. It offers a web-based workspace for DBAs and Developers to collaborate and manage the database change safely and efficiently.
As DevOps enters the mainstream, teams are adopting tools like GitLab/GitHub for managing code, and Terraform for managing Infrastructure. Similarly, Bytebase is the tool for managing databases during application development.
Bytebase complements the existing cloud provider's database platforms or the company's internal database operation platforms. While those platforms take care of the database instance level operations (e.g. provisioning a database instance), Bytebase helps teams to use the provisioned database to build their application.
Schema (DDL) and Data (DML) Change Review Workflow
Like code review, Bytebase streamlines the database change process. Within a single workflow, a database change can be reviewed and deployed from the dev environment all the way to the production environment.
SQL Quality Check
Bytebase analyzes SQL changes to enforce rules in compliance with your organization's policy. The enforcement includes naming conventions, anti-SQL pattern detection and etc. Prod and non-prod environments can also enforce different rules respectively.
A web-based SQL Editor to query and export data. DBAs no longer need to give away sensitive database credentials when Developers need to access the data.
Version Control with VCS Integration
Bytebase keeps the complete schema change history. It also integrates with VCS systems (e.g. GitLab). Teams can manage the SQL migration scripts in the VCS and trigger schema deployment on code commit.
Backup and Restore
Bytebase supports database-level manual and periodical backup.
A multi-tenant service may create a separate database for each of its tenants. Bytebase can manage a specific database change deployment for all tenants in a single workflow.