PostgreSQL - Mora

Prerequisites

A PostgreSQL server reachable from the internet (or through your network configuration).
A database user with read access to the schemas and tables you want to query.

Required fields

Field	Description	Example
Name	A display name for this datasource in Mora.	`Mora warehouse`
Host	The hostname or IP address of your PostgreSQL server.	`localhost`
Port	The port PostgreSQL is listening on.	`5432`
Database	The name of the database to connect to.	`my_database`
User	The database user.	`admin`
Password	The user’s password.

Optional fields

Field	Description
SSL	Enable SSL for encrypted connections. Turn this on if your server requires or supports TLS.

Steps

Open Settings → Datasources → New.
Enter a name and select PostgreSQL as the type.
Fill in the fields above.
Click Test connection to verify Mora can reach your database.
Click Create.

Troubleshooting

Connection refused: Confirm the host, port, and that your firewall allows inbound connections from Mora’s IP.
Authentication failed: Double-check the user and password. Ensure the user has CONNECT privilege on the database.
SSL required: Toggle the SSL switch on and retry.

Catalog sync, how Mora discovers your schemas and tables.
Managing datasources, edit, re-test, or delete.

Datasources overview MySQL