steampipe_query
Query cloud infrastructure, SaaS, APIs, and code with PostgreSQL syntax. Execute read-only SQL queries to access and analyze data efficiently. Use provided tools to explore available tables and columns before querying.
Instructions
Query cloud infrastructure, SaaS, APIs, code and more with SQL.
Queries are read-only and must use PostgreSQL syntax.
For best performance: limit columns requested, use materialized CTEs instead of joins. Trust the search path unless sure you need to specify a schema.
Check available tables and columns before querying using steampipe_table_list and steampipe_table_show.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL query to execute. Must use PostgreSQL syntax and be read-only. |