Database Connection

1. In your Supabase Dashboard, click Connect in the top bar:

   • Under Direct connection, copy the connection string. The hostname should be db.<PROJECT-ID>.supabase.co, and not, for example, aws-0-us-west-1.pooler.supabase.com.
   • Paste this URI into the uri field under replication > connections in your configuration file, for example:

     # config.yaml
   
     replication:
       connections:
         - type: postgresql
           uri: postgresql://postgres:[YOUR-PASSWORD]@db.abc.supabase.co:5432/postgres
   

2. Replace [YOUR-PASSWORD] with the password for the postgres user in your Supabase database.

   • Supabase also refers to this password as the database password or project password.

3. PowerSync has the Supabase CA certificate pre-configured — verify-full SSL mode can be used directly, without any custom certificates.

4. Under client_auth enable Supabase Authentication:

client_auth:
  supabase: true
  supabase_jwt_secret: [secret]

For more details, see Supabase Auth.

Add your connection details under replication > connections in your configuration file.

Notes:

1. The Username and Password is the powersync_role created in Source Database Setup.
2. PowerSync has the AWS RDS CA certificate pre-configured — verify-full SSL mode can be used directly, without any additional configuration required.

Add your connection details under replication > connections in your configuration file.

Notes:

• The Username and Password is the powersync_role created in Source Database Setup.
• PowerSync has the relevant Azure CA certificates pre-configured — verify-full SSL mode can be used directly, without any additional configuration required.

Add your connection details under replication > connections in your configuration file.

Notes:

• The Username and Password is the powersync_role created in Source Database Setup.
• The server certificate can be downloaded from Google Cloud SQL.
• If SSL is enforced, a client certificate and key must also be created on Google Cloud SQL, and added to your powersync.yaml file.

Add your connection details under replication > connections in your configuration file.

The Username and Password is the powersync_role created in Source Database Setup.

Add your connection details under replication > connections in your configuration file.

The Username and Password is the powersync_role created in Source Database Setup.