Skip to main content

Supabase Schema Basics

Each plugin can optionally define its own Supabase schema.

You'll typically need:

  • A Postgres table (e.g. tasks, crm_leads, notes)
  • Row-Level Security (RLS) policies
  • Supabase storage buckets (for docs/files/images)

We recommend keeping each plugin's DB logic modular using Supabase's SQL migrations or external schema files.

Implementation Options​

You can use:

  • Supabase SQL Editor
  • Supabase CLI (supabase db push)
  • Or schema management in code (via drizzle-orm or similar)

Contributing Guidelines​

If you're contributing a plugin, include:

  • Supabase table schema
  • Example .sql or .json dump
  • RLS policy documentation

This helps other developers understand your data model and security requirements.