Find Every Public EC2 Instance in 10 Minutes
"Show me all EC2 instances that are public." One question. About 10 minutes. Manually, the same answer is a 10-day job. In this clip, the CloudQuery AI assistant works it out live: it finds the EC2 instances table, reads the schema, identifies public_ip_address as the field that signals public exposure, and queries for every instance that has one. It comes back with 2 running public EC2 instances — instance type, public IP and DNS, private IP, VPC, subnet and tags for each — and flags that both are reachable from the internet, subject to security group rules.