Overview

Shadcn Dashboard uses Supabase as its backend platform (authentication + hosted PostgreSQL) and Prisma ORM to interact with the database. Two separate clients handle different concerns.

How it works

Supabase Client

Manages authentication — sign-up, sign-in, OAuth flows, and session token handling on the client side.

Prisma Client

Handles all database queries — profiles, orders, products, and permissions with full type safety.

Supabase Admin Client

Server-side only. Bypasses Row Level Security for privileged operations that require elevated access.

Setup Steps

Follow these steps in order to fully integrate Supabase and Prisma into your project.

Required Packages

Install all the necessary npm packages to get Supabase and Prisma working in your project.

View Packages

Create Supabase Project

Set up a new Supabase project and configure your database instance in the Supabase dashboard.

Create Project

Environment Variables

Configure the required environment variables to connect your app securely to Supabase.

Set Up Env Vars

Database Clients

Understand how the Supabase and Prisma clients are initialized and used throughout the app.

Explore Clients

Prisma Schema

Define your database models and relations using the Prisma schema file.

View Schema

Run Migrations

Apply Prisma migrations to your Supabase PostgreSQL database to sync your schema.

Run Migrations

Seed the Database

Populate your database with initial data using the Prisma seed script.

Seed Database

Demo Mode

Enable demo mode to explore the full app without requiring a live Supabase connection.

Enable Demo