Required access
Use a database user with read access to the source schemas and tables you want to sync. For a first pipeline, start with one table such aspublic.orders.
Connection fields
| Field | Notes |
|---|---|
| Connection Name | A human-readable name shown in the app |
| Host | Database host or provider endpoint |
| Port | Usually 5432 |
| Database | Database name |
| Username | Source user |
| Password | Source user password |
| Schema | Usually public for first tests |
| SSL Mode | Use require for most hosted databases |
Setup flow
- Open Connections.
- Click + New Connection.
- Set role to Source.
- Choose PostgreSQL.
- Fill the form.
- Click Test Connection.
- Save only after the test succeeds.
Builder behavior
After a pipeline shell is created, the Source node can:- test the connection again
- discover source schemas and tables
- include selected streams as
schema.table - preview rows for the active stream
public__orders.