Run Command let me execute read-only database queries from a managed instance when the database was unreachable from the laptop. Command output is capped at 24,000 characters, so larger results had to be compressed and fetched in chunks.
- What worked
- Reliable remote execution with status polling, and no SSH setup.
- What got in the way
- The output cap truncates results silently, and each round trip takes several seconds.
