aws pricingコマンドでAmazon RDSのオンデマンド料金を取得してみた

aws pricing describe-services \
  --service-code AmazonRDS \
  --region us-east-1 \
  --output json \
| jq -r '.Services[0].AttributeNames[]' | sort -f

acu
clockSpeed
currentGeneration
databaseEdition
databaseEngine
dedicatedEbsThroughput
deploymentModel
deploymentOption
engineCode
engineMajorVersion
engineMediaType
enhancedNetworkingSupported
extendedSupportPricingYear
group
groupDescription
instanceFamily
instanceType
instanceTypeFamily
LeaseContractLength
licenseModel
limitlesspreview
location
locationType
maxVolumeSize
memory
minVolumeSize
networkPerformance
normalizationSizeFactor
OfferingClass
operation
physicalProcessor
processorArchitecture
processorFeatures
productFamily
PurchaseOption
regionCode
Restriction
servicecode
servicename
storage
storageMedia
termType
unbundledLicensing
usagetype
vcpu
volumeName
volumeType
windowslicensemultiplier

aws pricing get-attribute-values \
  --service-code AmazonRDS \
  --attribute-name databaseEngine \
  --region us-east-1 \
  --output json \
| jq -r '.AttributeValues[].Value'

Any
Aurora MySQL
Aurora PostgreSQL
Db2
MariaDB
MySQL (on-premise for Outpost)
MySQL
Oracle (on-premises for Outposts)
Oracle
PostgreSQL (on-premise for Outpost)
PostgreSQL
SQL Server (on-premise for Outpost)
SQL Server

{
  echo "| 属性 | 件数 | 値の候補 |"
  echo "| --- | --- | --- |"
  for attr in $(aws pricing describe-services \
    --service-code AmazonRDS \
    --region us-east-1 \
    --output json \
  | jq -r '.Services[0].AttributeNames[]' | sort -f); do
    aws pricing get-attribute-values \
      --service-code AmazonRDS \
      --attribute-name "$attr" \
      --region us-east-1 \
      --output json \
    | jq -r --arg attr "$attr" '
        [.AttributeValues[].Value] as $v
        | ($v | length) as $n
        | if $n > 15
          then "| `\($attr)` | \($n) | \($v[0:4] | join(" / ")) …など |"
          else "| `\($attr)` | \($n) | \($v | join(" / ")) |"
          end
      '
  done
}

| 属性 | 件数 | 値の候補 |
| --- | --- | --- |
| `acu` | 1 | 1 |
| `clockSpeed` | 5 | 2.3 GHz / 2.4 GHz / 2.5 GHz / Up to 3.1 GHz / Up to 3.3 GHz |
| `currentGeneration` | 2 | No / Yes |
| `databaseEdition` | 14 | Advanced / Any / Community / Developer / Enterprise Developer / Enterprise-BYOM / Enterprise / Express / Standard Developer / Standard One / Standard Two / Standard-BYOM / Standard / Web |
| `databaseEngine` | 13 | Any / Aurora MySQL / Aurora PostgreSQL / Db2 / MariaDB / MySQL (on-premise for Outpost) / MySQL / Oracle (on-premises for Outposts) / Oracle / PostgreSQL (on-premise for Outpost) / PostgreSQL / SQL Server (on-premise for Outpost) / SQL Server |
| `dedicatedEbsThroughput` | 27 | 1000 Mbps / 10000 Mbps / 12000 Mbps / 1250 Mbps …など |
| `deploymentModel` | 1 | Custom |
| `deploymentOption` | 5 | Multi-AZ (SQL Server Mirror) / Multi-AZ (readable standbys) / Multi-AZ / Single-AZ (Oracle RAC) / Single-AZ |
| `engineCode` | 43 | 0 / 10 / 11 / 12 …など |
| `engineMajorVersion` | 8 | 10 / 11 / 12 / 13 / 14 / 15 / 5.7 / 8.0 |
| `engineMediaType` | 2 | AWS-provided / Customer-provided |
| `enhancedNetworkingSupported` | 1 | Yes |
| `extendedSupportPricingYear` | 4 | Year 1, Year 2 (PP) / Year 1, Year 2 / Year 3 (PP) / Year 3 |
……後略

aws pricing get-attribute-values \
  --service-code AmazonRDS \
  --attribute-name engineCode \
  --region us-east-1 \
  --output json \
| jq -r '.AttributeValues[].Value' | sort -n | paste -sd' ' -
0 2 3 4 5 6 8 9 10 11 12 14 15 16 18 19 20 21 27 28 29 34 35 50 51 52 53 210 220 230 231 232 240 241 401 402 403 405 406 407 410 411 420

aws pricing get-attribute-values \
  --service-code AmazonRDS \
  --attribute-name engineCode \
  --region us-east-1 \
  --output json \
