# Supabase (OAuth)

> Connect your Supabase database by signing in to Supabase, no connection string to copy.

Source: https://docs.stacksync.com/connectors/postgres/authorize-postgres/supabase-oauth

With the **Supabase (OAuth)** connector you sign in to Supabase and pick your project. Stacksync looks up the connection details for you, you only type the database password.

Prefer pasting a connection string? Use the [Supabase](/connectors/postgres/authorize-postgres/supabase) connector instead. Both create the same Postgres connection, so syncs behave the same whichever one you choose.

## 1. Select the Supabase (OAuth) connector

In Stacksync, open **Create Resource** and choose **Connection**.

<figure>
  <img src="/images/connectors/create-resource-connection-menu.webp" alt="Stacksync &#x22;All Resources&#x22; page with the &#x22;Create Resource&#x22; dropdown open and &#x22;Connection&#x22; highlighted." width="1044" height="509" loading="lazy" decoding="async" />

  <figcaption />
</figure>

Search for `supabase` and select **Supabase (OAuth)**.

<figure>
  <img src="/images/connectors/supabase-oauth-select-tile.webp" alt="Stacksync &#x22;Create a new Connection&#x22; app picker filtered on &#x22;supabase&#x22;, with an arrow pointing at the &#x22;Supabase (OAuth)&#x22; connector next to &#x22;Supabase&#x22;." width="1728" height="995" loading="lazy" decoding="async" />

  <figcaption />
</figure>

## 2. Authorize Stacksync in Supabase

A Supabase window opens automatically. Sign in if needed, then:

1. Under **Organization**, select the organization that owns your project.
2. Click **Authorize Stacksync**.

<figure>
  <img src="/images/connectors/supabase-oauth-authorize.webp" alt="Supabase &#x22;Authorize Stacksync&#x22; screen with arrows pointing at the Organization dropdown and the &#x22;Authorize Stacksync&#x22; button; permissions are read-only on Database, Organizations and Projects." width="1728" height="986" loading="lazy" decoding="async" />

  <figcaption />
</figure>

Stacksync asks for **read-only** access. It uses it only while you set up the connection, to list your projects and read their connection details, and does not store it.

<Callout type="info">
  If the Supabase window does not open, your browser probably blocked the popup. Allow popups for Stacksync and click **Connect Supabase**.
</Callout>

## 3. Complete the connection details

Back in Stacksync, the window closes and the connection details appear:

1. **Supabase Project**: select your project. If your organization has a single project, it is selected for you. Stacksync fills in the host, port, user and database from the project's connection pooler.
2. **Database password**: type your project's database password. Supabase never shares database passwords with third-party apps, so this is the only value you enter yourself. If you don't have it, reset it in your Supabase dashboard under **Project Settings > Database**.
3. **Schema**: pick the schema to sync (`public` by default).
4. If your Supabase project restricts inbound IPs, add the Stacksync IP addresses listed under **Allowlist Stacksync IPs** to its allowlist.

Click **Next**.

<figure>
  <img src="/images/connectors/supabase-oauth-configure.webp" alt="Stacksync &#x22;Configure connection&#x22; step for Supabase (OAuth) with a project selected, the database password filled in, the &#x22;public&#x22; schema, the Stacksync IP allowlist, and arrows pointing at the password field and the &#x22;Next&#x22; button." width="1728" height="998" loading="lazy" decoding="async" />

  <figcaption />
</figure>

## 4. Name and create the connection

1. **Connection Name**: give the connection a name you will recognize. Stacksync suggests a **Connection Resource ID** from it.
2. **Connection Region**: pick the region your syncs run in.
3. Leave **Make this connection available to other users in the workspace** checked to let your teammates use it.

Click **Create**.

<figure>
  <img src="/images/connectors/supabase-oauth-create.webp" alt="Stacksync &#x22;Create&#x22; step for Supabase (OAuth) with the Connection Name, Connection Resource ID, Connection Region and workspace sharing checkbox, and arrows pointing at the name field and the &#x22;Create&#x22; button." width="1711" height="983" loading="lazy" decoding="async" />

  <figcaption />
</figure>

Your Supabase database is now connected and ready to use in a sync or workflow.