In ODC it would be extremely valuable to have an official and supported way to perform direct queries against application databases in stages beyond Development.
Currently, the only practical way to inspect database data is via ODC Studio in Development stage. Once the application is promoted to QA / Pre-Prod / Production, there is no official mechanism to query the database, even for simple troubleshooting or validation scenarios.
This creates a real operational gap:
In many cases, a simple SELECT query would immediately explain an issue. Instead, developers are forced to add temporary logging, deploy heavy diagnostic logic or reproduce issues back in Development (not always possible or effective).
Adding logs purely for troubleshooting, increases noise in the code (lots of LogMessages) and often feels wrong when a safe DB query would solve the issue in minutes
What would help:
An official DB query tool for ODC Studio or ODC Portal feature for controlled data inspection with proper auditing, permissions, and safeguards.
Why this is important:
- Modern cloud-native platforms rely heavily on observability and controlled introspection
- Troubleshooting issues in higher environments without DB visibility is unnecessarily hard
- This would significantly improve developer experience, support efficiency, and confidence in ODC
Having an official, supported way to query stage databases in ODC would remove the need for workarounds and align ODC with real-world operational needs.