Improved usability, telemetry, 9 new plugins →

Blog and Resource Center

Categories

  • All
  • Announcement
  • Best Practice
  • Case Study
  • Community
  • Cost Control
  • Featured Plugin
  • Partnerships
  • Reference
  • Research
  • Shift Left Join
Community

Contributor Spotlight: François de Metz

Learn how this prolific open source author built his own Steampipe plugins to access a diverse set of SaaS APIs using SQL as the common language.


Jon Udell
August 5, 2022
Partnerships

Gruntwork partners with Steampipe to deliver continuous compliance as a service

Steampipe’s openness and support for AWS CIS v1.4.0 were key factors


Steampipe and Gruntwork
July 13, 2022
Announcement

v0.15.0: Improved usability, telemetry, 9 new plugins

Discover the great new features in Steampipe's open source v0.15.0 release!


Steampipe Team
June 23, 2022
Shift Left Join

Shift Left Join: Where are those IP addresses coming from?

Enrich VPC FLow Logs with geographic locations from ipstack.


Jon Udell
May 31, 2022
Announcement

v0.14.0: Benchmark dashboards, Postgres 14, ARM64

Discover the great new features in Steampipe's open source v0.14.0 release!


Steampipe Team
May 9, 2022
Cost Control

Top 7 AWS cost-saving strategies

How to save big in AWS by cleaning up your underused resources, stale data, and more.


Bob Tordella
May 5, 2022
Cost Control

Use Steampipe to identify cost savings in AWS

An introduction to AWS Thrifty, a mod that finds underutilized AWS resources.


Jon Udell
March 31, 2022
Featured Plugin

SQL for Google Sheets

Use the Google Sheets plugin to join spreadsheets with other tables, enforce named ranges, find secrets, and pivot with SQL.


Jon Udell
March 30, 2022
Announcement

v0.13.0: Dashboards, ltree, 6 new plugins

Discover the great new features in Steampipe's open source v0.13.0 release!


Steampipe Team
March 16, 2022
Announcement

Dashboards as Code with HCL + SQL

Now you can visualize your queries, and easily build your own dashboards based on our library of examples.


Steampipe Team
March 10, 2022
Featured Plugin

SQL queries + compliance checks for Terraform files

Steampipe's Terraform plugin makes your .tf files queryable with SQL. A trio of new mods, for AWS/Azure/GCP, use the plugin to run compliance controls. Now you can check what you've defined as well as what you've deployed!


Jon Udell
February 21, 2022
Announcement

v0.12.0: Templates for control outputs, two new formats

Discover the great new features in Steampipe's open source v0.12.0 release!


Steampipe Team
January 20, 2022
Announcement

v0.11.0: Faster startup and composable mods

Discover the great new features in Steampipe's open source v0.11.0 release!


Steampipe Team
December 16, 2021
Announcement

v0.10.0: Better concurrency and caching

Discover the great new features in Steampipe's open source v0.10.0 release!


Steampipe Team
November 24, 2021
Featured Plugin

Find secrets everywhere

Use Steampipe to find secrets in all the nooks and crannies of your cloud infrastructure.


Jon Udell
November 10, 2021
Featured Plugin

Using SQL to check spreadsheet integrity

The CSV plugin brings spreadsheet data to Steampipe. We show how to write compliance checks for that data.


Jon Udell
November 3, 2021
Case Study

When not to SELECT *

Steampipe can combine results from primary and subsidiary API calls. But when you don't need the subsidiary results, don't spend the API calls to get them.


Jon Udell
October 28, 2021
Featured Plugin

A portrait of VSCode's external contributors

We build a data analysis pipeline to explore large GitHub repos. The same method will work with data from any Steampipe plugin.


Jon Udell
October 26, 2021
Announcement

v0.9.0: Dynamic tables & improved control outputs

Discover the great new features in Steampipe's open source v0.9.0 release!


Steampipe Team
October 22, 2021
Research

A deep dive into AWS Cloud Control for asset inventory

We dig into AWS Cloud Control and explore how Steampipe can use it to enhance our resource coverage.


Steamipe Team
October 7, 2021
Featured Plugin

Using Steampipe's GitHub plugin to connect with your open source community

Review stale issues, visualize release cadence, and find external contributors


Jon Udell
October 4, 2021
Case Study

Adding a column to a Steampipe table

A small tweak to the GitHub plugin unlocks new capability


Jon Udell
September 19, 2021
Announcement

v0.8.0: Mod Variables, Tags & Syntax Highlighting

Discover the great new features in Steampipe's open source v0.8.0 release!


Steampipe Team
September 9, 2021
Announcement

v0.7.0: AWS multi-account queries & Docker support

Learn what's new in Steampipe's open source v0.7.0 release


Steampipe Team
July 22, 2021
Announcement

v0.6.0: Export and Filter Controls

Learn more about the new open source features in Steampipe v0.6.0


Steampipe Team
June 17, 2021
Announcement

What's new in the CIS v1.4 benchmark for AWS

Analysis of the changes in the CIS v1.4 benchmark for AWS


David Boeke
June 11, 2021
Announcement

v0.5.0: Controls, compliance benchmarks (CIS + PCI + custom) and lots of Hub updates

Learn more about the new open source features in Steampipe v0.5.0


Steampipe Team
May 20, 2021
Announcement

New! Named Queries, Search Paths and Workspaces

Learn more about the v0.4.0 release of the open source Steampipe CLI.


Steampipe Team
April 16, 2021
Shift Left Join

Shift Left Join: Find all AWS EC2 instances not using IMDSv2

Join metadata across EC2 instances and IAM instance profiles.


David Boeke
April 9, 2021
Featured Plugin

Using Shodan to test AWS Public IPs

Shift Left Join Security: Threat hunting AWS IPs with Shodan and SQL.


David Boeke
April 4, 2021
Announcement

New: Caching, Config and Improved Quals Handling

Learn more about the v0.3.0 release of the opensource Steampipe CLI.


Steampipe Team
March 19, 2021
Research

Analysis of Cloud Provider Market Share – 2021

Using developer interest in infrastructure as code tools to gauge popularity of cloud providers.


David Boeke
March 8, 2021
Announcement

New: AWS Multi-Region Queries and Query Caching

Learn more about the v0.2.0 release of the opensource Steampipe CLI.


Steampipe Team
February 23, 2021
Reference

The Hitchhiker's Guide to IAM Policy Wildcards

A quick reference to AWS IAM wildcard usage.


David Boeke
February 17, 2021
Research

Steampipe ❤ Parliament

How Steampipe leveraged Parliament to make SQL queries against IAM even more powerful.


David Boeke
February 14, 2021
Research

Normalizing AWS IAM Policies for Automation

Uncovering the power of SQL to analyze IAM policies via normalization of the AWS IAM policy syntax.


John Smyth
February 11, 2021
Best Practice

Top 10 Checks: IAM Credential Report

Learn how to generate and check your AWS IAM Credential Report for root accounts and users.


David Boeke
February 9, 2021
Case Study

Monitor compliance of the AWS CIS 1.15 benchmark.

Ensure IAM users only receive permissions via groups.


David Boeke
January 25, 2021
Case Study

Corral your untagged cloud cattle

How to quickly find cloud resources that are missing tags


David Boeke
January 22, 2021
Announcement

Steampipe: select * from cloud;

The extensible SQL interface to your favorite cloud APIs


Steampipe Team
January 21, 2021
 

Get cloud
work done.

Get cloud
work done.