What is Steampipe?

→ Query cloud APIs.
→ Visualize queries on dashboards.
→ Run compliance controls and benchmarks.
→ Blazing fast multi-threaded Golang CLI.
→ Connect anything to the embedded PostgreSQL.

{` select region, instance_state as state, instance_type as type from aws_ec2_instance; `} {`+-----------+---------+-----------+ | region | state | type | +-----------+---------+-----------+ | eu-west-1 | running | t3.medium | | eu-west-2 | running | m5a.large | | us-east-1 | running | t3.large | +-----------+---------+-----------+ `}

## tl;dr ** → ** **[Steampipe Dashboards](#steampipe-dashboards)**.
** → ** **[Postgres ltree extension](#postgres-ltree-extension)**.
** → ** **[6 new plugins](#new-plugins)**.
** → ** Even more goodies in the [full release notes](https://github.com/turbot/steampipe/blob/main/CHANGELOG.md#v0130-2022-03-10). ## Steampipe Dashboards We were so excited about this huge new v0.13 capability that we wrote about it separately in [Dashboards as Code with HCL + SQL](https://steampipe.io/blog/dashboards-as-code). Building dashboards the Steampipe way is a delightful and wildly productive experience for four main reasons: - Live data from APIs, not a data warehouse - Live editing, see changes as you type - Everything is made with code, HCL + SQL, versioned and shareable on GitHub - Huge library of working queries and dashboards to use, study, and remix Check out [that post](https://steampipe.io/blog/dashboards-as-code) for details and screencasts, then join the early adopters like [Pete Wilcock](https://twitter.com/WilcockPete) who are already putting Steampipe Dashboards to use.

Here's how easy it is to get started with one of the new Insights mods, [AWS Insights](https://hub.steampipe.io/mods/turbot/aws_insights).

Clone the mod, start Steampipe Dashboards, and explore the [79 dashboards](https://hub.steampipe.io/mods/turbot/aws_insights/dashboards) we've initially provided. And if you feel an itch you want to scratch, using data from any of the [67 plugins](https://hub.steampipe.io/plugins) now available, check out the [tutorial](https://steampipe.io/docs/mods/writing-dashboards) on building your own dashboards. It's easy, it's fun, and you'll accomplish more, faster, than you would have thought possible. ## Postgres ltree extension [ltree](https://www.postgresql.org/docs/current/ltree.html), a Postgres extension for querying hierarchies represented as dot-delimited label paths, is now enabled in v0.13. Columns of type `ltree` can be queried using a regular-expression-like syntax that matches subpaths, and they can be indexed to speed up matching in large hierarchies. Note: In v0.11 we enabled another Postgres extension, [tablefunc](https://www.postgresql.org/docs/current/tablefunc.html). It provides a family of `crosstab` functions that you can use make pivot tables the Steampipe way: as code. ## New plugins and mods Since our last release, we've added 6 new plugins:

Algolia - query index, log, search, search_metadata
Config - query INI, JSON, and YML files
IMAP - query mailboxes and messages
LDAP - query group, organizational_unit, user
PlanetScale - query audit_log, backup, certificate, database, etc
Salesforce - query account, asset, contact, lead, product, etc, plus custom objects

We've also added five new mods: our first two Insights mods based on Steampipe Dashboards, plus a trio of mods that [check your Terraform-defined infrastructure](https://steampipe.io/blog/sql-queries-and-compliance-checks-for-terraform-files). - [AWS Insights](https://github.com/turbot/steampipe-mod-aws-insights) - Insights - [OCI Insights](https://github.com/turbot/steampipe-mod-oci-insights) - Insights - [Terraform AWS Compliance](https://hub.steampipe.io/mods/turbot/terraform_aws_compliance) - Compliance - [Terraform Azure Compliance](https://hub.steampipe.io/mods/turbot/terraform_azure_compliance) - Compliance - [Terraform GCP Compliance](https://hub.steampipe.io/mods/turbot/terraform_gcp_compliance) - Compliance

We are always improving the suites of plugins and mods. During this cycle we added tables to AWS, OCI, and Turbot.

## Let’s get building! Steampipe delivers tools to build, execute, and visualize and share cloud configuration, compliance, and security frameworks using HCL + SQL and a little elbow grease. To support those tools, it maps a growing suite of APIs to tables that you can query, and join across, in Postgres. Do you want to help us expand the open source documentation and control coverage for CIS, PCI, HIPAA, and NIST? Add tables to existing plugins? Create plugins to bring new APIs into the mix? Create dashboards to visualize those APIs? The best way to get started is to [join our Slack workspace](https://steampipe.io/community/join) and raise your hand. We would love to talk to you! For even more good stuff in v0.13.0, check out the [full release notes on GitHub](https://github.com/turbot/steampipe/blob/main/CHANGELOG.md#v0130-2022-03-10).

v0.13.0: Dashboards, ltree, 6 new plugins