Manage Supabase Database

Overview#

Supabase is an open source Firebase alternative providing all the backend features you need to build a product. You can use it completely, or just the features you need.

As Supabase provides full PostgreSQL database instances, teams can use Bytebase to manage the database development lifecycle for the Supabase databases.

While Supabase already has an easy-to-use GUI to conduct database operations, Bytebase adds the extra value to offer a systematic database development and change workflow. This is especially useful for cross-functional teams requiring collaboration (e.g. having dedicated DBA or platform engineering team apart from the application development teams).

Prerequisites#

• You need a Supabase account (free signup).
• After signup, create a supabase project, you can start with the Free plan which already includes a full PostgreSQL instance.

The Procedure#

Step 1 - Visit Supabase project's database setting#

Note down the Host and Port info. For User and Password, we recommend creating a dedicated user for Bytebase instead of using the default postgres user.

Step 2 - Create a database user for Bytebase#

Visit Supabase SQL Editor and create a database user and grants it SUPERUSER role. Below example creates a user named "bytebase".

Step 3 - Add the Supabase database instance to Bytebase#

Choose PostgreSQL, and copy the Host, Port, User and Password from the last two steps to the form and click "Create". See Add an Instance for more details.

Step 4 - Check the database instance is properly imported#

All databases should be sycned properly. Expect some delay if the database instance is large.

So should the tables under the databases.