広告掲載
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.

コメント

「クラウドとインフラ」の他のコンテンツ

Query | MCP server for Supabase

alexander-zuev

Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support, automatic migration versioning, access to logs and much more.

828

Dockhold

dockhold

Put the project you are working on online. Deploys the current folder or a GitHub repo to a live HTTPS URL on Dockhold; reads status and logs, sets variables, resizes apps and databases...

MCP Gateway

mcp-ecosystem

🧩 MCP Gateway - A lightweight gateway service that instantly transforms existing MCP Servers and APIs into MCP servers with zero code changes. Features Docker deployment and management UI, requiring no infrastructure modifications.

2.2K

Tessryx

Build and run websites, APIs, automations, and admin tools from chat. Your agent creates the data, logic, pages, and scheduled jobs; Tessryx hosts them on your own domain. No code generated, nothing to deploy.

SimpleBackups

SimpleBackups

SimpleBackups is automated backup management for databases, servers, cloud storage and SaaS apps. It covers Supabase, Neon, PlanetScale, PostgreSQL, MySQL, MongoDB, and apps like Notion, GitHub and Linear. This connector

広告掲載