Connect IBM Cloud Databases for PostgreSQL to Excel, Sheets and AI

The port is per deployment, and the card deliberately leaves it blank

Nearly every other Postgres card here prefills 5432 because nearly every other service uses it. This one does not, and the empty field is the point.

• IBM allocates a port to each deployment rather than running everything on the standard one. Two databases in the same account will not share a port.
• So the field starts empty and the card asks for it explicitly. A prefilled 5432 would be wrong far more often than right, and wrong in a way that looks like a network problem rather than a typo.
• Take the port from the same Endpoints panel as the hostname. It is in the connection string IBM gives you, immediately after the host.
• If a saved connection times out rather than being refused, the port is the first thing to re-check against the dashboard.

IBM issues its own certificate authority, and what the agent does about it

This is the honest bit, and it is more specific than the usual TLS paragraph.

• The connection is encrypted, and the agent forces it. TLS is required for IBM Cloud hostnames whether or not the SSL checkbox is ticked.
• The certificate chain is not verified. IBM fronts deployments with a certificate from its own authority, and the agent has no way to be given that authority's certificate to check against.
• IBM's own connection string usually carries sslmode=verify-full. That parameter is not read — the agent takes the host, port, database, username and password out of the string and applies its own TLS setting, which requires encryption without validating the chain.
• Read it as protection against anyone reading the traffic in transit, not as proof of which server answered. If chain verification against IBM's CA matters for your compliance position, this is the detail to note.

-- Ordinary Postgres, read-only, over TLS
SELECT   c.name,
         COUNT(o.id)   AS orders,
         SUM(o.amount) AS revenue
FROM     public.customers AS c
JOIN     public.orders    AS o ON o.customer_id = c.id
WHERE    o.placed_at >= now() - interval '30 days'
GROUP BY c.name
ORDER BY revenue DESC;