Database Connection

Below, you can find provider-specific instructions to obtain connection details that you need to specify in your configuration file (see PowerSync Service Setup).

Supabase

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
```
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.
PowerSync has the Supabase CA certificate pre-configured — verify-full SSL mode can be used directly, without any custom certificates.
Under client_auth enable Supabase Authentication:

client_auth:
  supabase: true
  supabase_jwt_secret: [secret]

For more details, see Supabase Auth.

AWS RDS

Azure Postgres

Google Cloud SQL

Neon

Fly Postgres

For other providers and self-hosted databases:

Other / Self-hosted

Self-Hosting