Repository files navigation

⚙️ Install •📚 Docs •💬 Discord •🙋‍♀️ Book Demo

Different database development tasks

Multiple database systems

Unified process

Single tool

🪜

Want to formalize the database change process but don't know how?

Standard Operating Procedure (SOP) Standardize the database schema and data change process across different database systems, small orlarge tables anddifferent tenants. SQL Review 100+ lint rules to detect SQL anti-patterns and enforce consistent SQL style in the organization. GitOps Point-and-click GitHub and GitLab integration to enable GitOps workflow for changing database.

🔮

Want to control the data access but don't know how?

All-in-one SQL Editor Web-based IDE specifically for performing SQL specific tasks. Data Masking State-of-the-artcolumn level masking engine to cover complex situations like subquery, CTE. Data Access Control Organization level policy to centralize thedata access control.

🔒

Want to avoid data leakage, change outage and detect malicious behavior but don't know how?

Centralize Change, Query and Admin Tasks A single place to perform different tasks on different databases, thus enforce policy and monitor activity accordingly. RBAC Two-level RBAC model mapping to the organization wide privileges and application team privileges respectively. Anomaly Center and Audit Logging Capture all databaseanomalies, user actions and system events and present them in a holistic view.

👩‍💼

Want to enforce organization policy but don't know how?

Manage Database Resources A single place to manage environments, database instances, database users for application development, with optionalTerraform integration. Policy Enforcement Enforce organization wide SQL Review policy, backup policy and data access policy. SQL Editor Admin mode CLI like experience without setting up bastion.

Bytebase is a Database CI/CD solution for the Developers and DBAs. It's theonly database CI/CD project included by theCNCF Landscape andPlatform Engineering. The Bytebase family consists of these tools:

• Bytebase Console: A web-based GUI for developers and DBAs to manage the database development lifecycle.
• Bytebase API: Provide both gRPC and RESTful API to manipulate every aspect of Bytebase.
• Bytebase CLI (bb): The CLI to help developers integrate database changes into the existing CI/CD workflow.
• Bytebase GitHub App andSQL Review GitHub Action: The GitHub App and GitHub Action to detect SQL anti-patterns and enforce a consistent SQL style guide during Pull Request.
• Terraform Bytebase Provider: The Terraformprovider enables team to manage Bytebase resources via Terraform. A typical setup involves teams usingTerraform to provision database instances from Cloud vendors, followed by using Bytebase provider toprepare those instances ready for application use.

• Docker
• Kubernetes
• Build from source

Live demo athttps://demo.bytebase.com

You can alsobook a 30min product walkthrough with one ofour product experts.

Product tutorials are available athttps://www.bytebase.com/tutorial.

• Manage Supabase PostgreSQL
• Manage render PostgreSQL
• Manage Neon database
• Deploy to sealos
• Deploy to Rainbond

More details inData Model Doc.

More details inRoles and Permissions Doc.

Bytebase employs RBAC (role based access control) and provides two role sets at the workspace and project level:

• Workspace roles:Admin,DBA,Member. The workspace role maps to the role in an organization.
• Project roles:Owner,Developer,Releaser,Querier,Exporter,Viewer. The project level role maps to the role in a specific team or project.

Every user is assigned a workspace role, and if a particular user is involved in a particular project, then she will also be assigned a project role accordingly.

Below diagram describes a typical mapping between an engineering org and the corresponding roles in the Bytebase workspace

• Bytebase is built with a curated tech stack. It is optimized fordeveloper experience and is very easy to startworking on the code:

  1. It has no external dependency.
  2. It requires zero config.
  3. 1 command to start backend and 1 command to start frontend, both with live reload support.

• Interactive code walkthrough

  • Life of a schema change
  • SQL Review

• FollowLife of a Feature.

• Go (1.23.2 or later)
• pnpm
• Air (our forked repo @87187cc with the proper signal handling). This is for backend live reload.

  go install github.com/bytebase/air@87187cc

1. Pull source.

   git clone https://github.com/bytebase/bytebase

2. Create an external Postgres database on localhost.

   CREATEUSERbbdev SUPERUSER;CREATEDATABASEbbdev;

3. Start backend using air (with live reload).

   PG_URL=postgresql://bbdev@localhost/bbdev$(go env GOPATH)/bin/air -c scripts/.air.toml

   Change the open file limit if you encounter "error: too many open files".

   ulimit -n 10240

   If you need additional runtime parameters such as --backup-bucket, please add them like this:

   air -c scripts/.air.toml -- --backup-region us-east-1 --backup-bucket s3:\\/\\/example-bucket --backup-credential~/.aws/credentials

4. Start frontend (with live reload).

   cd frontend&& pnpm i&& pnpm dev

   Bytebase should now be running athttp://localhost:3000 and change either frontend or backend code would trigger live reload.

• UseCode Inspector to locatefrontend code from UI. HoldOption + Shift on Mac orAlt + Shift on Windows

• Bytebase vs Liquibase
• Bytebase vs Flyway

Either Flyway or Liquibase is a library and CLI focusing on schema change. While Bytebase is an one-stopsolution covering the entire database development lifecycle for Developers and DBAs to collaborate.

Another key difference is Bytebasedoesn't support Oracle and SQL Server. This is a consciousdecision we make so that we can focus on supporting other databases without good tooling support.In particular, many of our users tell us Bytebase is by far the best (and sometimes the only) databasetool that can support their PostgreSQL and ClickHouse use cases.

Either Yearning or Archery provides a DBA operation portal. While Bytebase provides a collaborationworkspace for DBAs and Developers, and brings DevOps practice to the Database Change Management (DCM).Bytebase has the similarProject concept seen in GitLab/GitHub and provides native GitOps integrationwith GitLab/GitHub.

Another key difference is Yearning, Archery are open source projects maintained by the individuals part-time. While Bytebase is open-sourced, it adopts an open-core model and is a commercialized product, supportedby afully staffed teamreleasing new version every 2 weeks.

Metabase is a data visualization and business intelligence (BI) tool. It's built for data teams and business analysts to make sense of the data.

Bytebase is a database development platform. It's built for the developer teams to perform database operations during the application development lifecycle.

• Bytebase vs Metabase

Both have web-based SQL clients. Additionally, Bytebase offers review workflow, more collaboration and security features.

• Bytebase vs CloudBeaver

SQL GUI Client such as MySQL Workbench, pgAdmin, DBeaver, Navicat provide a GUI to interact with the database. Bytebase not only provides a GUI client, it can also enforce centralized data access control for data security and governance.

• Bytebase vs DBeaver
• Bytebase vs Navicat

Jira is a general-purpose issue ticketing system. Bytebase is a database domain-specific change management system. Bytebase provides an integrated experience to plan, review, and deploy database changes.

• Bytebase vs Jira

Check out ourFAQ.

• Interested in joining us? Check out ourjobs page for openings.
• Want to solve your schema change and database management headache? Book a30min demo with one of our product experts.