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.

Frequently asked questions

Does NextBento require Supabase?

Yes. NextBento is built on Supabase for auth and database. You need a Supabase project to run it.

What's the Supabase Free plan?

As of 2026-09-02 on supabase.com/pricing: 500 MB database, 50,000 MAUs, 5 GB egress, 1 GB storage, 2 active projects, pause after a week of inactivity. Enough for most early-stage apps. Confirm on their pricing page.

Can I use a different database?

NextBento is designed for Supabase. Switching would require significant changes to auth and queries.

Related pages

Back to Integrations · Programmatic SEO docs · Pricing