Features
Setup your Supabase database
Head to your the SQL Editor on the Supabase Dashboard and enter the following commands. You can add fields here to fit your app.
create table public.profiles (
id uuid not null references auth.users on delete cascade,
name text,
avatar text,
bio text,
primary key (id)
);
create table public.subscriptions (
id bigint generated by default as identity,
customer_id text,
subscription_id text,
session_id text,
email varchar,
active boolean,
primary key (id)
);
CREATE FUNCTION public.create_profile()
RETURNS trigger
LANGUAGE plpgsql
SECURITY DEFINER SET search_path = public
AS $$
BEGIN
INSERT INTO public.profiles (id, name, bio, avatar)
VALUES
(
NEW.id,
NEW.raw_user_meta_data ->> 'name',
NEW.raw_user_meta_data ->> 'bio',
NEW.raw_user_meta_data ->> 'avatar'
);
RETURN NEW;
END;
$$;
CREATE TRIGGER create_profile_trigger
AFTER INSERT ON auth.users
FOR each ROW EXECUTE PROCEDURE public.create_profile();
Securing your database will prevent unauthorized data leaks. You should never go live without completing this step.
ALTER TABLE public.profiles ENABLE ROW LEVEL SECURITY;
ALTER TABLE public.subscriptions ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Can only view own profile data."
ON public.profiles
FOR SELECT
USING ( auth.uid() = id );
CREATE POLICY "Can only update own profile data."
ON public.profiles
FOR UPDATE
USING ( auth.uid() = id );
CREATE POLICY "Can only view own subscription"
ON public.subscriptions
FOR SELECT
TO authenticated
USING ( auth.email() = email );