ipstack + Steampipe
ipstack provides IP to geolocation APIs and global IP database services.
Steampipe is an open source CLI to instantly query cloud APIs using SQL.
For example:
select ip, country_code, region_name, latitudefrom ipstack_ipwhere ip = '99.84.45.75';
+-------------+--------------+-------------+--------------------+| ip | country_code | region_name | latitude |+-------------+--------------+-------------+--------------------+| 99.84.45.75 | US | New Jersey | 40.738731384277344 |+-------------+--------------+-------------+--------------------+
Documentation
Get started
Install
Download and install the latest ipstack plugin:
steampipe plugin install ipstack
Credentials
ipstack requires an API token for all requests, but offers a free tier. Sign up on the ipstack website to get your free token. It looks like e0067f483763d6132d549234f8a6de22
.
Configuration
Connection configurations are defined using HCL in one or more Steampipe config files. Steampipe will load ALL configuration files from ~/.steampipe/config
that have a .spc
extension. A config file may contain multiple connections.
Installing the latest ipstack plugin will create a default connection named ipstack
in the ~/.steampipe/config/ipstack.spc
file. You must edit this connection to include your API token:
connection "ipstack" { plugin = "ipstack" token = "e0067f483763d6132d934864f8a6de22"}
ipstack restricts HTTPS access and security data to subscribers. To enable:
connection "ipstack" { plugin = "ipstack" token = "e0067f483763d6132d934864f8a6de22" https = true security = true}
Get involved
- Open source: https://github.com/turbot/steampipe-plugin-ipstack
- Community: Slack Channel