Configure Supabase

Step 1: Create a Supabase project

First, sign in to your Supabase account and create a new project. Once you have created your Supabase project, copy the Supabase URL, the anon public API key and the secret service role key and add it as environment variables for your application. These values can be found on the API settings page of your Supabase project (https://app.supabase.io/project/{project_id}/settings/api).

The environment variables are named:

  • NEXT_PUBLIC_SUPABASE_URL
  • NEXT_PUBLIC_SUPABASE_ANON_KEY
  • SUPABASE_SERVICE_ROLE_KEY

To configure environment variables locally for this project rename the .env.example file in the root directory to .env.local and modify the values in the file.

Step 2: Create Supabase database tables

In the sql folder of this project you will find 6 SQL scripts, ordered 1 - 6. Run these scripts on your Supabase database from 1 - 6 to create the required tables, storage buckets and policies for this application. To run these scripts go to the SQL editor page (https://app.supabase.io/project/{project_id}/editor/sql) of your Supabase project.

After you created the "avatars" storage bucket (with script 6) you should change the bucket's access to public. This can be done by navigating to the storage buckets page (https://app.supabase.io/project/{project_id}/storage/buckets), clicking on the options menu for the bucket, and then clicking "Make public".

You can read more about Supabase in the official Supabase docs.

Last updated:

Stay up to date

Sign up for the Ship SaaS newsletter to get notifiedabout the latest updates and blog posts

We care about the protection of your data. Read our Privacy Policy and Terms & Conditions.