Docs
Start building
Code

Database

Connect Supabase, Postgres, or SQLite: schema, data, and SQL.

1 min read · 6 sections

Code has a built-in database panel. Connect a provider once and you get a visual schema, a data editor, drift detection, and a SQL console, without leaving the workspace.

Providers

ProviderConnectionFeatures
SupabaseOAuthSchema, data CRUD, drift & apply, SQL
PostgreSQLConnection stringSchema, data CRUD, drift & apply, SQL
SQLiteContainer-localSchema, data CRUD, drift & apply, SQL

Connecting Supabase

Click connect and run the OAuth flow in a popup, then pick an existing Supabase project or create a new one right from the stepper. Credentials are stored encrypted, the schema is fetched automatically, an ER diagram renders, and the data panel goes live.

Schema view

An ER diagram shows your tables and the foreign-key relationships between them. Create tables and inspect columns from here.

Schema drift & apply

Modus diffs the schema it designed against the live database and splits the differences into additive and destructive changes. Apply pushes the pending migration to the live database; destructive changes are refused until you explicitly confirm them in a separate dialog, so a rename can never silently drop a column.

Data panel

FeatureWhat it does
Virtual gridSmooth scrolling over large tables
CRUDAdd, edit, and delete rows
Bulk actionsSelect multiple rows, delete in one go
FilterPer-column filtering
Pagination50 / 100 / 200 rows
Row drawerA detail form with type-aware field editors

SQL console

Run arbitrary SQL against the connected database and get back columns, rows, a row count, and timing.