Next.js Supabase boilerplate: auth, Postgres, and RLS
Last updated · Wlad K.
NextBento uses Supabase for authentication and Postgres. This page is the integration overview. Step-by-step setup lives in the docs.
Quick Answer
Supabase handles auth and Postgres in NextBento. If you want managed auth plus a database with an easy free-tier start, this is the default path. You cannot swap it for a custom auth stack without rewriting the kit.
What Supabase Provides
Supabase powers auth (Google OAuth, GitHub OAuth, magic link, email/password) and PostgreSQL. NextBento middleware protects dashboard routes with session cookies. Row Level Security (RLS) is applied to core tables so users only access their own data. Post-signup onboarding is gated on profiles.onboarding_completed.
Setup
Create a Supabase project, add the project URL and publishable key to env, and enable OAuth providers in the Supabase Dashboard. Exact steps are in the Supabase setup docs. The Free plan is enough to ship a first app if you stay within project pause and size limits.
Auth Flow
NextBento handles sign-in, sign-up, forgot password, and OAuth callbacks. Auth layouts support centered, split, and minimal variants. Session is validated on each request via middleware.
Database
The schema covers profiles, subscriptions, teams, and API keys. All of those tables use RLS. Privileged writes go through API routes and server clients, not direct browser writes. The Supabase Postgres skill helps an AI assistant follow those patterns.
Decision Criteria
Stay on this integration if you want auth and database from one vendor and you will use the free or Pro Supabase plan. Choose another kit if you need Clerk, Better Auth, or a self-hosted-only Postgres path on day one.
Best For / Not Ideal For
Best for indie hackers who want fast auth and database setup on Supabase. Not ideal if you plan to replace Supabase with a custom auth or ORM stack from day one.
Evidence and Last Verified
Last verified: 2026-09-02. Supabase Free plan (supabase.com/pricing): 500 MB database per project, 50,000 monthly active users, 5 GB egress, 1 GB file storage, 2 active projects, pause after 1 week of inactivity. NextBento behavior: www.nextbento.dev/docs/supabase-setup. Re-check Supabase pricing; limits change.