Skip to main content
When modifying data in the database, it’s crucial to ensure that the changes are both safe and accurate. Bytebase offers a feature called SQL Review, which allows you to evaluate your SQL changes before they are applied to the database. SQL Review can be invoked from the Bytebase GUI, CI or API. This is one of the tutorial series of SQL Review:
  1. SQL Review with Bytebase GUI
  2. SQL Review with CI (integrated with Database GitOps workflow):
  3. SQL Review with Bytebase API (this one)
  4. Codify SQL Review Policies with Bytebase API
This tutorial will walk you through using SQL Review in Bytebase with Bytebase API to improve your database schema change process. The Community Plan is sufficient for completing this tutorial.

​
Prerequisites

Make sure you have completed the previous tutorial SQL Review with Bytebase GUI.
If you want to test the SQL Review API locally with cloud CI/CD services, you’ll need to expose your local Bytebase instance. See Network Architecture guide for options like ngrok or VS Code port forwarding.

​
API Examples

You may call Bytebase API in your internal portal or GitHub Actions to trigger SQL Review. Check out https://github.com/bytebase/example-api/tree/main/issue-creation bb-api You can also call the API to configure SQL Review policies.

Tutorial: Codify SQL Review Policies with Bytebase API

​
Summary

Now you have learned how to trigger SQL Review in Bytebase API. You may also refer to the SQL Review document for more details. Next, let’s learn how to codify SQL Review policies with API