Use SQL to query host, DNS and exploit information using Shodan. Open source CLI. No DB required.

Shodan Plugin for Steampipe

Query Shodan with SQL

Use SQL to query host, DNS and exploit information using Shodan. For example:

select
  *
from
  shodan_host_service
where
  ip = '8.8.8.8'

Learn about Steampipe.

Get started

Table documentation and examples →

Install the plugin:

steampipe plugin install shodan

Get involved

Community

The Steampipe community can be found on GitHub Discussions, where you can ask questions, voice ideas, and share your projects.

Our Code of Conduct applies to all Steampipe community channels.

Contributing

Please see CONTRIBUTING.md.

Owner
Turbot
Get cloud work done with Turbot — Creators of https://turbot.com/v5 and https://steampipe.io
Turbot
https://github.com/turbot/steampipe-plugin-shodan
Comments
  • shodan geo search throws strange error, yields data in steampipe cli but not psql

    shodan geo search throws strange error, yields data in steampipe cli but not psql

    in steampipe cli

    select * from shodan_search where query = 'geo:-31.921836,115.95020622,10'

    Error: json: cannot unmarshal object into Go struct field Minecraft.matches.minecraft.description of type string (SQLSTATE HV000)

    but data is returned

    +--------------------------------+----------+----------------------------------------------------------------------------------+-----------------------------------> | query | asn | hostnames | isp > +--------------------------------+----------+----------------------------------------------------------------------------------+-----------------------------------> | geo:-31.921836,115.95020622,10 | AS16509 | ["server-13-32-127-92.per50.r.cloudfront.net"] | Amazon.com, Inc. > | | | | > | geo:-31.921836,115.95020622,10 | AS7545 | ["60-242-48-54.tpgi.com.au"] | TPG Telecom Limited >

    in psql

    steampipe=> select steampipe-> * steampipe-> from steampipe-> shodan_search steampipe-> where steampipe-> query = 'geo:-31.921836,115.95020622,10' steampipe-> ; ERROR: rpc error: code = Unknown desc = json: cannot unmarshal object into Go struct field Minecraft.matches.minecraft.description of type string steampipe=>

    and no data is returned

  • Update the link to the Shodan website

    Update the link to the Shodan website

    "shodan.com" doesn't belong to Shodan. The correct URL to get the API key is "https://account.shodan.io"

    Integration test logs

    Logs 
    Add passing integration test logs here

    Example query results

    Results 
    Add example SQL query results here (please include the input queries as well)
  • Update steampipe-plugin-sdk to v1.4.1. Closes #5

    Update steampipe-plugin-sdk to v1.4.1. Closes #5

    Integration test logs

    Logs 
    Add passing integration test logs here

    Example query results

    Results 
    Add example SQL query results here (please include the input queries as well)
  • Line output style broken with shodan_host_service table

    Line output style broken with shodan_host_service table

    Describe the bug The output of a query against the shodan_host_service table has extra line breaks in it

    Steampipe version (steampipe -v) v0.3.3

    Plugin version (steampipe plugin list) 0.0.1

    To reproduce select * from shodan_host_service where ip = '3.239.46.31'

    Expected behavior

    -[ RECORD 1  ]---------------------------------------------------------------------------
ip          | 3.239.46.31
ipv6        | <null>
port        | 22
timestamp   | 2021-03-24 16:12:17
hash        | 163854181
domains     | ["amazonaws.com"]

    Actual behavior

    -[ RECORD 1  ]---------------------------------------------------------------------------
ip          | 3.239.46.31






ipv6        | <null>






port        | 22






timestamp   | 2021-03-24 16:12:17







hash        | 163854181







domains     | ["amazonaws.com"]
  • Add golangci-lint and stale workflows

    Add golangci-lint and stale workflows

    Integration test logs

    Logs 
    Add passing integration test logs here

    Example query results

    Results 
    Add example SQL query results here (please include the input queries as well)
  • Recompile plugin with Go version 1.17

    Recompile plugin with Go version 1.17

    Example query results

    Results 
    select
  *
from
  shodan_api_info
+------+---------------+--------------+--------+---------------+----------+---------------+--------------------------------------------------------+--------+
| plan | query_credits | scan_credits | https  | monitored_ips | unlocked | unlocked_left | usage_limits                                           | telnet |
+------+---------------+--------------+--------+---------------+----------+---------------+--------------------------------------------------------+--------+
| oss  | <null>        | <null>       | <null> | <null>        | false    | <null>        | {"monitored_ips":0,"query_credits":0,"scan_credits":0} | false  |
+------+---------------+--------------+--------+---------------+----------+---------------+--------------------------------------------------------+--------+
  • Updated content README & Doc.

    Updated content README & Doc.

    Integration test logs

    Logs 
    Add passing integration test logs here

    Example query results

    Results 
    Add example SQL query results here (please include the input queries as well)
  • Change plugin license to Apache 2.0 per https://github.com/turbot/steampipe/issues/488

    Change plugin license to Apache 2.0 per https://github.com/turbot/steampipe/issues/488

    Integration test logs

    Logs 
    Add passing integration test logs here

    Example query results

    Results 
    Add example SQL query results here (please include the input queries as well)
