AnalyticDB:Supabase

Core features

Billing

• Free Edition: A free tier with 1 vCPU and 2 GB of memory is available.

  Important

  The free project is for development and testing only. Do not use it in a production environment.

• Paid Edition: Creating a project incurs fees for compute and storage resources. For pricing of compute resource specifications, see Pricing. For a detailed breakdown of project charges, see the Supabase purchase page.

Create a Supabase project

1. Log on to the AnalyticDB for PostgreSQL console.

2. In the upper-left corner of the console, select the region where the instance is located.

3. In the navigation pane on the left, click Supabase.

4. In the upper-right corner of the page, click Create Project, and select Free test creation or Paid creation.

5. Set the parameters.

   Free tier

   Parameter	Description
   Project Name	The name of the project.
   Zone	A zone is an independent physical area within a region. There is no significant difference between zones.
   Specifications	Select the project specifications.
   Database Account	Fixed at postgres.
   Database Password, Confirm Password	The password for the initial account. The password must meet the following requirements: Be 8 to 32 characters in length. Contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. The supported special characters are: !@#$%^&*()_+-=. Note After creating the Supabase instance, you can reset the database password via the console or by calling the ResetSupabaseProjectPassword operation.
   VPC	Select the ID of the virtual private cloud (VPC). You must first create a VPC and a vSwitch in the same region as the instance.
   VSwitch	Select a vSwitch in the VPC. If no vSwitches are available, you can switch to another zone or create a vSwitch in the current zone.
   Remove Whitelist Restrictions	Select whether to enable the whitelist restriction.
   IP Address Whitelist	Add the IP addresses to the whitelist.

   Paid tier

   Parameter	Description
   Product Type	Select Subscription or Pay-As-You-Go.
   Region and Availability Zone	Select the region and zone. A zone is an independent physical area within a region. There is no significant difference between zones.
   Instance Specifications	Select the size of the compute resource specifications. A specification with 4 GB of memory or more is recommended.
   Disk Type	Select the disk storage class.
   Storage Capacity	Select the size of the storage resource specifications.
   Project Name	Enter a project name. Important The project name must be unique.
   Initialize Password	Set the password for the database. The password must meet the following requirements: Be 8 to 32 characters in length. Contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. The supported special characters are: !@#$%^&*()_+-=. Note The initial password is the database password, not the logon password for the dashboard. After creating the Supabase instance, you can reset the database password via the console or by calling the ResetSupabaseProjectPassword operation.
   Virtual Private Cloud (VPC)	Select the ID of the VPC. You must first create a VPC and vSwitch in the same region as the instance.
   vSwitch	Select a vSwitch in the VPC. If no vSwitches are available, you can switch to another zone or create a vSwitch in the current zone.
   Resource Group	Select a resource group.

6. Confirm the parameter settings and complete the project creation.

   • For a free tier project: Click OK.

   • For a paid tier project: Click Buy Now, confirm your order information, and click Activate Now.

Use Supabase project

1. Log on to the Supabase Dashboard.

   1. In the Actions column of the target instance, click Manage.

   2. Copy the logon account and logon password, and then click Go to. You are redirected to the Supabase Dashboard logon window.

   3. Enter the username and password to log on to the Supabase Dashboard.

   

2. Obtain API keys.

   • Obtain the anon key for database operations such as create, read, update, and delete (CRUD).

     1. In the upper-left corner of the Supabase Dashboard, click Connect.

     2. In the pop-up window, click App Frameworks to obtain the NEXT_PUBLIC_SUPABASE_URL and NEXT_PUBLIC_SUPABASE_ANON_KEY of the Supabase instance.

     

   • Obtain the service role key for operations such as identity verification and authorization.

     1. In the navigation pane on the left of the Supabase Dashboard, click API Docs.

     2. Click Introduction > Bash. For Project API Key, select service_role.

        

     3. Click Authentication to obtain the SERVICE KEY.

        

3. Call RESTful and Auth APIs.

   Important

   Store API keys in environment variables to avoid hardcoding in code and reduce the risk of exposure.

   • Use the Supabase REST API to manage your database.

     You can perform CRUD operations on the database at https://<SUPABASE_URL>/rest/v1/. Example: Query the users table with this command:

     curl 'http://<SUPABASE_URL>/rest/v1/users'-H "Authorization: Bearer <anon key>" -H "apikey: <anon key>" -H "Content-Type: application/json"

   • Use the Supabase Auth API to manage user registration and authentication.

     Example: Query all users with this command:

     curl 'http://<SUPABASE_URL>/admin/users' -H "Authorization: Bearer <service role key>" -H "apikey: <service role key>" -H "Content-Type: application/json"

Manage Supabase project

Delete Supabase project

In the Actions column of the target instance, click Release. In the pop-up window, click OK.

Related APIs

FAQ