Steampipe Reviews and Details

Is Steampipe good?

Social recommendations and mentions

• Build API integrations with SQL and YAML – no SaaS lock-in, no drag-and-drop UIs

  The request / data fetching is interesting in how "easy" it is to write. I did basic perusal of the examples, but I'd be interested to see what it looks like with rate-limited endpoints and concurrent requests. Another tangentially related project is https://steampipe.io/ though it is for exposing APIs via Postgres tables and the clients are written using Go code and shared through a marketplace. - Source: Hacker News / 26 days ago

• Cyphernetes: A Query Language for Kubernetes

  I really really like Steampipe to do this kind of query: https://steampipe.io, which is essentially PostgreSQL (literally) to query many different kind of APIs, which means you have access to all PostgreSQL's SQL language can offer to request data. They have a Kubernetes plugin at https://hub.steampipe.io/plugins/turbot/kubernetes and there are a couple of things I really like: * it's super easy to request... - Source: Hacker News / 6 months ago

• DuckDB Doesn't Need Data to Be a Database

  Https://steampipe.io/ showcases some really interesting scenarios for using FDWs in place of regular ETL and API integrations. - Source: Hacker News / about 1 year ago

• Cloud Tools You Probably Haven't Heard Of

  Steampipe is a tool for querying cloud APIs and other data sources using SQL in a zero-ETL manner. - Source: dev.to / about 1 year ago

• Osquery: An sqlite3 virtual table exposing operating system data to SQL

  Few projects in the same realm that you should also checkout - [1] Steampipe (https://steampipe.io/) [2] InfraSQL (https://iasql.com/). - Source: Hacker News / over 1 year ago

• How to run an AWS CIS v3.0 assessment in CloudShell

  In a prior post I showed how to install Steampipe in AWS CloudShell to instantly query over 460+ resource types from your AWS APIs using SQL, and another post on how to use the Steampipe AWS Compliance mod to assess over 25+ security benchmarks across your AWS accounts. - Source: dev.to / over 1 year ago

• Git Query Language

  This seems similar to this[1] Steampipe[2] plugin. [1] https://github.com/turbot/steampipe-plugin-github. - Source: Hacker News / over 1 year ago

• Zero-ETL for Postgres: Live-query cloud APIs with 100 open source FDWs

  Steampipe [1] is an open source project [2] that includes an embedded Postgres to instantly query cloud, code & more with SQL. This release expands our plugin ecosystem [3] to be a full Zero-ETL platform. Steampipe plugins can now run natively in your own Postgres as Foreign Data Wrappers [4], as SQLite extensions [5] or as simple data export tools [6]. Please give it a try, we'd love your feedback and... - Source: Hacker News / over 1 year ago

• Select * from shell; Use SQL to exec commands across hosts

  Use SQL to run shell commands against any host - local or remote, Linux or Windows, through proxies & bastions. Aggregates results from multiple hosts. Steampipe - https://steampipe.io exec plugin - https://hub.steampipe.io/plugins/turbot/exec It's a Postgres FDW - https://www.postgresql.org/docs/14/ddl-foreign-data.html Uses Terraform provisioner code -... - Source: Hacker News / over 1 year ago

• Cloudquery, Resoto, Steampipe, or Airbyte?

  I'm a lead on the Steampipe project, so just wanted to share a vote for that :-). It's backed by Turbot, we've been a key player in the cloud security space since 2014. Source: about 2 years ago

• Open source alternative cloud security tool that works like Wiz/Lacework/Aqua

  Yes! There are open source cloud security tools! Here are some open source tools out there: steampipe, prowler, cloudquery, and ZeusCloud. Source: over 2 years ago

• DuckDB: Querying JSON files as if they were tables

  This is really cool! With their Postgres scanner[0] you can now easily query multiple datasources using SQL and join between them (i.e. Postgres table with JSON file). Something I strived to build with OctoSQL[1] before. It's amazing to see how quickly DuckDB is adding new features. Not a huge fan of C++, which is right now used for authoring extensions, it'd be really cool if somebody implemented a Rust extension... - Source: Hacker News / over 2 years ago

• Use SQL to query Namecheap domains and domain host records (new open source tool)

  Steampipe.io is an open-source CLI that lets you query cloud APIs using SQL. We've just released a new plugin for Namecheap that allows you to query your domains and and domain host records for security posture and operational best practices. Source: over 2 years ago

• Ask r/kubernetes: What are you working on this week?

  I help lead an open source project, Steampipe.io (CLI to query cloud, containers & more with SQL). Source: over 2 years ago

• Stay Ahead of Cyber Threats with Graph Databases

  Graph DB == connect the dots. Relational DB == join the dots. :-) Steampipe [1] is an open source project [2] to live query all your cloud resources with SQL (via Postgres FDWs). It includes a dashboards as code layer written in HCL + SQL. We recently added support for relationship graphs & visualizations with hundreds of open source dashboards focused on cybersecurity [3]. In our experience, the hard part of... - Source: Hacker News / over 2 years ago

• How many people in my Mastodon feed also tweeted today?

  Nice tutorial and an excellent example of using Steampipe to query two apis simultaneously. Source: over 2 years ago

• Mapping your AWS attack surface

  An Organization must monitor and understand the network perimeter of their cloud estate. Resources comprising the externally facing network components of your cloud attack surface can be broadly grouped into IP addresses, hostnames, and URLs. In this blog post, we will provide step-by-step instructions for mapping the network aspects of the cloud attack surface using Steampipe. - Source: dev.to / over 2 years ago

• Steampipe vs aws security hub

  Steampipe and AWS Security Hub serve different purposes, can also be used to work together:. Source: over 2 years ago

• Ask HN: Programs that saved you 100 hours? (2022 edition)

  Excited to see Steampipe shared here - thanks zJayv! I'm a lead on the project, so sharing some quick info below and happy to answer any questions. Steampipe [1] is open source and uses Postgres foreign data wrappers under the hood [2]. We have 90+ plugins to SQL query AWS, GitHub, Slack, Kubernetes, etc [3]. Mods (written in HCL) provide dashboards as code and automated security & compliance benchmarks [3]. We'd... - Source: Hacker News / over 2 years ago

• Supabase Wrappers: A Framework for Building Postgres Foreign Data Wrappers

  Our release today is a framework which extends this functionality to other databases/systems. If you’re familiar with Multicorn[1] or Steampipe[2], then it’s very similar. The framework is written in Rust, using the excellent pgx[3]. We have developed FDWs for Stripe, Firebase, BigQuery, Clickhouse, and Airtable (all in various “pre-release” states). The plan is to focus on the tools we’re using internally while... - Source: Hacker News / over 2 years ago

• Show HN: GitHub Org Audit Tool

  Thanks atonse for the shout out! Steampipe [1] is an open source CLI to query your cloud resources (e.g. GitHub, AWS, Splunk, etc) with SQL. The GitHub plugin has 44 tables to query [2]. The "GitHub Sherlock" mod includes 34 automated controls for organization, repo and issue best practices. The "GitHub Compliance" mod has 35 automated controls for supply chain security. Mods are written in HCL + SQL. [3] 1 -... - Source: Hacker News / over 2 years ago