Blog and Resource Center
- Best Practice
- Case Study
- Cost Control
- Featured Plugin
- Shift Left Join
v0.14.0: Benchmark dashboards, Postgres 14, ARM64
Discover the great new features in Steampipe's open source v0.14.0 release!
Top 7 AWS cost-saving strategies
How to save big in AWS by cleaning up your underused resources, stale data, and more.
Use Steampipe to identify cost savings in AWS
An introduction to AWS Thrifty, a mod that finds underutilized AWS resources.
SQL for Google Sheets
Use the Google Sheets plugin to join spreadsheets with other tables, enforce named ranges, find secrets, and pivot with SQL.
v0.13.0: Dashboards, ltree, 6 new plugins
Discover the great new features in Steampipe's open source v0.13.0 release!
Dashboards as Code with HCL + SQL
Now you can visualize your queries, and easily build your own dashboards based on our library of examples.
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!
v0.12.0: Templates for control outputs, two new formats
Discover the great new features in Steampipe's open source v0.12.0 release!
v0.11.0: Faster startup and composable mods
Discover the great new features in Steampipe's open source v0.11.0 release!
v0.10.0: Better concurrency and caching
Discover the great new features in Steampipe's open source v0.10.0 release!
Find secrets everywhere
Use Steampipe to find secrets in all the nooks and crannies of your cloud infrastructure.
Using SQL to check spreadsheet integrity
The CSV plugin brings spreadsheet data to Steampipe. We show how to write compliance checks for that data.
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.
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.
v0.9.0: Dynamic tables & improved control outputs
Discover the great new features in Steampipe's open source v0.9.0 release!
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.
Using Steampipe's GitHub plugin to connect with your open source community
Review stale issues, visualize release cadence, and find external contributors
Adding a column to a Steampipe table
A small tweak to the GitHub plugin unlocks new capability
v0.8.0: Mod Variables, Tags & Syntax Highlighting
Discover the great new features in Steampipe's open source v0.8.0 release!
v0.7.0: AWS multi-account queries & Docker support
Learn what's new in Steampipe's open source v0.7.0 release
v0.6.0: Export and Filter Controls
Learn more about the new open source features in Steampipe v0.6.0
What's new in the CIS v1.4 benchmark for AWS
Analysis of the changes in the CIS v1.4 benchmark for AWS
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
New! Named Queries, Search Paths and Workspaces
Learn more about the v0.4.0 release of the open source Steampipe CLI.
Shift Left Join: Find all AWS EC2 instances not using IMDSv2
Join metadata across EC2 instances and IAM instance profiles.
Using Shodan to test AWS Public IPs
Shift Left Join Security: Threat hunting AWS IPs with Shodan and SQL.
New: Caching, Config and Improved Quals Handling
Learn more about the v0.3.0 release of the opensource Steampipe CLI.
Analysis of Cloud Provider Market Share – 2021
Using developer interest in infrastructure as code tools to gauge popularity of cloud providers.
New: AWS Multi-Region Queries and Query Caching
Learn more about the v0.2.0 release of the opensource Steampipe CLI.
The Hitchhiker's Guide to IAM Policy Wildcards
A quick reference to AWS IAM wildcard usage.
Steampipe ❤ Parliament
How Steampipe leveraged Parliament to make SQL queries against IAM even more powerful.
Normalizing AWS IAM Policies for Automation
Uncovering the power of SQL to analyze IAM policies via normalization of the AWS IAM policy syntax.
Top 10 Checks: IAM Credential Report
Learn how to generate and check your AWS IAM Credential Report for root accounts and users.
Monitor compliance of the AWS CIS 1.15 benchmark.
Ensure IAM users only receive permissions via groups.
Corral your untagged cloud cattle
How to quickly find cloud resources that are missing tags
Steampipe: select * from cloud;
The extensible SQL interface to your favorite cloud APIs