Provide a way to return valid RDS instance classes within a given region

[bluedoors]

Describe the feature

The EC2 apis currently provide an ability to return the available EC2 instance types within a given region.
eg
ec2 = boto3.client('ec2', region_name=region)
paginator = ec2.get_paginator('describe_instances')

as of my knowledge , AWS does not provide a similar method for RDS. for example a describe_db_instance_classes method

Use Case

When working multi-region I often need to programically return the valid RDS Instance classes that can be leveraged

Proposed Solution

rds = boto3.client('rds', region_name=region)
paginator = rds.get_paginator('describe_db_instance_classes')

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

SDK version used

1.26.153

Environment details (OS name and version, etc.)

MacOS

[RyanFitzSimmonsAK]

Hi @bluedoors, thanks for reaching out. To clarify, do you mean that you want to be able to get all the instance types offered by AWS in a region, or the existing instances that you have created in a region? Thanks!

[bluedoors]

@RyanFitzSimmonsAK, The former. So as with EC2 you can see the available instance types in a region (regardless of if you have created instances of them). In RDS presently you can only gather information on instances you have created. This is very important as new regions come online often with differing sets of initially available RDS Instance Classes and you have a multi-region strategy, or are looking to migrate workloads between regions.

[RyanFitzSimmonsAK]

Gotcha. Does describe_orderable_db_instance_options (https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/rds/client/describe_orderable_db_instance_options.html) fulfill your use case? The only required parameter is specifying an engine, and you can specify region to check if something is available in a specific region.

[bluedoors]

It does, thank you Ryan. I have used describe_orderable_db_instance_options and tested.