AWS CLI and jq fu

jq.sh

# Using AWS CLI with jq can be a very powerful tool to collect various reports from your AWS account. 
# With the `@tsv` filter we can write TSV output for easy copy & pasting into our favourite spreadsheet app
# Use `@csv` to get a CSV output instead

# List VPCs with names
aws ec2 describe-vpcs | jq -r '.Vpcs[]|[.VpcId,(.Tags|map(select(.Key=="Name"))[0].Value)]|@tsv'

# List EC2 instances with selected attributes
aws ec2 describe-instances | jq -r '.Reservations[].Instances[]|[.InstanceId,.InstanceType,.State.Name,.VpcId,(.Tags|map(select(.Key=="Name"))[0].Value)]|@tsv'

# Kubectl is another candidate that produces JSON output consumable by jq:

# List of nodes and role:
kubectl get node -o json | jq -r '.items[] | [.metadata.labels["kubernetes.io/role"],.metadata.name] | @tsv'

On Mac, pipe into pbcopy to send output to clipboard