Integrating IP2Location.io with Steampipe

Steampipe enables querying of cloud APIs using just SQL queries. IP2Location.io Steampipe plugin enables users to query IP geolocation data as well as WHOIS data.

All you have to do is install Steampipe then install the IP2Location.io Steampipe plugin with the below command:

steampipe plugin install ip2location/ip2locationio

NOTE: You will need an API key so sign up for one at the pricing page if you don't have one. Then follow the instructions in the documentation page below to configure the API key.

IP Geolocation Data

You can then query IP geolocation data using SQL like below:

select
  country_code,
  country_name,
  region_name,
  city_name
from
  ip2locationio_geolocation
where
  ip = '8.8.8.8';

You will see:

+--------------+--------------------------+-------------+---------------+
| country_code | country_name             | region_name | city_name     |
+--------------+--------------------------+-------------+---------------+
| US           | United States of America | California  | Mountain View |
+--------------+--------------------------+-------------+---------------+

WHOIS Data

You can also query WHOIS data using SQL like below:

select
  domain,
  domain_id,
  status,
  create_date
from
  ip2locationio_whois
where
  domain = 'google.com';

You will see:

+------------+-------------------------+---------------------------------------------------------------------------+----------------------+
| domain     | domain_id               | status                                                                    | create_date          |
+------------+-------------------------+---------------------------------------------------------------------------+----------------------+
| google.com | 2138514_DOMAIN_COM-VRSN | clientUpdateProhibited (https://www.icann.org/epp#clientUpdateProhibited) | 1997-09-15T07:00:00Z |
+------------+-------------------------+---------------------------------------------------------------------------+----------------------+

For more information, please refer the IP2Location.io Steampipe documentation.