Navigating your Supabase database using the Data Explorer

Learn how to use the Data Explorer to find, filter and navigate your Supabase database data.

The Data Explorer is a feature that allows you to explore the data of your application, modify it, and create new records.

Unlike Supabase Studio's Data Explorer, Supamode's Data Explorer is integrated with Supamode's permission system and will provide a seamless experience for your users, thanks to smart forms that change based on the data types, and enhanced validation and search capabilities.

In short, the Data Explorer is a powerful tool that allows you to manage your data in a way that is tailored to your application's needs, and requires zero SQL knowledge to do so.

Data Explorer

Accessing the Data Explorer

To access the Data Explorer, you need to go to the Resources section in the Supamode UI.

Users will see a list of resources that they have access to, and they can click on a resource to view its data. Users can only see a resource if:

  1. Table synced: The resource was synced into Supamode using the supamode.sync_managed_tables function
  2. Data permissions: The user has the data permissions for the resource

Syncing your database tables into Supamode

The resource will be displayed in the Data Explorer if it was synced into Supamode using the supamode.sync_managed_tables function. If not, you have to sync the table first.

To sync the users table in the public schema, you can run the following function using Supabase SQL Editor:

sql
select supamode.sync_managed_tables('public', 'users');

Data Permissions

The resource will be displayed in the Data Explorer if the user has the data permissions for the resource. Please refer to the Data Permissions section for more information on how to configure the data permissions.

Tabs

The Data Explorer provides a tabbing system to allow users to switch between the different views of the resource, similar to a browser tab.

How it works:

  1. If you visit pages internal to the Data Explorer, the current tab will navigate to the new page.
  2. If you visit a page that is already open in a tab, the tab will be focused.
  3. To create a new tab, you can click on the New Tab button at the top left of the Data explorer

Tabs allow you to quickly switch between the different views of the resource, and to keep track of your work.

Data Explorer Tabs

Filtering Data

The Data Explorer allows you to filter the data using a neat full-text search bar at the very top of the page.

The easiest and quickest way to filter data is to use the full-text search bar at the very top of the page.

Full Text Search

Full text search will search for the query in all columns of the resource unless you specifically excluded some columns from the search when configuring the resource (or if they were excluded during indexing by Supamode's inferred data types).

Text filters

Text filters allow you to filter the data by a specific text value in a column.

You can use various operators (that change depending on the data type) to filter the data. For example, in the example below, we are filtering the slug property for values that are exactly postgres. This will, as you can see, yield no results.

Text Filters with Operator

However, users can change operator to Contains to get results.

Text Filters with Operator Contains

The operator will be displayed using a human-readable label that both technical and non-technical users can understand.

Users can change the filter or the operator by clicking on the filter badge, add new filters, or remove the filter by clicking on the X button.

Date filters

Date filters allow you to filter the data by a specific date value in a column. Supamode supports a variety of operators to filter the data, including data rages such as Is Between and Is Not Between, as well as single date values such as Is and Is Not, Is Before and Is After.

Relative Date Filters

You can also use absolute date filters to filter the data by a specific date value in a column.

Absolute Date Filters

You can also use between date filters to filter the data by a specific date range in a column.

Between Date Filters

Boolean filters

Boolean filters allow you to filter the data by a specific boolean value in a column.

Boolean Filters

Numeric filters

Numeric filters allow you to filter the data by a specific numeric value in a column.

Numeric Filters

Reference filters

Reference filters allow you to filter the data by a specific reference value in a column. Thanks to a smart autocomplete, users can easily find the reference they are looking for, without needing to know the exact value.

Reference Filters

Enum filters

Enum filters allow you to filter the data by a specific enum value in a column.

Enum Filters

To summon the global search dialog, you can use a quick keyboard shortcut:

  • Mac: Command + K
  • Windows: Ctrl + K

This will summon the global search dialog, where you can search for any record in the entire application.

This is easily one of the most powerful features of Supamode, as it allows you to quickly find any record in the entire application, without needing to know the exact value. The record will open in the currently focused tab.

Global Search

Sorting Data

The Data Explorer allows you to sort the data by a specific column which you can click on the column header - or by clicking the "Sort" button at the top right of the page.

In the example below, we are sorting the data by the Content column in ascending order.

Sorting

The selected column will be displayed in the "Sort" dropdown next to "Saved Views".

Saved Views

Saved views allow you to save a specific view of the data, and to quickly switch between them, or share them with specific roles of the application.

For example, you can create saved views such as: -

  • All users: This view will show all users in the application.
  • Active users: This view will show only active users in the application.
  • Inactive users: This view will show only inactive users in the application.
  • Users who today created a post: This view will show only users who created a post today.
  • Users who last logged in 30 days ago: This view will show only users who last logged in 30 days ago.

Thanks to a combination of relative date filters, you can easily create views that are tailored to your needs.

Selected Saved View

For example, you can save a view of the data that filters data for a specific user, and share this view with all accounts having the Customer Support role.

Create Saved View

Pinned Columns

The table view settings allow you to customize the table view to your liking. This is local to the user and won't affect other users. You can pin columns to the left of the table, and you can also hide columns.

Pinned Columns

Batch Actions

Batch actions allow you to perform actions on multiple records at once. For example, you can delete multiple records at once (at this time, only deletion is supported).

Batch Actions