When it comes to AWS remote database management, if you can't install the agent directly on the private host, you can set up a bastion running the agent.
Customizing the openapi-typescript generator involves an upfront investment. But with this in place, you can have more confidence in your branded types.
Although Amazon does not offer a way to run Neptune locally, Apache Gremlin Server is a close enough approximation for testing and development purposes.
In many cases, Gremlin queries that are deadlocked can be retried automatically. But in order for retries to work reliably, queries need to be idempotent.