bytebase

Built by bytebase

Database changes with review, approval and history, like GitHub for your schema.

Databases

About

What it does

Bytebase brings a safe, collaborative workflow to database work. Developers propose schema and data changes, reviewers approve them, and Bytebase rolls them out across environments with a complete audit trail.

A web SQL editor with data access controls means people can query production safely without being handed raw credentials.

Highlights

  • Schema change review, approval and rollout
  • SQL linting and automatic checks
  • GitOps workflows for database changes
  • Web SQL editor with data masking and access control
  • Supports the major SQL and NoSQL databases

Who it's for

Engineering teams that want database changes to be as safe as code changes.

Readme

from the project's repository

Show the full readme from GitHub

banner

What is Bytebase?

Bytebase is the open-source database governance platform. It acts as a single control plane between your users — humans and AI agents — and your databases, governing change management, access control, and compliance so every change and query is reviewed, controlled, and recorded.

middleware

It replaces the disparate tools stitched across migration scripts, SQL clients, and ticketing systems, unifying database operations in a single platform.

Supported Databases and Integrations

Bytebase supports PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, Redis, MariaDB, TiDB, Snowflake, ClickHouse, Spanner, OceanBase, and more — plus integrations spanning IaC, AI, identity providers, collaboration, ITSM, log streaming, and secret managers.

integrations

Key Features

Change Management

  • GUI-Based Workflow: Request, review, deploy, and rollback changes through a web console
  • GitOps Integration: Native GitHub/GitLab integration for database-as-code workflows
  • SQL Review: 200+ lint rules to enforce SQL standards and best practices

Access Control

  • Fine-Grained RBAC: Project and workspace-level roles and permissions
  • Just-in-Time Access: Time-boxed database access grants with automatic revocation
  • Dynamic Data Masking: Column-level masking applied based on user role at query time

Compliance

  • Audit Logging: Complete audit trail of all database activities
  • Codified Policy: Manage policies as code via Terraform Provider and API
  • Data Classification: Identify and tag sensitive data across your databases

AI

  • MCP Server: Connect AI agents and IDEs to Bytebase through the Model Context Protocol
  • Text-to-SQL: Generate and refine queries in the SQL Editor with AI assistance
  • Page Agent: Built-in AI assistant that guides or executes workflows from plain language requests

Quick Start

Docker

docker run --init \
  --name bytebase \
  --publish 8080:8080 \
  --volume ~/.bytebase/data:/var/opt/bytebase \
  bytebase/bytebase:latest

Kubernetes

helm install bytebase bytebase/bytebase

Visit http://localhost:8080 and follow the setup wizard.

Documentation

Use Cases

For Development Teams

  • Implement database schema version control
  • Automate database deployments through CI/CD pipelines
  • Collaborate on database changes with review workflows

For DBAs

  • Centralize database management across all environments
  • Enforce organization-wide SQL standards and policies
  • Monitor and audit all database activities

For Security Teams

  • Control data access with column-level permissions
  • Implement data masking for sensitive information
  • Maintain compliance with audit trails

Community & Support

Contributing

We welcome contributions!

# Setup a postgres database with user bbdev and database bbdev
export PG_URL=postgresql://bbdev@localhost/bbdev

# Start backend
alias r='go build -ldflags "-w -s" -p=16 -o ./bytebase-build/bytebase ./backend/bin/server/main.go && ./bytebase-build/bytebase --port 8080 --data . --debug'

# Start frontend
alias y="pnpm --dir frontend i && pnpm --dir frontend dev"

Comparisons