RDSの一覧をAWS CLIで取得する

aws rds describe-db-instances | jq -r '.DBInstances[] | [.DBInstanceIdentifier,.Engine,.DBInstanceClass,.MultiAZ] | @csv' | pbcopy

{
    "DBInstances": [
        {
            "DBInstanceIdentifier": "instancename",
            "DBInstanceClass": "db.m5.xlarge",
            "Engine": "mysql",
            "DBInstanceStatus": "available",
            "MasterUsername": "admin",
            "DBName": "dbname",
            "Endpoint": {
                "Address": "instancename.xxxxxxxxxx.ap-northeast-1.rds.amazonaws.com",
                "Port": 3306,
                "HostedZoneId": "Z24O6O9L7SGTNB"
            },
            "AllocatedStorage": 260,
            "InstanceCreateTime": "20YY-MM-DDT12:18:06.369000+00:00",
            "PreferredBackupWindow": "00:00-00:30",
            "BackupRetentionPeriod": 7,
            "DBSecurityGroups": [],
            "VpcSecurityGroups": [
                {
                    "VpcSecurityGroupId": "sg-xxxxxxxxxxxxxxxx",
                    "Status": "active"
                }
            ],
            "DBParameterGroups": [
                {
                    "DBParameterGroupName": "parametergroup-name",
                    "ParameterApplyStatus": "in-sync"
                }
            ],
            "AvailabilityZone": "ap-northeast-1c",
            "DBSubnetGroup": {
                "DBSubnetGroupName": "subnetgroup-name",
                "DBSubnetGroupDescription": "description",
                "VpcId": "vpc-xxxxxxxxxxxxxxxx",
                "SubnetGroupStatus": "Complete",
                "Subnets": [
                    {
                        "SubnetIdentifier": "subnet-xxxxxxxxxxxxxxxx",
                        "SubnetAvailabilityZone": {
                            "Name": "ap-northeast-1c"
                        },
                        "SubnetOutpost": {},
                        "SubnetStatus": "Active"
                    },
                    {
                        "SubnetIdentifier": "subnet-yyyyyyyyyyyyyyyy",
                        "SubnetAvailabilityZone": {
                            "Name": "ap-northeast-1a"
                        },
                        "SubnetOutpost": {},
                        "SubnetStatus": "Active"
                    }
                ]
            },
            "PreferredMaintenanceWindow": "wed:18:08-wed:18:38",
            "PendingModifiedValues": {},
            "LatestRestorableTime": "2022-06-07T11:55:00+00:00",
            "MultiAZ": false,
            "EngineVersion": "5.7.33",
            "AutoMinorVersionUpgrade": true,
            "ReadReplicaDBInstanceIdentifiers": [],
            "LicenseModel": "general-public-license",
            "OptionGroupMemberships": [
                {
                    "OptionGroupName": "default:mysql-5-7",
                    "Status": "in-sync"
                }
            ],
            "PubliclyAccessible": false,
            "StorageType": "gp2",
            "DbInstancePort": 0,
            "StorageEncrypted": true,
            "KmsKeyId": "arn:aws:kms:ap-northeast-1:000000000000:key/xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx",
            "DbiResourceId": "db-HJAVPUIT6WLTWNBXCXEMCHOGFE",
            "CACertificateIdentifier": "rds-ca-2019",
            "DomainMemberships": [],
            "CopyTagsToSnapshot": true,
            "MonitoringInterval": 0,
            "DBInstanceArn": "arn:aws:rds:ap-northeast-1:000000000000:db:instancename",
            "IAMDatabaseAuthenticationEnabled": false,
            "PerformanceInsightsEnabled": true,
            "PerformanceInsightsKMSKeyId": "arn:aws:kms:ap-northeast-1:000000000000:key/xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx",
            "PerformanceInsightsRetentionPeriod": 7,
            "DeletionProtection": true,
            "AssociatedRoles": [],
            "TagList": [
                {
                    "Key": "TagKey",
                    "Value": "TagValue"
                }
            ],
            "CustomerOwnedIpEnabled": false,
            "ActivityStreamStatus": "stopped",
            "BackupTarget": "region"
        },
...

aws rds describe-db-instances\
   --max-items 1000\
   --query 'DBInstances[].{
        DBInstanceIdentifier:DBInstanceIdentifier,
        Engine:Engine,
        DBInstanceClass:DBInstanceClass,
        MultiAZ:MultiAZ,
        CMB:TagList[?Key==`CmBillingGroup`]|[0].Value
        }'\
   --output json\
   | jq -r ".[] | [.DBInstanceIdentifier,.Engine,.DBInstanceClass,.MultiAZ,.CMB] | @csv" | pbcopy