amazon-web-servicesamazon-rdsaws-rds-data-service

AWS API to query RDS database


Is there any API to query a standard AWS RDS without using an SQL client? I see that there is a data API available for serverless Aurora databases (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html) but it doesn't work for all RDS types and is not available in all regions at the moment either.

Due to internal firewall rules port 3306 is blocked so I'm looking for another way to talk to an RDS (running the RDS on port 443 has been suggested but is a non-trivial work-around).


Solution

  • Currently the Data API for Aurora Serverless (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html) seems to be the only option.

    There does not appear to be any equivalent API for standard Aurora databases.