jq -r

aws ec2 describe-instances | jq -r '.Reservations[].Instances[]|.InstanceId+" "+.InstanceType+" "+(.Tags[] | select(.Key == "Name").Value)'

aws rds describe-db-instances | jq -r '.DBInstances[0].Endpoint.Address'

aws ec2 describe-route-tables | jq -r '.RouteTables[] | select(.Tags[].Value=="YOUR_TAG/PublicRouteTable") | .RouteTableId'

aws ec2 describe-vpcs | jq -r '.Vpcs[]'

See also

• jq, JSON, jq -r, jq -c, jid