PostgreSQL
Connect to PostgreSQL databases (self-hosted or cloud-managed services like Azure Database for PostgreSQL, Amazon RDS, or Supabase).
Connection Properties
| Property | Description |
|---|---|
| Host | Server hostname or IP. |
| Port | Default is 5432. |
| Database | The database name. |
| Schema | The schema to use. Default is public. |
| Username | Database username. |
| Password | Database password. |
Authentication Methods
- Username/Password: The only supported method.
Tips
- Cloud-hosted PostgreSQL databases usually require SSL. Check the SSL options in the connection dialog.
- If you're using a managed service, make sure your IP is allowed through the firewall.