v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →
Steampipe logo 
Hub
Plugins
ip2location/ip2locationio
Overview
2Tables
Versions
GitHub
steampipe plugin install ip2location/ip2locationio

ip2location.io + Steampipe

ip2location.io is an API for IP address information (e.g. location) or WHOIS data (domain registration info).

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

Query IP geolocation:

select
  country_code,
  country_name,
  region_name,
  city_name
from
  ip2locationio_geolocation
where
  ip = '8.8.8.8';
+--------------+--------------------------+-------------+---------------+
| country_code | country_name             | region_name | city_name     |
+--------------+--------------------------+-------------+---------------+
| US           | United States of America | California  | Mountain View |
+--------------+--------------------------+-------------+---------------+

Query WHOIS data:

select
  domain,
  domain_id,
  status,
  create_date
from
  ip2locationio_whois
where
  domain = 'google.com';
+------------+-------------------------+---------------------------------------------------------------------------+----------------------+
| domain     | domain_id               | status                                                                    | create_date          |
+------------+-------------------------+---------------------------------------------------------------------------+----------------------+
| google.com | 2138514_DOMAIN_COM-VRSN | clientUpdateProhibited (https://www.icann.org/epp#clientUpdateProhibited) | 1997-09-15T07:00:00Z |
+------------+-------------------------+---------------------------------------------------------------------------+----------------------+

Documentation

Get started

Install

Download and install the latest ip2location.io plugin:

steampipe plugin install ip2location/ip2locationio

Credentials

ItemDescription
CredentialsIP2Location.io requires an API key for all requests.
PermissionsAPI keys have access to data fields based on their subscription plans.
RadiusEach connection represents a single IP2Location.io user.
Resolution1. Credentials explicitly set in a steampipe config file (~/.steampipe/config/ip2locationio.spc)
2. Credentials specified in an environment variable, e.g., IP2LOCATIONIO_API_KEY.

Configuration

Installing the latest ip2locationio plugin will create a config file (~/.steampipe/config/ip2locationio.spc) with a single connection named ip2locationio:

connection "ip2locationio" {
  plugin = "ip2location/ip2locationio"


  # API key for requests. Required.
  # Sign up for a free key at https://www.ip2location.io/pricing
  # This can also be set via the `IP2LOCATIONIO_API_KEY` environment variable.
  # api_key = "Q5Z8QS544RKC2VK4P3ZH7YW3C16MDCBW"
}
  • api_key - Required API key from ip2location.io.

Alternatively, you can also use the standard ip2location.io environment variable to obtain credentials only if other argument (api_key) is not specified in the connection:

export IP2LOCATIONIO_API_KEY=Q5Z8QS544RKC2VK4P3ZH7YW3C16MDCBW

Get involved