Determining DB instance class support in AWS Regions - Amazon Relational Database Service
Using the Amazon RDS pricing page to determine DB instance class support in AWS RegionsUsing the AWS CLI to determine DB instance class support in AWS Regions

Determining DB instance class support in AWS Regions

To determine the DB instance classes supported by each DB engine in a specific AWS Region, you can take one of several approaches. You can use the AWS Management Console, the Amazon RDS Pricing page, or the describe-orderable-db-instance-options command for the AWS Command Line Interface (AWS CLI).

Note

When you perform operations with the AWS Management Console, it automatically shows the supported DB instance classes for a specific DB engine, DB engine version, and AWS Region. Examples of the operations that you can perform include creating and modifying a DB instance.

Using the Amazon RDS pricing page to determine DB instance class support in AWS Regions

You can use the Amazon RDS Pricing page to determine the DB instance classes supported by each DB engine in a specific AWS Region.

To use the pricing page to determine the DB instance classes supported by each engine in a Region

  1. Go to Amazon RDS Pricing.

  2. In the AWS Pricing Calculator for Amazon RDS section, choose Create your custom estimate now.

  3. In Choose a Region, choose an AWS Region.

  4. In Find a Service, enter Amazon RDS.

  5. Choose Configure for your configuration option and DB engine.

  6. Use the section for compatible instances to view the supported DB instance classes.

  7. (Optional) Choose other options in the calculator, and then choose Save and view summary or Save and add service.

Using the AWS CLI to determine DB instance class support in AWS Regions

You can use the AWS CLI to determine which DB instance classes are supported for specific DB engines and DB engine versions in an AWS Region. The following table shows the valid DB engine values.

Engine names Engine values in CLI commands More information about versions

Db2

db2-ae

db2-se

Db2 on Amazon RDS versions

MariaDB

mariadb

MariaDB on Amazon RDS versions

Microsoft SQL Server

sqlserver-ee

sqlserver-se

sqlserver-ex

sqlserver-web

Microsoft SQL Server versions on Amazon RDS

MySQL

mysql

MySQL on Amazon RDS versions

Oracle

oracle-ee

oracle-se2

Amazon RDS for Oracle Release Notes

PostgreSQL

postgres

Available PostgreSQL database versions

For information about AWS Region names, see AWS Regions.

The following examples demonstrate how to determine DB instance class support in an AWS Region using the describe-orderable-db-instance-options AWS CLI command.

Note

To limit the output, these examples show results only for the General Purpose SSD (gp2) storage type. If necessary, you can change the storage type to General Purpose SSD (gp3), Provisioned IOPS (io1), or magnetic (standard) in the commands.

Listing the DB instance classes that are supported by a specific DB engine version in an AWS Region

To list the DB instance classes that are supported by a specific DB engine version in an AWS Region, run the following command.

For Linux, macOS, or Unix:

aws rds describe-orderable-db-instance-options --engine engine --engine-version version \
    --query "*[].{DBInstanceClass:DBInstanceClass,StorageType:StorageType}|[?StorageType=='gp2']|[].{DBInstanceClass:DBInstanceClass}" \
    --output text \
    --region region

For Windows:

aws rds describe-orderable-db-instance-options --engine engine --engine-version version ^
    --query "*[].{DBInstanceClass:DBInstanceClass,StorageType:StorageType}|[?StorageType=='gp2']|[].{DBInstanceClass:DBInstanceClass}" ^
    --output text ^
    --region region

For example, the following command lists the supported DB instance classes for version 13.6 of the RDS for PostgreSQL DB engine in US East (N. Virginia).

For Linux, macOS, or Unix:

aws rds describe-orderable-db-instance-options --engine postgres --engine-version 15.4 \
    --query "*[].{DBInstanceClass:DBInstanceClass,StorageType:StorageType}|[?StorageType=='gp2']|[].{DBInstanceClass:DBInstanceClass}" \
    --output text \
    --region us-east-1

For Windows:

aws rds describe-orderable-db-instance-options --engine postgres --engine-version 15.4 ^
    --query "*[].{DBInstanceClass:DBInstanceClass,StorageType:StorageType}|[?StorageType=='gp2']|[].{DBInstanceClass:DBInstanceClass}" ^
    --output text ^
    --region us-east-1

Listing the DB engine versions that support a specific DB instance class in an AWS Region

To list the DB engine versions that support a specific DB instance class in an AWS Region, run the following command.

For Linux, macOS, or Unix:

aws rds describe-orderable-db-instance-options --engine engine --db-instance-class DB_instance_class \
    --query "*[].{EngineVersion:EngineVersion,StorageType:StorageType}|[?StorageType=='gp2']|[].{EngineVersion:EngineVersion}" \
    --output text \
    --region region

For Windows:

aws rds describe-orderable-db-instance-options --engine engine --db-instance-class DB_instance_class ^
    --query "*[].{EngineVersion:EngineVersion,StorageType:StorageType}|[?StorageType=='gp2']|[].{EngineVersion:EngineVersion}" ^
    --output text ^
    --region region

For example, the following command lists the DB engine versions of the RDS for PostgreSQL DB engine that support the db.r5.large DB instance class in US East (N. Virginia).

For Linux, macOS, or Unix:

aws rds describe-orderable-db-instance-options --engine postgres --db-instance-class db.m7g.large \
    --query "*[].{EngineVersion:EngineVersion,StorageType:StorageType}|[?StorageType=='gp2']|[].{EngineVersion:EngineVersion}" \
    --output text \
    --region us-east-1

For Windows:

aws rds describe-orderable-db-instance-options --engine postgres --db-instance-class db.m7g.large ^
    --query "*[].{EngineVersion:EngineVersion,StorageType:StorageType}|[?StorageType=='gp2']|[].{EngineVersion:EngineVersion}" ^
    --output text ^
    --region us-east-1