Database Management

A Schema Explorer for Your Project

The builder includes a full database explorer for every schema in your connected project. You can inspect and edit the structures that Supasheet renders UI from — the same objects the Guide teaches you to create by hand in migrations.

Tables

For each table you can manage:

• Columns & metadata — types, defaults, and the presentation metadata used by the UI builder.
• Constraints — primary keys, unique and check constraints.
• Relationships — foreign keys between tables.
• Triggers — including one-click audit triggers that feed the built-in audit log.
• Security — Row Level Security policies and per-role table privileges.

Views & Materialized Views

Create and edit SQL views directly in the browser. Views are the workhorse of Supasheet: they back read-only resources, charts, dashboard widgets, and reports. Materialized views are supported for expensive aggregations, and each view gets its own metadata and role-permission settings, just like a table.

Custom Data Types

Define PostgreSQL enums and composite types visually. Enum columns automatically render as select inputs in the hosted app (see Data Types).

SQL Editor

A full SQL editor (with autocomplete) is built in for anything the forms don't cover — ad-hoc queries, data fixes, or prototyping the queries you'll use in charts and widgets.

Where's the Migration File?

Self-hosted Supasheet encourages migration-first workflows; the managed builder applies changes directly. If you also maintain a migration history (or plan to move to self-hosting later), you can dump your schema at any time with the Supabase CLI:

npx supabase db pull

Your database remains a standard Supabase project — nothing about the managed platform prevents you from using the Supabase dashboard or CLI alongside it.