ipinfo.io + Steampipe

select
  ip,
  city,
  country_name
from
  ipinfo_ip;

+---------+---------+---------------+
| ip      | city    | country_name  |
+---------+---------+---------------+
| 1.2.3.4 | Chicago | United States |
+---------+---------+---------------+

select
  ip,
  city,
  country_name
from
  ipinfo_ip
where
  ip = '8.8.8.8';

+---------+---------------+---------------+
| ip      | city          | country_name  |
+---------+---------------+---------------+
| 8.8.8.8 | Mountain View | United States |
+---------+---------------+---------------+

steampipe plugin install ipinfo

connection "ipinfo" {
  plugin = "ipinfo"

  # Optional: Set your access token
  # No token is needed for basic info requests. For
  # higher limits and more data a token is required.
  # token = "4692efda8b2b56"
}