Table: shodan_api_info - Query Shodan API Information using SQL

Shodan is a search engine that lets users find specific types of computers (webcams, routers, servers, etc.) connected to the internet using a variety of filters. The Shodan API provides a method for accessing Shodan's raw data in order to integrate it into other applications. It allows users to explore the internet in real-time and provides a way to determine the geographical location of hosts, discover given services, or identify certain devices.

Table Usage Guide

The shodan_api_info table provides insights into the Shodan API's plan, usage, and capabilities. As a security analyst, explore API-specific details through this table, including the plan's tier, the number of query credits available, and the scan credits remaining. Utilize it to monitor your usage of the Shodan API and to ensure it aligns with the capabilities of your current plan.

Examples

Get API status

Analyze the status of your APIs to ensure they're functioning as expected and to identify any potential issues that may need addressing. This can be crucial in maintaining smooth and efficient operations within your digital infrastructure.

select
  *
from
  shodan_api_info;

select
  *
from
  shodan_api_info;

Schema for shodan_api_info

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
https	boolean	HTTPS support.
monitored_ips	bigint	Monitored IPs.
plan	text	Plan for the API key.
query_credits	bigint	Query credits.
scan_credits	bigint	Scan credits.
telnet	boolean	Telnet support.
unlocked	boolean	Unlocked.
unlocked_left	bigint	Unlocked left.
usage_limits	jsonb	Usage limits.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- shodan

You can pass the configuration to the command with the --config argument:

steampipe_export_shodan --config '<your_config>' shodan_api_info