| jq -r '.AttributeValues[].Value' | sort -n | while IFS= read -r c; do
  aws pricing get-products \
    --service-code AmazonRDS \
    --region us-east-1 \
    --output json \
    --filters "Type=TERM_MATCH,Field=engineCode,Value=$c" \
              "Type=TERM_MATCH,Field=productFamily,Value=Database Instance" \
  | jq -r --arg c "$c" '
      [.PriceList[] | fromjson | .product.attributes] as $r
      | def u(f): ($r | map(f // "-") | unique | join(" / ")) | if . == "" then "-" else . end;
        [$c, ($r | length | tostring),
         u(.databaseEngine), u(.databaseEdition), u(.licenseModel),
         u(.engineMediaType), u(.deploymentModel)]
      | @tsv'
done | { printf 'code\t件数\tengine\tedition\tlicense\tmedia\tdeployModel\n'; cat; } | column -t -s$'\t'

REGION=ap-northeast-1
DBENGINE=MySQL
TS=$(date +%Y%m%d_%H%M%S)

OD_CSV="rds_ondemand_${DBENGINE}_${REGION}_${TS}.csv"

aws pricing get-products \
  --service-code AmazonRDS \
  --region us-east-1 \
  --output json \
  --filters "Type=TERM_MATCH,Field=regionCode,Value=$REGION" \
            "Type=TERM_MATCH,Field=databaseEngine,Value=$DBENGINE" \
            "Type=TERM_MATCH,Field=productFamily,Value=Database Instance" \
| jq -r '
  .PriceList[] | fromjson
  | .product.attributes as $a
  | select($a.deploymentOption=="Single-AZ" or $a.deploymentOption=="Multi-AZ")
  | (.terms.OnDemand // {})[]?.priceDimensions[]?
  | select(.unit=="Hrs")
  | [$a.instanceType, $a.deploymentOption, .pricePerUnit.USD]
  | @csv
' | sort -t, -k1,1 -k2,2 > /tmp/ondemand_body.csv

{ echo '"DBInstanceClass","MultiAZ","OnDemand"'; cat /tmp/ondemand_body.csv; } > "$OD_CSV"

echo "$OD_CSV"

rds_ondemand_MySQL_ap-northeast-1_20260929_014420.csv

% head -n 15  rds_ondemand_MySQL_ap-northeast-1_20260929_014306.csv
"DBInstanceClass","MultiAZ","OnDemand"
"db.m1.large","Multi-AZ","0.5800000000"
"db.m1.large","Single-AZ","0.2900000000"
"db.m1.medium","Multi-AZ","0.2900000000"
"db.m1.medium","Single-AZ","0.1450000000"
"db.m1.small","Multi-AZ","0.1500000000"
"db.m1.small","Single-AZ","0.0750000000"
"db.m1.xlarge","Multi-AZ","1.1700000000"
"db.m1.xlarge","Single-AZ","0.5850000000"
"db.m2.2xlarge","Multi-AZ","1.4800000000"
"db.m2.2xlarge","Single-AZ","0.7400000000"
"db.m2.4xlarge","Multi-AZ","2.9500000000"
"db.m2.4xlarge","Single-AZ","1.4750000000"
"db.m2.xlarge","Multi-AZ","0.7300000000"
"db.m2.xlarge","Single-AZ","0.3650000000"

"DBInstanceClass","MultiAZ","OnDemand","Storage"
"db.r5.12xlarge","Single-AZ","10.9200000000","Aurora IO Optimization Mode"
"db.r5.12xlarge","Single-AZ","8.4000000000","EBS Only"

REGION=ap-northeast-1
DBENGINE=MySQL

aws pricing get-products \
  --service-code AmazonRDS \
  --region us-east-1 \
  --output json \
  --filters "$(jq -cn --arg region "$REGION" --arg engine "$DBENGINE" '[
      {Type:"TERM_MATCH", Field:"regionCode",       Value:$region},
      {Type:"TERM_MATCH", Field:"databaseEngine",   Value:$engine},
      {Type:"TERM_MATCH", Field:"productFamily",    Value:"Database Instance"},
      {Type:"ANY_OF",     Field:"deploymentOption", Value:"Single-AZ,Multi-AZ"},
      {Type:"NONE_OF",    Field:"storage",          Value:"Aurora IO Optimization Mode"},
      {Type:"NONE_OF",    Field:"deploymentModel",  Value:"Custom"}
    ]')" \
| jq -r '
  .PriceList[] | fromjson
  ……

……
  --filters "Type=TERM_MATCH,Field=regionCode,Value=$REGION" \
            "Type=TERM_MATCH,Field=databaseEngine,Value=$DBENGINE" \
            "Type=TERM_MATCH,Field=productFamily,Value=Database Instance" \
| jq -r '
  .PriceList[] | fromjson
  | .product.attributes as $a
  | select($a.deploymentOption=="Single-AZ" or $a.deploymentOption=="Multi-AZ")
  | select($a.storage != "Aurora IO Optimization Mode")
  | select(($a.deploymentModel // "") != "Custom")
……

% aws rds describe-reserved-db-instances-offerings \
  --region ap-northeast-1 \
  --output json \
| jq -r '[.ReservedDBInstancesOfferings[].ProductDescription] | unique[]'
aurora-mysql
aurora-postgresql
custom-sqlserver-ee(byol)
custom-sqlserver-ee(li)
custom-sqlserver-se(byol)
custom-sqlserver-se(li)
custom-sqlserver-web(li)
db2-ae(byol)
db2-ae(mpl)
db2-se(byol)
db2-se(mpl)
mariadb
mysql
oracle-ee(byol)
oracle-se2 (byol)
oracle-se2(li)
postgresql
sqlserver-ee(li)
sqlserver-ex(li)
sqlserver-se(li)
sqlserver-web(li)

REGION=ap-northeast-1
ENGINE="oracle-ee(byol)"
TS=$(date +%Y%m%d_%H%M%S)

engine_code() {
  case "$(echo "$1" | tr -d ' ')" in
    "mysql")                     echo 2 ;;
    "postgresql")                echo 14 ;;
    "mariadb")                   echo 18 ;;
    "aurora-mysql")              echo 16 ;;
    "aurora-postgresql")         echo 21 ;;
    "oracle-ee(byol)")           echo 5 ;;
    "oracle-se2(byol)")          echo 19 ;;
    "oracle-se2(li)")            echo 20 ;;
    "sqlserver-ee(li)")          echo 15 ;;
    "sqlserver-se(li)")          echo 12 ;;
    "sqlserver-web(li)")         echo 11 ;;
    "sqlserver-ex(li)")          echo 10 ;;
    "db2-ae(byol)")              echo 29 ;;
    "db2-ae(mpl)")               echo 35 ;;
    "db2-se(byol)")              echo 28 ;;
    "db2-se(mpl)")               echo 34 ;;
    "custom-sqlserver-ee(byol)") echo 406 ;;
    "custom-sqlserver-ee(li)")   echo 403 ;;
    "custom-sqlserver-se(byol)") echo 405 ;;
    "custom-sqlserver-se(li)")   echo 402 ;;
    "custom-sqlserver-web(li)")  echo 401 ;;
    *) echo "" ;;
  esac
}

