Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| STEAMPIPE_MCP_LOG_LEVEL | No | Control server logging verbosity | info |
| STEAMPIPE_MCP_WORKSPACE_DATABASE | No | Override the default Steampipe connection string | postgresql://steampipe@localhost:9193/steampipe |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| best_practices | Best practices for writing Steampipe SQL queries |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| status | Get the current status of the Steampipe connection |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| 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. |