Create a Next.js app with Supabase Auth and Supabase DB

About this guide

This development guide walks you through everything you need to do to build a high-quality Next.js app integrated with Supabase Auth and Supabase DB. Check out the tasks below to get started. To save time, you can also use our boilerplate, which gives you a complete React codebase with all of these tasks done for you. Okay, let's dive in!

Tasks

• Setup your Next.js appGet the code

  Create a Next.js app using npx create-next-app and then run your project locally with the npm run dev command.

• Create a Supabase AuthProvider and useAuth hookGet the code

  Create an AuthProvider component that fetches the current user from Supabase, subscribes to changes, stores the user in state, and then makes all this data available to child components using Context.Provider. Make sure to update your Next.js App component so that AuthProvider wraps all your pages. You'll then create a useAuth hook that reads the user with useContext and returns its value. This will enable any component to call useAuthto get the current user and re-render when it changes.

• ‍Protect pages with a Supabase requireAuth HOCGet the code

  Create a requireAuth higher order component for pages that should only be viewable by authenticated users. It should call your useAuth hook internally to get the current user, show a loading indicator while waiting on the response, and then either render the page or redirect to /signin depending on whether the user is authenticated.

• Build your authentication UIGet the code

  Create an authentication UI using your component library of choice and Supabase functions. You'll want routes for user sign-up, sign-in, forgot password, and change password. Make sure you properly validate inputs and display any errors returned by Supabase. You may also want to use a library, such as React Hook Form, for managing form state.

• Link user to analytics sessionGet the code

  You can connect Google Analytics sessions to the current authenticated user with the User ID feature. This allows you to see what your users are doing across sessions and devices. You'll need to update your useAuth hook to set the user_id property whenever the user changes.

• Create Supabase query hooksGet the code

  Create React hooks that wrap your Supabase queries, such as useUser, useItem, and useItemsByUser. These hooks should fetch data and return a query status of "success", "loading", or "error". The React Query library makes it especially easy to setup these hooks and have components re-render when data changes.

• Create Supabase tables and policiesGet the code

  Create the database tables that your app requires. For a simple SaaS app you could start with tables for users, customers and items. Your customers and items tables would generally have a user_id column that references users.id. You can create these tables right in your Supabase dashboard, but we recommend writing a create table SQL snippet for each table, allowing you to easily recreate them in the future. Lastly, you'll want to enable Row Level Security for your tables and secure read/write access with policies.

• Setup a trigger to create user in database on signupGet the code

  When a user signs up with Supabase Auth you'll want to automatically insert their data to the users table so that you can easily query on it. This can be accomplished with a trigger. Setup a trigger that inserts a new row into the users table when a user signs up. You'll also want to create a trigger that updates that data when a user's auth email changes. This ensures that your database is always in sync with user data in Supabase Auth.

• Build a data-driven UIGet the code

  Create a data-driven UI using your component library of choice that reads/writes data to Supabase. The specifics will depend on the type of app you're building, but we generally recommend having a useItemsByOwner hook that fetches "items" in Supabase that are owned by the current user. You can then create a component for displaying that data in a simple list or table if more columns are needed. Finally, you'll want create a flow for creating and updating items utilizing modal and form components.

Get the code

You can get the code for this guide with our Next.js, Supabase Auth, and Supabase DB Boilerplate. You'll get a complete Next.js codebase with Supabase Auth and Supabase DB integration, all the tasks listed above done for you, and a responsive multi-page template. It should save you about two weeks of development time.

Get the boilerplate