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.