# Bytebase — Database DevOps and CI/CD for Teams

> A web-based database CI/CD platform for DBAs and engineers. Schema review, change approval, GitOps migration pipelines and data access control across MySQL, Postgres, Snowflake, Oracle, TiDB, ClickHouse and more.

## Install

Save as a script file and run:

# Bytebase — Database DevOps and CI/CD for Teams

## Quick Use
```bash
# Single-container trial
docker run --init --name bytebase 
  --publish 8080:8080 
  --volume ~/.bytebase/data:/var/opt/bytebase 
  bytebase/bytebase:latest 
  --data /var/opt/bytebase --port 8080

open http://localhost:8080     # set up admin, add an instance, invite teammates
```

## Introduction
Bytebase is an open-source database DevOps platform that sits between developers and their databases. It adds schema review, SQL linting, change-management workflows, GitOps pipelines and fine-grained data access control to engines that traditionally lack them, so database changes can be treated like code changes — reviewed, approved, audited.

## What Bytebase Does
- Centralises connections to 20+ engines (MySQL, Postgres, Oracle, SQL Server, Snowflake, TiDB, ClickHouse, MongoDB, Redis...).
- Runs SQL reviews with 100+ built-in lint rules and custom policies.
- Orchestrates change pipelines across dev → test → staging → prod with approvals.
- Integrates with GitHub/GitLab/Bitbucket to trigger migrations on merge (GitOps mode).
- Enforces data access: masking, query-time RBAC, audit logs and export controls.

## Architecture Overview
A single Go binary bundles the API server, web UI and a task runner. Metadata (projects, users, review policies, change history) lives in an embedded or external Postgres database. Bytebase connects out to managed instances using least-privilege accounts, pushing migrations or streaming queries through its SQL Editor proxy so every statement is logged. Webhooks and SCIM sync back to your VCS/IDP.

## Self-Hosting & Configuration
- Deploy via Docker, Docker Compose, Kubernetes Helm chart or pre-built binaries.
- Configure external Postgres metadata DB with `--pg` for HA.
- Wire SSO (Google, GitHub, OIDC, SAML) and SCIM for automated user provisioning.
- Define SQL review policies at project or environment level; version them as YAML.
- Expose the REST and gRPC API to automate issues, plans and rollouts from CI.

## Key Features
- Schema drift detection between environments with side-by-side diffs.
- Batch change rollouts to many sharded instances in one pipeline.
- SQL Editor with autocomplete, AI assistance and row-masking.
- Plans + issues model — like Jira, but for database changes.
- Open-source core (Apache 2.0) with Enterprise tier for RBAC/SSO/advanced data masking.

## Comparison with Similar Tools
- **Liquibase / Flyway** — migrations only; no UI, review workflow or query proxy.
- **Atlas** — schema-as-code CLI; great, but not a collaboration platform.
- **DBeaver Team Edition** — GUI client, not a CI/CD workflow engine.
- **Hasura / PostgREST** — instant APIs, not change management.
- **Redgate / Datagrip** — commercial, mostly SQL Server/Postgres clients.

## FAQ
**Q:** Does Bytebase execute migrations itself?
A: Yes — it connects to each target instance with a managed service account and runs the statements, with rollback plans.
**Q:** Can I integrate with GitHub Actions?
A: Yes — Bytebase exposes a CLI and REST API, and has a GitOps mode that reads migrations from a repo path.
**Q:** Which engines are supported?
A: MySQL, Postgres, Oracle, SQL Server, ClickHouse, Snowflake, BigQuery, Redshift, Spanner, TiDB, OceanBase, DM, StarRocks, MongoDB, Redis, DynamoDB and more.
**Q:** Is it free?
A: The community edition is Apache 2.0. Enterprise adds SSO, advanced masking and SLAs.

## Sources
- https://github.com/bytebase/bytebase
- https://www.bytebase.com/docs/

---
Source: https://tokrepo.com/en/workflows/7b0a53c6-3920-11f1-9bc6-00163e2b0d79
Author: Script Depot