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. If you don't have one, sign up a Free IP2Location.io API key now. 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.

Discover the World with IP Geolocation

Supercharge your business with Geolocation data.