Next.js + Tailwind + Supabase Boilerplate

FRAME LEDGER

A lightweight CRM for freelance video editors. The codebase now includes authentication screens, typed Supabase clients, a protected workspace, and SQL for row-level-secured CRM tables.

Auth env pendingRLS SQL includedTailwind wired

Included in this scaffold

Project Shell

Ready

App Router, TypeScript, Tailwind CSS, shared components, and typed Supabase helpers are in place.

Database

Ready

Schema SQL covers users, clients, projects, invoices, reminders, indexes, and row-level security.

Auth Credentials

Pending

Add NEXT_PUBLIC_SUPABASE_URL and NEXT_PUBLIC_SUPABASE_ANON_KEY to enable live auth.

Clients

Capture contact info, company details, and relationship notes for each editor's roster.

Projects

Track every job from lead to paid with due dates, value, and client links.

Invoices

Store invoice state, due dates, send timestamps, and payment timestamps per project.

Reminders

Queue follow-ups tied to clients or projects so nothing slips between edits.

Supabase Schema

SQL and types are already aligned

The SQL lives in supabase/schema.sql. It creates the CRM tables, indexes, enums, and row-level security policies. The app code mirrors that schema in types/database.ts.

Auth routes

/login, /sign-up, /logout

Protected route

/workspace

Shared folders

/app, /components, /lib, /types

Current gap

Add live Supabase keys to activate auth in production