steampipe_query
Query cloud infrastructure, SaaS, APIs, and code using SQL with PostgreSQL syntax. Execute read-only queries, optimize performance with materialized CTEs, and explore available tables and columns beforehand.
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. |
Input Schema (JSON Schema)
You must be authenticated.
Other Tools from steampipe-mcp
Related Tools
- @wirdes/db-mcp-tool
- @antonorlov/mcp-postgres-server
- @crystaldba/postgres-mcp
- @modelcontextprotocol/postgresql
- @antonorlov/mcp-postgres-server