turbot/steampipe-mcp
If you are the rightful owner of steampipe-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Steampipe Model Context Protocol (MCP) Server connects AI assistants to cloud infrastructure data for natural language exploration and analysis.
Tools
Functions exposed to the LLM to take actions
steampipe_query
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.
steampipe_table_list
List all available Steampipe tables. Use schema and filter parameters to narrow down results.
steampipe_table_show
Get detailed information about a specific Steampipe table, including column definitions, data types, and descriptions.
steampipe_plugin_list
List all Steampipe plugins installed on the system. Plugins provide access to different data sources like AWS, GCP, or Azure.
steampipe_plugin_show
Get details for a specific Steampipe plugin installation, including version, memory limits, and configuration.
Prompts
Interactive templates invoked by user choice
best_practices
Best practices for writing Steampipe SQL queries
Resources
Contextual data attached and managed by the client
status
URI: steampipe://status
MIME: null
Get the current status of the Steampipe connection