Related tags
Database tools go golang postgres shodan sql postgres-fdw steampipe steampipe-community shodan-plugin
Use SQL to instantly query instances, networks, databases, and more from Scaleway. Open source CLI. No DB required.
 Use SQL to instantly query instances, networks, databases, and more from Scaleway. Open source CLI. No DB required.

Scaleway Plugin for Steampipe Use SQL to query infrastructure servers, networks, databases and more from your Scaleway project. Get started → Document

Nov 16, 2022
Use SQL to instantly query resources, data sources and more from Terraform code. Open source CLI. No DB required.
 Use SQL to instantly query resources, data sources and more from Terraform code. Open source CLI. No DB required.

Terraform Plugin for Steampipe Use SQL to query data from Terraform configuration files. Get started → Documentation: Table definitions & examples Com

Dec 22, 2022
Use SQL to instantly query Algolia indexes and configuration. Open source CLI. No DB required

Use SQL to instantly query Algolia indexes and configuration. Open source CLI. No DB required

Oct 1, 2022
Use SQL to instantly query Datadog resources across accounts. Open source CLI. No DB required.

steampipe-plugin-datadog Datadog Plugin for Steampipe Use SQL to query dashboards, users, roles and more from Datadog. Get started → Documentation: Ta

Dec 17, 2022
Use SQL to instantly query Hypothesis resources. Open source CLI. No DB required.

Hypothesis Plugin for Steampipe Prerequisites Steampipe Golang Build $ git clone https://github.com/judell/steampipe-plugin-hypothesis.git $ cd steam

Dec 11, 2022
Use SQL to data from CSV files. Open source CLI. No DB required.
 Use SQL to data from CSV files. Open source CLI. No DB required.

CSV Plugin for Steampipe Use SQL to query data from CSV files. Get started → Documentation: Table definitions & examples Community: Slack Channel Get

Nov 10, 2022
Use SQL to query information including Users, Groups, Clients, Roles and more from Keycloak.

Keycloak Plugin for Steampipe [WIP] THIS IS NOT ACTIVE NOR WORKING YET - DO NOT USE Use SQL to query information including Users, Groups, Clients, Rol

Jan 6, 2023
Use SQL to instantly query file, domain, URL and IP scanning results from VirusTotal.
 Use SQL to instantly query file, domain, URL and IP scanning results from VirusTotal.

VirusTotal Plugin for Steampipe Use SQL to query file, domain, URL and IP scanning results from VirusTotal. Get started → Documentation: Table definit

Nov 10, 2022
Use SQL to query instances, domains and more from Prometheus.
 Use SQL to query instances, domains and more from Prometheus.

Use SQL to instantly query Prometheus metrics, alerts, labels and more. Open source CLI. No DB required.

Nov 28, 2022
Use SQL to query databases, logs and more from PlanetScale

Use SQL to instantly query PlanetScale databases, branches and more. Open source CLI. No DB required.

Sep 30, 2022
This is the code example how to use SQL to query data from any relational databases in Go programming language.

Go with SQL example This is the code example how to use SQL to query data from any relational databases in Go programming language. To start, please m

Mar 12, 2022
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
 OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

OctoSQL OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases, streaming sources and file formats using

Dec 29, 2022
Query and Provision Cloud Infrastructure using an extensible SQL based grammar
 Query and Provision Cloud Infrastructure using an extensible SQL based grammar

Deploy, Manage and Query Cloud Infrastructure using SQL [Documentation] [Developer Guide] Cloud infrastructure coding using SQL InfraQL allows you to

Oct 25, 2022
Go-Postgresql-Query-Builder - A query builder for Postgresql in Go

Postgresql Query Builder for Go This query builder aims to make complex queries

Nov 17, 2022
write APIs using direct SQL queries with no hassle, let's rethink about SQL

SQLer SQL-er is a tiny portable server enables you to write APIs using SQL query to be executed when anyone hits it, also it enables you to define val

Jan 7, 2023
A Go SQL query builder and struct mapper.

godb - a Go query builder and struct mapper godb is a simple Go query builder and struct mapper, not a full-featured ORM. godb does not manage relatio

Dec 6, 2022
Query redis with SQL
 Query redis with SQL

reqlite reqlite makes it possible to query data in Redis with SQL. Queries are executed client-side with SQLite (not on the redis server). This projec

Dec 23, 2022
BQB is a lightweight and easy to use query builder that works with sqlite, mysql, mariadb, postgres, and others.

Basic Query Builder Why Simple, lightweight, and fast Supports any and all syntax by the nature of how it works Doesn't require learning special synta

Dec 7, 2022
Parses a file and associate SQL queries to a map. Useful for separating SQL from code logic

goyesql This package is based on nleof/goyesql but is not compatible with it any more. This package introduces support for arbitrary tag types and cha

Oct 20, 2021