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	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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