We are using an Aurora AWS Serverless MySQL Cluster.
These serverless clusters cannot be exposed outside of their VPC.
So the options are running self-hosted inside the VPC, or setup an SSH tunnel.
There is a 3rd option here, as this DB is exposed to the outside world - thorough the “AWS RDS Data API”
I would like to add this as a query runner.
- Boto3 is already integrated with this API (https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/rds-data.html)
- The queries themselves are MySQL.
- The configuration to connect to this will require AWS Access Key (like Dynamo), Cluster ARN, Secret ARN (for the mysql user+password), and database name.
So it looks pretty simple and I’m willing to open a PR for it.
Just wondering if there are any thoughts / gotchas / tips / tricks I should be aware of.