What problem does it solve?
It solves the problem of wiring authentication, database access, and app routing in a Next.js project without mixing insecure client-side patterns or losing type safety.
Core Features & Use Cases
- Supabase Auth (server-side): Handles sign-in, OAuth callback exchange, session-aware access, and protected routes via middleware and server clients.
- Drizzle ORM for Postgres: Provides type-safe, deterministic database querying and schema definitions, including relationships to auth-derived profiles.
- End-to-end app scaffolding: Covers common production needs like revalidation after mutations, storage uploads, realtime updates, and secure sign-out flows.
Use case example: You want a multi-page dashboard where only authenticated users can access content, user data is stored in Postgres with safe typed queries, avatars upload to Supabase Storage, and UI updates in real time when database records change.
Quick Start
Tell the AI: "Set up a Next.js App Router project using Supabase Auth and Drizzle ORM, including middleware-protected routes, server/client Supabase clients, and example auth pages with sign-in and callback handling."