Supabase Connection
Connect to a Supabase project to use Supabase Query, Insert, Update, and Delete nodes in your workflows.
Configuration
| Field | Description | Required |
|---|---|---|
| Connection String | PostgreSQL connection string from your Supabase dashboard | Yes |
Finding Your Connection String
- Go to your Supabase Dashboard
- Select your project
- Click the Connect button (top right)
- Copy the connection string for your preferred connection type (see below)
- Replace
[YOUR-PASSWORD]with your database password
Connection Types
Supabase offers three ways to connect. All are standard PostgreSQL connection strings — pick the one that fits your use case:
Session Mode Pooler (recommended)
postgresql://postgres.[REF]:[PASSWORD]@aws-0-[REGION].pooler.supabase.com:5432/postgres
Connects through Supabase's connection pooler (Supavisor) in session mode. Works with both IPv4 and IPv6 networks. This is the recommended option for most users.
Transaction Mode Pooler
postgresql://postgres.[REF]:[PASSWORD]@aws-0-[REGION].pooler.supabase.com:6543/postgres
Uses connection pooling for efficient resource usage. Best for high-concurrency or serverless workloads. Note that some PostgreSQL features (e.g., prepared statements, LISTEN/NOTIFY) are not available in transaction mode.
Direct Connection
postgresql://postgres:[PASSWORD]@db.[REF].supabase.co:5432/postgres
Connects directly to PostgreSQL without a pooler. Requires IPv6 support (or the Supabase IPv4 add-on). Best for one-off sessions or database migrations.
Usage
Once created, this connection becomes available in all Supabase nodes:
- Supabase Query
- Supabase Insert
- Supabase Update
- Supabase Delete