Supabase ​

Supabase is an open-source Postgres platform with an auto-generated REST API, object storage, and database webhooks. The Supabase connector lets you query and manage table rows, call database functions, and search or download storage objects in Workato.

Use the Supabase connector to:

  • Query, insert, upsert, update, or delete rows in a Supabase table.
  • Call a database function.
  • Search or download objects in a storage bucket.
  • Trigger a recipe when a row is inserted, updated, or deleted.

You can also use custom actions to build a custom HTTP request to any Supabase API endpoint. Refer to the Supabase API documentation for endpoint details.

Install Supabase from the community library ​

Complete the following steps to install the Supabase connector from the community library:

1

Open the recipe editor and search for a connector. Alternatively, you can search for a connector in the community library.

Search for recipe editorSearch for community connectors in the recipe editor

2

Select the community connector you plan to install.

3

Click Install to install the connector from the community library.

Click installClick Install

4

Select Release connector. Alternatively, select Review code to review and modify the connector code before releasing it to the workspace.

Release connectorRelease the connector

5

Summarize any changes you made to the connector, then click Release to allow workspace collaborators to use the connector in recipes.

The Confirm release dialogThe Confirm release dialog

Connection setup ​

The Supabase connector uses API key authentication.

Supabase setup for API key authentication ​

Complete the following steps to find your Supabase project URL and API key:

1

Sign in to your Supabase account and open your project.

2

Go to Project Settings > Data API in the sidebar.

3

Copy and save the API URL for use in Workato. For example, https://abcdefgh.supabase.co.

4

Go to Project Settings > API Keys.

5

Copy and save a Secret key for use in Workato. For example, sb_secret_Abcd.

Connect to Supabase using API key authentication ​

Complete the following steps to set up a Supabase connection in Workato:

1

Click Create > Connection or press C twice.

2

Search for Supabase and select it as your app.

3

Provide a name for your connection in the Connection name field.

Supabase connection setup detailsSupabase connection setup

4

Use the Location drop-down menu to select the project where you plan to store the connection.

5

Enter the Project URL. This is the API URL in Supabase. Refer to Supabase setup for API key authentication for more information.

6

Enter the API key. Use the Secret key you saved from Supabase. Refer to Supabase setup for API key authentication for more information.

7

Click Connect.

Last updated: