Living this dream with the CI/CD pipeline deploying to a cloud system.

It's really, really hard to shrink the problem and troubleshoot with large, opaque, containerized chunks of functionality and services.

Can I just connect to a DB in a terminal and run some SQL to figure out the problem?

Why, no: no, you cannot.