Skip to main content
Glama

steampipe-mcp

by turbot

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

NameRequiredDescriptionDefault
sqlYesThe SQL query to execute. Must use PostgreSQL syntax and be read-only.

Input Schema (JSON Schema)

{ "additionalProperties": false, "properties": { "sql": { "description": "The SQL query to execute. Must use PostgreSQL syntax and be read-only.", "type": "string" } }, "required": [ "sql" ], "type": "object" }

You must be authenticated.

Other Tools from steampipe-mcp

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/turbot/steampipe-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server