Skip to content

Schemas

About

A schema is a workspace within a Database that contains Tables, Views, and other database objects.

Schemas in Mathesar

You can organize your data into schemas in Mathesar and switch between schemas. In the Mathesar UI, you can only open one schema at a time.

Every database starts off with a schema called public.

Usage

  • If you have different sets of unrelated data, we recommend using one schema for each set of data. For example, you can use separate schemas for (a) tracking your movie collection, and (b) budgeting.
  • If you’re familiar with Airtable, think of schemas as a “Base”.

Resources