PostgreSQL

Connect a PostgreSQL database, or any engine that speaks the PostgreSQL wire protocol, for federated analysis. Tables are mounted into the query engine and can be joined with datasets from other connectors.

When to use

• Operational or analytical PostgreSQL databases.
• PostgreSQL protocol–compatible engines: ClickHouse (via its PostgreSQL-protocol port) and CockroachDB connect through this connector — point it at the PostgreSQL-protocol endpoint.

For heavy analysis, prefer a read replica so long-running queries do not compete with production traffic.

Before you begin

Prepare a database role with:

• Read-only privileges: CONNECT on the database, USAGE on the target schemas, and SELECT on the target tables.
• Network connectivity from Datyo to the database. If it sits in a private network, allow inbound access from the service or expose a reachable replica.

Connection settings

Field	Required	Description
Host	Yes	Database hostname or address, e.g. db.example.com.
Port	Yes	Default 5432.
User	Yes	Role name. A read-only role is recommended.
Password	Yes	Stored encrypted; never shown after saving.
Database	Yes	The database to connect. Tables are read from the accessible schemas.

Test and save

Select the type, enter the fields, and use Test connection. On success the dataset saves and moves through "syncing → connected". A failure shows the specific reason. After connecting, choose the tables to import.

Capabilities

• Execution model: Federated. PostgreSQL tables can be joined with datasets from other connectors.
• Access: Read-only. Write statements are rejected.
• Schemas: Tables across the schemas the role can access are available for import.

Troubleshooting

• Test connection fails — verify host and port, role and password, and that the database exists.
• A schema or table is missing — grant USAGE on the schema and SELECT on the table; the role must be able to see an object for it to be listed.
• SSL requirements — if the server enforces SSL, ensure the account is permitted to connect over it.

Improve answer accuracy

• Add column descriptions for business fields.
• Re-sync after a schema change.

Related

• Connectors overview · MySQL · SQL Server