supabase

Supabase Service - KindFi

This document provides instructions for developers to set up and run the Supabase service locally within the KindFi monorepo.

Prerequisites

Ensure you have the following installed on your machine:

• Node.js
• Bun
• Docker
• Docker Compose
• Supabase CLI

Setup

1. Clone the Repository (if you haven't already)

git clone https://github.com/kindfi-org/kindfi.git
cd monorepo/services/supabase

2. Install Dependencies

bun install

3. Get Ready For Migrations

To create migrations, please follow this guide, it provides steps to generate migrations, ensure that they work before pushing.

Running Supabase Locally

1. Start Supabase Services

Use the following command to start the Supabase services:

bun start # supabase start

This will start the Supabase local development environment, including the database, authentication, and storage services.

2. Generate Types and Schemas

Generate the necessary types and schemas for the Supabase service:

For Remote Supabase (Production/Staging):

# Option 1: Using the helper script (recommended)
./generate-types.sh <YOUR_PROJECT_ID>

# Option 2: Using npm script with PROJECT_ID env variable
PROJECT_ID=<YOUR_PROJECT_ID> bun run gen:remote

# Option 3: Direct command
supabase gen types typescript --project-id <YOUR_PROJECT_ID> > src/database.types.ts
bun run schemas

To find your PROJECT_ID:

1. Go to https://supabase.com/dashboard
2. Select your project
3. Go to Settings > General
4. Copy the "Reference ID" (this is your PROJECT_ID)

For Local Supabase:

bun gen # generates what it is in local database

Important: After generating types from remote, commit the src/database.types.ts file to your repository so Vercel builds have access to the types.

3. Environment Variables

Copy the sample environment file and update it with your configuration:

cp .env.sample .env

Update the .env file with the KindFi Supabase project id. This is for remote type generation and to identify the local development host.

Supabase Service Role Key

The SUPABASE_SERVICE_ROLE_KEY is a critical environment variable required for server-side operations with Supabase. It grants admin-level access to your Supabase project and should be handled securely.

Obtaining the Service Role Key

1. Go to your Supabase Dashboard: https://supabase.com/dashboard.
2. Select the project you're working on.
3. In the left sidebar, click on Settings.
4. Select Data API from the settings menu.
5. Locate the Service Role Key and reveal and copy it:

Useful Commands

• Apply (new) migrations to the local database

  bun migrate # When adding new migrations file, this makes sure to apply them.

• Apply migrations by resetting local database completely

  bun reset # When adding new migrations file, this makes sure to apply them by resetting from the migrations.

Documentation

For more detailed instructions and advanced configurations, refer to the Supabase Local Development Guide.