AWS Pricing API

http://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/price-changes.html#download-the-offer-index

for i in `wget -q -O- https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/index.json |  jq -r '.offers[] ' | egrep 'EC2|RDS|ElastiCache' | grep current | cut -d'"' -f4 | sed '1,$s/json/csv/g'`
do
     wget https://pricing.us-east-1.amazonaws.com$i
 done

wget -q -O- https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/index.json |  jq -r '.offers[] ' | egrep 'EC2|RDS' | grep current | cut -d'"' -f4 | sed '1,$s/json/csv/g'

--2016-03-31 14:46:39--  https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonRDS/current/index.csv

Proxy request sent, awaiting response... 200 OK

Length: 21460056 (20M) [application/octet-stream]

Saving to: ‘index.csv’

index.csv                                         100%[============================================================================================================>]  20.47M  36.1MB/s   in 0.6s

2016-03-31 14:46:39 (36.1 MB/s) - ‘index.csv’ saved [21460056/21460056]

--2016-03-31 14:46:39--  https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonEC2/current/index.csv

Proxy request sent, awaiting response... 200 OK

Length: 30152209 (29M) [application/octet-stream]

Saving to: ‘index.csv.2’

index.csv.2                                       100%[============================================================================================================>]  28.75M  45.7MB/s   in 0.6s

2016-03-31 14:46:40 (45.7 MB/s) - ‘index.csv.2’ saved [30152209/30152209]

cat index.csv | grep -i "ondemand" | cut -d'"' -f14-1000 | cut -d',' -f3-1000 |  grep "Database Instance" | egrep 'MySQL|Oracle|MariaDB|PostgreSQL|Aurora'  | cut -d',' -f2,8,9,26-27,29,11 | head
"1.9320000000","AmazonRDS","Asia Pacific (Seoul)","db.m4.2xlarge","MySQL",,"Multi-AZ"
"0.3700000000","AmazonRDS","US West (Oregon)","db.m3.xlarge","MySQL",,"Single-AZ"
"1.5900000000","AmazonRDS","US West (N. California)","db.m3.2xlarge","MySQL",,"Multi-AZ"
"0.2900000000","AmazonRDS","Asia Pacific (Singapore)","db.m1.medium","Oracle","Standard One","Multi-AZ"
"2.2200000000","AmazonRDS","US West (N. California)","db.r3.4xlarge","PostgreSQL",,"Single-AZ"
"0.2450000000","AmazonRDS","US West (N. California)","db.m1.large","Oracle","Standard One","Single-AZ"
"4.7600000000","AmazonRDS","Asia Pacific (Sydney)","db.m2.4xlarge","Oracle","Standard One","Multi-AZ"
"0.1200000000","AmazonRDS","Asia Pacific (Singapore)","db.m3.medium","Oracle","Standard","Single-AZ"
"0.0900000000","AmazonRDS","US East (N. Virginia)","db.m3.medium","MariaDB",,"Single-AZ"

"1.1400000000","AmazonRDS","EU (Frankfurt)","db.r3.2xlarge","MariaDB",,"Single-AZ"

cat index.csv.1 | grep -i "on demand" | cut -d',' -f10,18,16,37
"0.3680000000","US West (N. California)","m3.xlarge","RHEL"
"0.0200000000","Asia Pacific (Sydney)","t2.micro","Windows"
"0.2660000000","Asia Pacific (Singapore)","c1.medium","Windows"
"1.4660000000","Asia Pacific (Sydney)","r3.xlarge","Windows"
"0.2330000000","Asia Pacific (Tokyo)","c4.large","SUSE"
"0.6550000000","Asia Pacific (Singapore)","c1.xlarge","Linux"
"4.0920000000","AWS GovCloud (US)","i2.4xlarge","Windows"
"0.8980000000","Asia Pacific (Seoul)","r3.2xlarge","SUSE"
"1.7460000000","Asia Pacific (Sydney)","c4.2xlarge","Windows"
"0.3270000000","EU (Frankfurt)","c4.xlarge","RHEL"