steampipe

Use SQL to instantly query your cloud services (AWS, Azure, GCP and more). Open source CLI. No DB required. (by turbot)

Steampipe Alternatives

Similar projects and alternatives to steampipe

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better steampipe alternative or higher similarity.

Suggest an alternative to steampipe

Reviews and mentions

Posts with mentions or reviews of steampipe. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-11-17.
  • Ephemeral Postgres Databases
    6 projects | news.ycombinator.com | 17 Nov 2021
    Steampipe [1] is an open source CLI to query cloud APIs (e.g. AWS, GitHub, Kubernetes) with SQL. It uses an embedded Postgres instance internally and is built with Foreign Data Wrappers.

    We install and leverage the Zonky Embedded Postgres Binaries [2] which are normally used for test suites. They have been great for us.

    It's amazing how fast and light Postgres runs for these use cases!

    1 - https://steampipe.io

  • Use SQL to instantly query Twilio resources (open source, no DB required)
    2 projects | reddit.com/r/twilio | 28 Oct 2021
    Steampipe is an open source CLI to instantly query cloud APIs (AWS, GitHub, etc) using SQL. Today we released a new plugin for Twilio! It's great to query your environment for account data, calls, security, operations, etc. For example:
  • New open source project to query AirTable with SQL
    2 projects | reddit.com/r/Airtable | 26 Oct 2021
    Steampipe is an open source project to query cloud APIs (AWS, GitHub, Slack, etc) with SQL. This week one of our community members, Francois, released a new plugin to query AirTable!
  • Check compliance of a specific policy across multiple subscriptions?
    1 project | reddit.com/r/AZURE | 13 Oct 2021
    I lead development of an open source tool called Steampipe. It allows you to:
  • Open source automated NIST SP 800-53 r5 benchmark for Azure (150+ controls!)
    2 projects | reddit.com/r/NISTControls | 13 Oct 2021
    Steampipe and it's mods are different, and we believe worth considering, because:
    4 projects | reddit.com/r/netsec | 13 Oct 2021
    I'm the founder of Turbot and leading our work on Steampipe (open source). We've been a leader in the cloud security market since 2014. Happy to answer any questions you may have. (Does that help make it legit? )
    4 projects | reddit.com/r/netsec | 13 Oct 2021
    Steampipe is an open source CLI that allows you to query cloud resources (Azure, AWS, GitHub, etc) using SQL. For example, from the Azure plugin:
  • Use SQL to query IBM Cloud resources (open source)
    2 projects | reddit.com/r/ibmcloud | 6 Oct 2021
    Steampipe (https://steampipe.io) is an open source CLI to query cloud APIs using SQL. Today we released a new plugin for IBM Cloud! It's great to query your environment for security, operations, etc. For example:
  • What should I learn, database or cloud?
    1 project | reddit.com/r/SQL | 23 Sep 2021
    Check out Steampipe (https://steampipe.io). It's an open source project to query your cloud resources (e.g. AWS, GitHub, GCP, etc) with SQL. Best of both!?!
  • Query DigitalOcean Config with SQL
    1 project | reddit.com/r/sre | 17 Sep 2021
    Looks nice. Reminds me of: https://steampipe.io/
  • Cloud Infrastructure as SQL
    10 projects | news.ycombinator.com | 16 Sep 2021
    I mentioned Steampipe [1] above, it has an open source OCI plugin [1] to query resources (no support for write operations). It's a Postgres FDW under the hood, and uses subset of Postgres types (bool, bigint, double, text, inet, cidr, timestamptz and jsonb) along with their standard operators. This approach has proven very simple and effective for us.

    1 - https://steampipe.io

    10 projects | news.ycombinator.com | 16 Sep 2021
    Interesting how it implemented under-the-hood. Does it use cloudquery (https://github.com/cloudquery/cloudquery) or steampipe (https://github.com/turbot/steampipe) under-the-hood or does it implement everything from scratch.

    Disclaimer: Im the founder of CloudQuery.

    I get why you would want to do select * from infra, but not sure I understand why you would want to do "insert * into infra" and not use something like terraform? interested in hearing the use-case.

    10 projects | news.ycombinator.com | 16 Sep 2021
    Steampipe (https://steampipe.io) is an open source CLI to query cloud infrastructure using SQL (e.g. AWS, GitHub, Slack, k8s, etc). It also has a HCL language to define security benchmarks and controls (e.g. AWS CIS, etc).

    We are a Postgres FDW under the hood with Go-based plugins, so write would be possible, but we've chosen to focus on read only so far. Definitely interested to see how you approach create, update and delete in the SQL model!

    Notes: Not related to iasql. I'm a lead on the Steampipe project.

    10 projects | news.ycombinator.com | 16 Sep 2021
  • Understanding Foreign Data Wrappers in Postgres and Postgres_fdw
    3 projects | news.ycombinator.com | 18 Aug 2021
    If you are interested in Postgres FDWs, please check out Steampipe (https://steampipe.io). It's an open source project with a Go-based plugin model (similar to Terraform) to instantly query cloud services (AWS, GCP, GitHub, Slack, etc) using SQL. TBH, we've been completely shocked how far we can push this model querying real-time against APIs.

    We're bullish on the ELT use case and think of virtual tables as "Data Rainbows" - structured, ephemeral access to cloud data. I spoke about this concept for YOW Data (https://youtu.be/2BNzIU5SFaw?t=183). Still structuring our thoughts here, so feedback and ideas would be greatly appreciated.

    Disclaimers: Steampipe is open source. I'm a lead on the project. I can't stand listening to my own talk.

Stats

Basic steampipe repo stats
37
946
9.7
2 days ago

turbot/steampipe is an open source project licensed under GNU Affero General Public License v3.0 which is an OSI approved license.

SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
Find remote Go jobs at our new job board 99remotejobs.com. There are 7 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.