Home

Framework Quickstarts

Use Supabase with Next.js

Learn how to create a Supabase project, add some sample data, and query from a Next.js app.

1

Set up a Supabase project

Head over to database.new and create a new Supabase project.

When your project is up and running, navigate to the Table Editor, create a new table and insert some data.

Alternatively, you can run the following snippet in your project's SQL Editor. This will create a notes table with some sample data.

SQL_EDITOR

_12
-- Create the table
_12
create table notes (
_12
id serial primary key,
_12
title text
_12
);
_12
_12
-- Insert some sample data
_12
insert into notes (title)
_12
values
_12
('Today I created a Supabase project.'),
_12
('I added some data and queried it from Next.js.'),
_12
('It was awesome!');

2

Create a Next.js app

Use the create-next-app command and the with-supabase template, to create a Next.js app pre-configured with:

Terminal

_10
npx create-next-app -e with-supabase

3

Declare Supabase Environment Variables

Rename .env.local.example to .env.local and populate with your project's URL and Anon Key.

.env.local

_10
NEXT_PUBLIC_SUPABASE_URL=your-project-url
_10
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key

4

Query Supabase data from Next.js

Create a new file at app/notes/page.tsx and populate with the following.

This will select all the rows from the notes table in Supabase and render them on the page.

app/notes/page.tsx

_11
import { createClient } from '@/utils/supabase/server';
_11
import { cookies } from 'next/headers';
_11
_11
export const dynamic = "force-dynamic";
_11
_11
export default async function Notes() {
_11
const supabase = createClient(cookies());
_11
const { data: notes } = await supabase.from("notes").select();
_11
_11
return <pre>{JSON.stringify(notes, null, 2)}</pre>
_11
}

5

Start the app

Run the development server, go to http://localhost:3000/notes in a browser and you should see the list of notes.

Terminal

_10
npm run dev