Outrageously open

Harness the power of open-source SQL.

Turbot Team
3 min. read - May 06, 2022
Harness the power of open-source SQL.

Steampipe is a groundbreaking open-source project that acts as a universal interface to APIs, allowing you to query cloud infrastructure, SaaS, logs, and more using SQL. Turbot Pipes integrates with Steampipe to provide an intuitive interface for powerful querying capabilities.

Query Across APIs with SQL

With Steampipe, you can run SQL queries across different APIs. Whether it's AWS, Azure, GCP, or even SaaS products like GitHub and Salesforce, data-fetching becomes effortless. Turbot Pipes enhances Steampipe with user-friendly cloud hosting to make Steampipe even more accessible.

Perform Security Compliance Checks

Use Turbot Pipes to ensure that your cloud resources comply with security benchmarks such as CIS, NIST, and SOC2. Run these checks smoothly, and share reports with your team.

Visualize Your Data

Turbot Pipes use Steampipe mods to visualize cloud resources with prebuilt dashboards. You can also build custom dashboards using our dashboards-as-code approach: write HCL to define dashboard widgets, and SQL to flow data into them.

Choose from a Broad Set of Plugins

Turbot Pipes inherits Steampipe's open-source and community-driven plugin ecosystem which map APIs to tables that you can query with SQL. Plugin categories include Cloud, SaaS, Security, Identity, DevOps, Networking, IaC, Logs, Social Media, and more. Popular plugins include AWS, Azure, GCP, GitHub, and Slack.

Enjoy Diverse Client Support

Query tables in your Turbot Pipes workspaces with any tool or language that can connect to Postgres. CLI tools include Steampipe's own steampipe query as well as psql and pgcli. BI tools include Apache Superset, Metabase, and Tableau. Supported languages include Go, Python, JavaScript, and any other language with a Postgres driver.

Monitor Costs and Resource Tagging

Use open-source mods to keep track of cloud expenses, verify the consistency of tags applied to resources across different cloud providers, and thereby ensure organized, cost-effective operations.

Gain Insights and Evaluate your Security Posture

The open-source mods provide dashboards that visualize cloud resources using charts, tables, and relationship graphs. They also provide benchmarks that evaluate the security posture of your cloud environment using a long list of frameworks and standards including CIS, FedRAMP, GDPR, NIST, and SOC 2.

Build Custom Plugins and Mods

Extend Steampipe's capabilities with custom plugins for your own APIs, and create derivative versions of existing benchmarks and dashboards to meet your specific needs.

Join a Thriving Community

Steampipe's vibrant community thrives on feedback and involvement. You can ask questions, contribute plugins and mods, or even join the Turbot team.

Get Started with Turbot Pipes and Steampipe

Turbot Pipes and Steampipe combine to deliver an unmatched ability to query and visualize cloud resources. Connect with us to get started with Turbot Pipes and Steampipe.