Moodlings Database Setup

Set up your Supabase database to store and retrieve Moodlings

Moodlings Database Setup Guide

Follow these steps to set up your Supabase database for Moodlings

1. Create a Supabase Project

If you haven't already, create a new project in Supabase at app.supabase.com

2. Get Your API Keys

Go to Project Settings → API and copy your URL and anon key.

Add these to your .env.local file:

NEXT_PUBLIC_SUPABASE_URL=your_supabase_url
NEXT_PUBLIC_SUPABASE_ANON_KEY=your_supabase_anon_key

3. Create the Database Schema

Go to the SQL Editor in your Supabase dashboard and run the SQL schema (see SQL Schema tab).

4. Set Up Row Level Security (Optional)

For a production app, you should set up Row Level Security policies. For this MVP, you can enable "Realtime" for the moodlings table in the Supabase dashboard.