Skip to main content
Version: 3.0.0-LTS

Supabase

ToolJet connects to your Supabase database, allowing you to directly interact with your Supabase back-end from within your ToolJet application.

info

NOTE: Before following this guide, it is assumed that you have already completed the process of Using Marketplace plugins.

Connection​

  • To connect to Supabase you need to have the Project URL and Service Role Secret. You can find these credentials in your API Settings on the Supabase dashboard. Make sure to copy the Service Role Secret key. This key has the ability to bypass Row Level Security.
Supabase API Settings

  • Establish a connection to Supabase by either clicking +Add new Data source on the query panel or navigating to the Data Sources page from the ToolJet dashboard.

  • Enter your Project URL and Service Role Secret into their designated fields.

  • Click Test Connection to validate your credentials. Click Save to store the data source.

Supabase Install

Querying Supabase​

  • To perform queries on Supabase in ToolJet, click the +Add button in the query manager located at the bottom panel of the editor.

  • Select the previously configured Supabase datasource.

  • In the Operation dropdown, select the desired operation type. ToolJet currently supports five query types for Supabase interactions.

  • Enter the table name and other required parameters for the selected operation and click on Run button to run the query.

Supabase query

info

Query results can be transformed using transformations. Read our transformations documentation.

Supported Operations​

You can create query for Supabase data source to perform several operations such as:

  1. Get Rows
  2. Create Row(s)
  3. Update Row(s)
  4. Delete Row(s)
  5. Count Rows

Get Rows​

Required parameters:​

  • Table - Database table name.

Optional Parameters:​

  • Where - Filter rows based on a condition.
  • Sort - Sort rows based on a column.
  • Limit - Limit the number of rows returned.
Get Rows

Create Row(s)​

Required parameters:​

  • Table - Database table name.
  • Body - Data to be inserted into the table. It should be an array of object(s).
Create Rows

Update Row(s)​

Required parameters:​

  • Table - Database table name.
  • Columns - Column name and value to be updated.

Optional Parameters:​

  • Where - Update rows based on a condition. If not provided, all rows will be updated.
Update Rows

Delete Row(s)​

Required parameters:​

  • Table - Database table name.
  • Where - Delete rows based on a condition.
Delete Rows

Count Rows​

Required parameters:​

  • Table - Database table name.

Optional Parameters:​

  • Where - Filter rows based on a condition.
Count Rows