Ask AI
All Categories
Data Sources
Supabase

Supabase

Connect Supabase to your Softr apps to interact with your data.

Supabase is a powerful open-source backend-as-a-service platform that allows you to store, manage, and query your data effortlessly. By integrating Supabase with Softr, you can seamlessly use your Supabase database in your Softr applications.

This integration allows you to:

  • Store and retrieve structured data dynamically
  • Use real-time updates in your Softr apps
  • Securely manage and scale your backend
โ„น๏ธ
Supabase is available on Professional and higher plans.

1. Connect Supabase to Softr

To use Supabase in Softr, you need to connect your Supabase project as a data source.

Step 1: Select your Supabase project

  1. Log in to Supabase and go to the dashboard.
  1. Click on the project you want to connect to Softr.
      2. Click on the project you want to connect to Softr
      Click on the project you want to connect to Softr

Step 2: Configure project settings

  1. Click the Connect button at the top of the project settings page.
      2. Click on Project settings in the bottom left menu
      Click on Project settings in the bottom left menu
  1. Change the Type to PSQL.
  1. Open the View parameters dropdown under the Session Pooler section.
      2. Click on the Database tab under Configuration
      Click on the Database tab under Configuration

Step 3: Copy your supabase credentials

  1. Locate the Configuration Parameters section.
  1. Copy and securely store the following credentials:
      • Host
      • Database
      • Port (default is 5432)
      • User
      • Password (usually the project password)
      Find the Connection parameters section and copy down the credentials
      Find the Connection parameters section and copy down the credentials

Step 4: Set the Pool Size

Setting the pool size ensures your Supabase database can support multiple connections from Softr at the same time. You set this number to 45 or greater.

  1. Click on Project Settings
  1. Click on Database
  1. Type in the pool size number (should be 45 or greater)
  1. Click Save
Notion image

Step 5: Connect Supabase to Softr

  1. Log in to Softr and go to Data Sources in the left-hand menu.
  1. Click the Connect Data Source button in the upper-right corner.
  1. Select Supabase, then click Continue.
Click on Connect Datasource
Click on Connect Datasource

Step 6: Enter your Supabase credentials in Softr

  1. Copy and paste your Supabase credentials into the appropriate fields in Softr:
      • Host
      • Database
      • Port (5432 by default)
      • User
      • Password
  1. Enter a custom name for your connection (optional).
  1. Click Connect to complete the setup.
Fill in the fields with the info from Supabase, then click Connect in the lower Right
Fill in the fields with the info from Supabase, then click Connect in the lower Right

You should end up with something like this:

Example connection information
Example connection information

Step 7: Restrict IP Access (Optional)

If you need to restrict IP addresses inside Supabase, add Softrโ€™s IP addresses to your allowed list:

  • 3.120.79.212
  • 3.123.159.186
  • 52.58.246.121

2. Connect your Supabase data to your Softr app

Once your Supabase account is connected, you can use it in any Softr application.

Step 1: Connect your data to a dynamic block

To display your data in the app, connect a dynamic block (e.g. List, Grid, Table) to your Supabase table:

  1. Go to the Block source tab and select your Supabase integration.
  1. Select the database and schema you want to connect.
  1. Pick the table you want to use or add a new query
  1. Optionally, select the primary field.
Notion image

Step 2: Map Supabase fields to item fields

When you connect your table to a block, you can choose which Supabase properties to display and map to a Softr field. This lets you control how your data appears in Softr.

Example: If you have an email field in Supabase, select an email field in Softr.

Notion image
ย 
Did this answer your question?
๐Ÿ˜ž
๐Ÿ˜
๐Ÿคฉ

Last updated on March 7, 2025

Xano BigQuery