Supasheet.

Database Setup

Initialize and configure your PostgreSQL database

Overview

Supasheet includes pre-built migrations in /supabase/migrations/ that create all necessary schemas, tables, and functions. You just need to apply them.

Local Setup (Development)

Start Supabase

npx supabase start

Starts local Supabase instance with PostgreSQL.

Apply Migrations

npx supabase db reset

Applies all migrations from /supabase/migrations/.

Verify Setup

npx supabase status

Check that all services are running.

Cloud Setup (Production)

Create Supabase Project

  1. Go to supabase.com/dashboard
  2. Click "New Project"
  3. Choose organization and region
  4. Set database password
  5. Wait for project creation (~2 minutes)
npx supabase link --project-ref your-project-ref

Get project-ref from dashboard URL: https://supabase.com/dashboard/project/[project-ref]

Push Migrations

npx supabase db push

Applies all local migrations to cloud database.

What Gets Created

The migrations automatically create:

  • Schemas: supasheet, public
  • Core Tables: accounts, roles, permissions, meta tables
  • Feature Tables: dashboards, charts, reports, audit logs
  • Storage Buckets: public, personal
  • Functions: Permission checks, audit triggers, meta generators
  • RLS Policies: Row-level security on all tables

Schema Exposure (Required)

After applying migrations, you must expose the supasheet schema via the PostgREST API. The public schema is already exposed by default.

Edit Supabase Configuration

Add the supasheet schema to /supabase/config.toml:

[api]
schemas = ["public", "supasheet"]

This exposes:

  • public - Your application tables (exposed by default)
  • supasheet - All Supasheet internal tables including accounts, roles, permissions, dashboards, charts, and reports

Restart Supabase (Local)

For local development, restart Supabase to apply the configuration:

npx supabase stop
npx supabase start

Update Cloud Configuration (Production)

For cloud/production, update via the Supabase Dashboard:

  1. Go to Project Settings → Data API
  2. Find Exposed schemas section
  3. Add supasheet to the list
  4. Save changes

Important: Without exposing the supasheet schema, Supasheet won't be able to access authentication, authorization, configuration, dashboards, charts, and reports. The application will not function correctly.

Adding Your Own Tables

Create new migrations for your application tables:

npx supabase migration new add_products_table

See Quickstart for complete examples.

Next Steps

Environment Variables

Configure Supasheet with environment variables

Production Checklist

Essential checks before going live

On this page

OverviewLocal Setup (Development)Start SupabaseApply MigrationsVerify SetupCloud Setup (Production)Create Supabase ProjectLink ProjectPush MigrationsWhat Gets CreatedSchema Exposure (Required)Edit Supabase ConfigurationRestart Supabase (Local)Update Cloud Configuration (Production)Adding Your Own TablesNext Steps