AWS CLI Script to Detect Regions with DynamoDB Tables

check_dynamo_regions.sh

#!/bin/bash

# Usage: bash check_dynamo_regions.sh

echo "Checking DynamoDB tables in all AWS regions..."

# Get list of enabled regions
regions=$(aws ec2 describe-regions --query "Regions[*].RegionName" --output text)

for region in $regions; do
    echo "🔍 Region: $region"
    table_count=$(aws dynamodb list-tables --region $region --query "TableNames" --output text | wc -w)
    
    if [ "$table_count" -gt 0 ]; then
        echo "✅ Found $table_count table(s) in $region"
        aws dynamodb list-tables --region $region --output text
        echo ""
    else
        echo "❌ No tables in $region"
    fi
done