Skip to main content

Connect to PostgreSQL

Connect to external PostgreSQL databases including Supabase for spatial data analysis.

Step 1: Add Database Connection

  1. Go to Database Management
  2. Click “Add External Database”
  3. Select “PostgreSQL” from the database types

Step 2: Get Connection String from your Postgres Database

  1. Go to your database provider such as Supabase in this example
  2. Creacte new or select an existing postgres database project
  3. Click Connect at its top bar
  4. Copy the value of the session pool url and replace the password placeholder with your actual password
Connect PostgreSQL Step 2-1 Connect PostgreSQL Step 2-2

Step 3: Enter Connection String in Creation Connection Dialog

  1. Host: Your PostgreSQL server address
  2. Port: Default 5432 (or your custom port)
  3. Database: Target database name
  4. Username: Your database username
  5. Password: Your database password
  6. SSL Mode: Required for Supabase connections
Connect PostgreSQL Step 3

Step 4: Test and Save

Click “Save Connection”
For Supabase, use your project’s connection string and ensure SSL is enabled.

Get Expert Help

I