ENGINE_CODE=$(engine_code "$ENGINE")
ENGINE_SLUG=$(echo "$ENGINE" | sed -E 's/[[:space:]]+//g; s/[()]/_/g; s/_+$//')

OD_CSV="rds_ondemand_${ENGINE_SLUG}_${REGION}_${TS}.csv"

aws pricing get-products \
  --service-code AmazonRDS \
  --region us-east-1 \
  --output json \
  --filters "Type=TERM_MATCH,Field=regionCode,Value=$REGION" \
            "Type=TERM_MATCH,Field=engineCode,Value=$ENGINE_CODE" \
            "Type=TERM_MATCH,Field=productFamily,Value=Database Instance" \
| jq -r '
  .PriceList[] | fromjson
  | .product.attributes as $a
  | select($a.deploymentOption=="Single-AZ" or $a.deploymentOption=="Multi-AZ")
  | select($a.storage != "Aurora IO Optimization Mode")
  | (.terms.OnDemand // {})[]?.priceDimensions[]?
  | select(.unit=="Hrs")
  | [$a.instanceType, $a.deploymentOption, .pricePerUnit.USD]
  | @csv
' | sort -t, -k1,1 -k2,2 > /tmp/ondemand_body.csv

{ echo '"DBInstanceClass","MultiAZ","OnDemand"'; cat /tmp/ondemand_body.csv; } > "$OD_CSV"

echo "$OD_CSV"

rds_ondemand_oracle-ee_byol_ap-northeast-1_20260929_145201.csv

% head -n 15 rds_ondemand_oracle-ee_byol_ap-northeast-1_20260929_145201.csv
"DBInstanceClass","MultiAZ","OnDemand"
"db.m3.2xlarge","Multi-AZ","1.9300000000"
"db.m3.2xlarge","Single-AZ","0.9650000000"
"db.m3.large","Multi-AZ","0.4800000000"
"db.m3.large","Single-AZ","0.2400000000"
"db.m3.medium","Multi-AZ","0.2400000000"
"db.m3.medium","Single-AZ","0.1200000000"
"db.m3.xlarge","Multi-AZ","0.9700000000"
"db.m3.xlarge","Single-AZ","0.4850000000"
"db.m4.10xlarge","Multi-AZ","10.1740000000"
"db.m4.10xlarge","Single-AZ","5.0870000000"
"db.m4.16xlarge","Multi-AZ","16.2816000000"
"db.m4.16xlarge","Single-AZ","8.1408000000"
"db.m4.2xlarge","Multi-AZ","2.0340000000"
"db.m4.2xlarge","Single-AZ","1.0170000000"