广告合作
MCP.so
登录

Steampipe MCP Server

@turbot

代码仓库

基本信息

分类

其他

许可证

Apache-2.0

传输方式

stdio

作者

turbot

关于 Steampipe MCP Server

Enable AI assistants to explore and query your Steampipe data!

#ai#mcp#steampipe#turbot-pipes#mcp-server

Steampipe MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "steampipe": {
      "command": "npx",
      "args": [
        "-y",
        "@turbot/steampipe-mcp"
      ]
    }
  }
}

Steampipe MCP Server 工具

5

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.

List all available Steampipe tables. Use schema and filter parameters to narrow down results.

Get detailed information about a specific Steampipe table, including column definitions, data types, and descriptions.

List all Steampipe plugins installed on the system. Plugins provide access to different data sources like AWS, GCP, or Azure.

Get details for a specific Steampipe plugin installation, including version, memory limits, and configuration.

概览

What is Steampipe MCP Server?

The Steampipe MCP Server connects AI assistants like Claude to your cloud infrastructure data via Steampipe, enabling natural language exploration and analysis across AWS, Azure, GCP, and 100+ cloud services. It provides read‑only access to cloud and SaaS data for security, compliance, cost, and resource analysis.

How to use Steampipe MCP Server?

Install Node.js v16 or higher and have Steampipe running locally (steampipe service start) or a Turbot Pipes workspace. Add the server configuration to your AI assistant’s MCP config file (e.g., claude_desktop_config.json for Claude Desktop, ~/.cursor/mcp.json for Cursor). After restarting the assistant, run the best_practices prompt to teach the LLM how to work with Steampipe, then ask natural‑language questions about your infrastructure.

Key features of Steampipe MCP Server

  • Query cloud and security logs using SQL (PostgreSQL syntax).
  • List, filter, and inspect available Steampipe tables.
  • List and show details of installed Steampipe plugins.
  • Connect to local Steampipe or Turbot Pipes workspaces.
  • Provides a best_practices prompt to optimize LLM responses.
  • Exposes a status resource to verify connection state.

Use cases of Steampipe MCP Server

  • Explore cloud accounts and resources with natural language (e.g., “What AWS accounts can you see?”).
  • Generate infrastructure reports (e.g., “List EC2 instances with attached EBS volumes”).
  • Perform security analysis (e.g., “Find IAM users with unrotated access keys”).
  • Get compliance insights (e.g., “Show EC2 instances not complying with tagging standards”).
  • Analyze risks (e.g., “Check S3 buckets for public access and encryption”).

常见问题

1

What prerequisites are needed?

Node.js v16 or higher is required. For local use, Steampipe must be installed and running (`steampipe service start`). For cloud use, a Turbot Pipes workspace and connection string are needed.

2

How do I connect to Turbot Pipes instead of local Steampipe?

Add your Turbot Pipes connection string as an additional argument in the MCP configuration’s `args` array (e.g., `"postgresql://my_name:my_pw@workspace-name.usea1.db.pipes.turbot.com:9193/abc123"`).

3

What tools does the server provide?

The server provides five tools: `steampipe_query` (run SQL), `steampipe_table_list` (list tables), `steampipe_table_show` (details of a table), `steampipe_plugin_list` (list installed plugins), and `steampipe_plugin_show` (details of a plugin).

4

Are queries read‑only?

Yes, all queries are read‑only and use PostgreSQL syntax.

5

Is there a prompt to teach the LLM how to use Steampipe?

Yes, the `best_practices` prompt provides detailed guidance on SQL style, CTEs, optimization, and error handling. Run it first for best results.

评论

其他 分类下的更多 MCP 服务器

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

ICSS

chokcoco

不止于 CSS

20.7K
广告合作