广告合作
MCP.so
登录

Steampipe MCP Server

@zen4ever

代码仓库

基本信息

分类

云与基础设施

许可证

MIT

传输方式

stdio

作者

zen4ever

关于 Steampipe MCP Server

An MCP server that allows Claude to query Steampipe PostgreSQL databases directly. Connect Claude to your Steampipe instance to easily analyze data from AWS, GCP, and other cloud providers through natural language.

Steampipe MCP Server 配置

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

{
  "mcpServers": {
    "steampipe-mcp-server": {
      "command": "uv",
      "args": [
        "venv"
      ]
    }
  }
}

Steampipe MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Steampipe MCP Server?

Steampipe MCP Server lets AI assistants run read-only SQL queries and explore schemas of a PostgreSQL database, primarily designed to work with Steampipe’s multi-cloud connection schemas. It is for users who want to query infrastructure data from AWS, GCP, and other clouds through natural‑language prompts in Claude Desktop or other MCP clients.

How to use Steampipe MCP Server?

First, install Steampipe and start the service to obtain the database URL. Then run the server via steampipe-mcp-server --database-url postgresql://... or configure the STEAMPIPE_MCP_DATABASE_URL environment variable. To use with Claude Desktop, add a steampipe entry in the MCP server configuration pointing to uvx steampipe-mcp-server with the URL.

Key features of Steampipe MCP Server

  • Runs read‑only SQL queries via the query tool
  • Lists all tables in the search path (list_all_tables)
  • Lists tables within a specific schema (list_tables_in_schema)
  • Retrieves column names and types for a table (get_table_schema)
  • Connects to any PostgreSQL database, optimized for Steampipe

Use cases of Steampipe MCP Server

  • Querying cloud resource inventories (EC2 instances, GCP buckets) using natural language
  • Exploring available tables and schemas without manual SQL dives
  • Running ad‑hoc read‑only queries from an AI assistant in Claude Desktop
  • Rapidly prototyping infrastructure reporting across multiple Steampipe connections

常见问题

1

What is the recommended way to prompt Claude when using Steampipe MCP Server?

Specify the schema (e.g., `aws_all`) so Claude limits table discovery to that schema, avoiding excessive results from large cloud‑provider table sets.

2

What are the prerequisites for using the server?

You need a running Steampipe PostgreSQL service (started via `steampipe service start`) and its database URL. The URL must use the `postgresql://` protocol.

3

How do I configure the database connection?

Pass the database URL with the `--database-url` argument or set the `STEAMPIPE_MCP_DATABASE_URL` environment variable in a `.env` file; the server loads it automatically.

4

What tools does the server provide?

Four tools: `query` (read‑only SQL), `list_all_tables`, `list_tables_in_schema`, and `get_table_schema`.

5

Is the server read‑only?

Yes – the `query` tool only permits read‑only SQL operations; write operations are not supported.

评论

云与基础设施 分类下的更多 MCP 服务器

Kilo IoT Platform

Kilo IoT

Your AI can finally reach the physical world. Kilo is an AI-first IoT platform for commercial and industrial operations, and this connector hands a live deployment to the AI client you already use. Not an export. Not a

L

Lium - GPU cloud

Lium

Find, price and rent GPUs on Lium from Claude, ChatGPT, Codex or any MCP client. Search live GPU availability and prices (H100, H200, B200, RTX 4090 and more), estimate provider earnings, and with Sign in with Lium or a

monadomain-mcp

themonagroup

Buy .vn and 371 international domains in VND inside Claude Code, Codex or Cursor. Search and reserve as a guest, pay by VietQR, sign in with MONA Pass once to claim; the agent then points DNS and SSL at your app. Alias o

SnapDeploy MCP

AAR-Labs

Deploy and manage SnapDeploy apps (Docker containers on AWS) from Claude Code, Cursor, Codex or Gemini CLI: builds, logs, env vars, add-ons, domains.

YesTechie — UniFi Network & Security Integrator

YesTechie

YesTechie builds enterprise UniFi networks, cameras, access control, cabling and Wi-Fi for businesses nationwide from its California HQ. Agents can read real project case studies and practical configuration guides, price

广告合作