# v0.13.0: Dashboards, ltree, 6 new plugins

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

By Steampipe Team
Published: 2022-03-16


<div className="row mb-5 mt-1">
  <div className="col col-12 col-lg-6">
    <h2>What is Steampipe?</h2>
    &rarr; Query <strong>cloud APIs</strong>.
    <br/>
    &rarr; Visualize queries on <strong>dashboards</strong>.
    <br/>
    &rarr; Run <strong>compliance controls and benchmarks</strong>.
    <br/>
    &rarr; Blazing fast <strong>multi-threaded Golang CLI</strong>.
    <br/> 
    &rarr; Connect anything to the <strong>embedded PostgreSQL</strong>.
  </div>
  <div className="col col-12 col-lg-1"></div>
  <div className="col col-12 col-lg-5 mt-5">
    <Terminal title="steampipe cli">
      <TerminalCommand enableCopyToClipboard={false}>
        {`
select
  region,
  instance_state as state,
  instance_type as type
from
  aws_ec2_instance;
        `}
      </TerminalCommand>
      <TerminalResult>
        {`+-----------+---------+-----------+
| region    | state   | type      |
+-----------+---------+-----------+
| eu-west-1 | running | t3.medium |
| eu-west-2 | running | m5a.large |
| us-east-1 | running | t3.large  |
+-----------+---------+-----------+
        `}
      </TerminalResult>
    </Terminal>
  </div>
</div>

## tl;dr

** &rarr; ** **[Steampipe Dashboards](#steampipe-dashboards)**.<br />
** &rarr; ** **[Postgres ltree extension](#postgres-ltree-extension)**.<br />
** &rarr; ** **[6 new plugins](#new-plugins)**. <br /> 
** &rarr; ** 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.

<div style={{"borderWidth":"thin", "borderStyle":"solid", "borderColor":"lightgray", "padding":"20px", "width":"70%"}}>
  <a href="https://twitter.com/WilcockPete/status/1502335594206310404">
    <img src="/images/blog/2022-03-release-0-13-0/pete-wilcock-tweet.png" />
  </a>
</div>
<br/>

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

<video controls loop style={{"borderWidth":"thin", "borderStyle":"solid", "width":"100%",  "borderColor":"lightgray"}}>
  <source src="/images/blog/2022-03-release-0-13-0/aws-insights-getting-started.mp4" />
</video>

<br/>

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:

<ul><li><a href="https://hub.steampipe.io/plugins/turbot/algolia">Algolia</a> - query index, log, search, search_metadata</li><li><a href="https://hub.steampipe.io/plugins/turbot/config">Config</a> - query INI, JSON, and YML files</li><li><a href="https://hub.steampipe.io/plugins/turbot/imap">IMAP</a> - query mailboxes and messages</li><li><a href="https://hub.steampipe.io/plugins/turbot/ldap">LDAP</a> - query group, organizational_unit, user</li><li><a href="https://hub.steampipe.io/plugins/turbot/planetscale">PlanetScale</a> - query audit_log, backup, certificate, database, etc</li><li><a href="https://hub.steampipe.io/plugins/turbot/salesforce">Salesforce</a> - query account, asset, contact, lead, product, etc, plus custom objects</li></ul>

 We've also added five new mods: our first two <i>Insights</i> 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

<p>We are always improving the suites of plugins and mods. During this cycle we added tables to <a href="https://hub.steampipe.io/plugins/turbot/aws">AWS</a>, <a href="https://hub.steampipe.io/plugins/turbot/oci">OCI</a>, and <a href="https://hub.steampipe.io/plugins/turbot/turbot">Turbot</a>. </p>

## 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).