> ## Documentation Index
> Fetch the complete documentation index at: https://docs.softr.io/llms.txt
> Use this file to discover all available pages before exploring further.
# 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.
1. **Log in to Supabase** and go to the **dashboard**.
2. Click on the **project** you want to connect to Softr.
1. Click the **Connect** button at the top of the project settings page.
2. Change the **Type** to **PSQL**.
3. Open the **View parameters** dropdown under the **Session Pooler** section.
1. Locate the **Configuration Parameters** section.
2. Copy and securely store the following credentials:
* **Host**
* **Database**
* **Port** (default is `5432`)
* **User**
* **Password** (usually the project password)
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
2. Click on Database
3. Type in the pool size number (should be 45 or greater)
4. Click Save
1. **Log in to Softr** and go to **Data Sources** in the left-hand menu.
2. Click the **Connect Data Source** button in the upper-right corner.
3. Select **Supabase**, then click **Continue**.
1. Copy and paste your Supabase credentials into the appropriate fields in Softr:
* **Host**
* **Database**
* **Port** (`5432` by default)
* **User**
* **Password**
2. Enter a **custom name** for your connection (optional).
3. Click **Connect** to complete the setup.
You should end up with something like this:
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.
To display your data in the app, connect a [dynamic block](/core-concepts-overview/c5VwEbsWtTfPyUZjmEKvfx/visualize-data-with-building-blocks/41p6U2eZs7zgY8zWmFV4eH#1859a723d691803d9551ecd7b3b0c043) (e.g. [List](/building-blocks/vikC2AWEpQGkZd4jGyoVxo/list-block/pQhPYuA28VXr5tLLFBcbCU), [Grid](/building-blocks/vikC2AWEpQGkZd4jGyoVxo/grid-block/42JZoeYwMsogZcveqh74QH), [Table](/building-blocks/vikC2AWEpQGkZd4jGyoVxo/table-block-/j7rGwu7J7zuU69h3bZ7HFe)) to your Supabase table:
1. Go to the Block **source** **tab** and select your Supabase integration.
2. Select the **database** and **schema** you want to connect.
3. Pick the **table** you want to use or **add a new** **query**
4. Optionally, select the **primary field**.
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.
2. Change the **Type** to **PSQL**.
3. Open the **View parameters** dropdown under the **Session Pooler** section.
You should end up with something like this:
