Skip to main content
Glama
b0ttle-neck

mcp-steampipe

by b0ttle-neck

蒸汽管道 MCP

这是一个简单的 Steampipe MCP 服务器。它充当 AI 模型和 Steampipe 工具之间的桥梁。

先决条件

  • 已安装 Python 3.10+。

  • 安装了 uv(我的最爱)和 mcp[cli]

  • 蒸汽管道已安装并运行。

  • Steampipe 插件已配置(例如,github)并带有必要的凭证(例如,~/.steampipe/config/github.spc 中的令牌)。

  • 任何支持 MCP 的 LLM 都可以。我这里用的是 Claude。

  • 安装了 Node.js 和 npx(MCP Inspector 需要并且可能运行某些 MCP 服务器)。

Related MCP server: steam-mcp

运行 MCP 拦截器

这是一个非常棒的工具,可以测试您的 MCP 服务器是否按预期运行

  • 运行拦截器npx -y @modelcontextprotocol/inspector uv --directory . run steampipe_mcp_server.py

  • 应打开一个带有 MCP Inspector UI 的浏览器窗口(通常位于http://localhost:XXXX )。

  • 等待左侧面板上的“已连接”状态。

  • 转到“工具”选项卡。

  • 您应该会看到 run_steampipe_query 工具及其描述。

  • 单击工具名称。

  • 在“参数”JSON 输入字段中,输入有效的 Steampipe 查询:

{
  "query": "select name, fork_count from github_my_repository "
}
  • 执行并查看json结果

运行工具

非常简单。只需运行拦截器并确保该工具在目录中正常运行。然后将服务器配置添加到相应的 LLM,并从 LLM 中选择该工具。 截图于 2025-04-06 11:53 23:00截图于 2025-04-06 11:55 21PM

故障排除

  • 如果在拦截器中找不到该工具,则意味着@mcp.tool() 装饰器存在一些问题。

  • 执行错误 - 查看检查器中的“结果”以及终端中的服务器日志(stderr)。Steampipe 是否运行?是否存在 SQL 错误?超时?JSON 解析错误?请相应地调整 Python 脚本。

tail -f ~/Library/Logs/Claude/mcp.log
tail -f ~/Library/Logs/Claude/mcp-server-steampipe.log

安全风险Claude 在此 POC 中盲目执行您的 SQL 查询,因此有可能使用您配置的凭据通过 Steampipe 生成和执行任意 SQL 查询。

Available Tools

1 tool
run_steampipe_queryB

Executes a SQL query using the Steampipe CLI and returns the results as a JSON string.

Args: query: The SQL query to execute via Steampipe (e.g., "select login from github_user limit 1"). Ensure the query is valid Steampipe SQL.

ParametersJSON Schema
NameRequiredDescriptionDefault
queryYes

TDQS

B3.2/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It states that the tool executes a query and returns JSON results, but lacks critical details such as execution timeouts, error handling, authentication requirements, or rate limits. This leaves significant gaps in understanding how the tool behaves in practice.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured and concise, with no wasted words. It starts with a clear purpose statement, followed by a labeled 'Args' section with a bullet point for the single parameter. Each sentence adds value, making it easy to scan and understand quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (executing SQL queries with potential side effects) and the lack of annotations and output schema, the description is moderately complete. It covers the basic purpose and parameter semantics but misses behavioral details like error responses, performance considerations, or output structure, which are important for a query execution tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The description adds meaningful context beyond the input schema, which has 0% description coverage. It explains that the 'query' parameter is 'The SQL query to execute via Steampipe' and provides an example, clarifying that it must be 'valid Steampipe SQL.' This compensates well for the schema's lack of detail, though it doesn't cover all potential edge cases.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Executes a SQL query using the Steampipe CLI and returns the results as a JSON string.' It specifies the verb ('executes'), resource ('SQL query'), and output format ('JSON string'). However, with no sibling tools mentioned, there's no explicit differentiation from alternatives, preventing a perfect score.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides minimal usage guidance. It includes an example query but does not specify when to use this tool versus other methods (e.g., direct database access or other query tools). There is no mention of prerequisites, error conditions, or typical use cases beyond the basic example.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

  1. 1 tool updatev1.0.0
    • First observedrun_steampipe_query

TDQS

B3.3/5.0

Scored across 1 tool

Disambiguation5/5

With only one tool, there is no possibility of ambiguity or overlap between tools. The tool's purpose is clearly defined and distinct by default.

Naming Consistency5/5

A single tool inherently has perfect naming consistency, as there are no other tools to compare it against. The naming follows a clear verb_noun pattern (run_steampipe_query).

Tool Count2/5

A single tool is too few for most practical purposes, as it severely limits the server's functionality and flexibility. While it might cover the basic query execution, it lacks any supporting operations like listing available tables, checking query status, or managing connections.

Completeness2/5

The server is severely incomplete for interacting with Steampipe. It only provides query execution, missing essential operations such as listing available plugins/tables, describing table schemas, managing connections, or handling query errors and metadata. This will cause significant agent failures in complex workflows.

Maintenance

ActivityInactive
ResponsivenessNo issues

Related MCP Connectors

Related MCP Servers

  • A
    license
    A
    quality
    D
    maintenance
    A SQL Server CLI and MCP server for Claude Code that supports standard SQL Server authentication for database interaction and management. It enables users to perform schema exploration, execute queries, and manage data records with built-in SQL injection prevention.
    12
    5
    MIT
  • A
    license
    A
    quality
    D
    maintenance
    Connects Claude to your Steam library via the Steam Web API. Query your games, playtime, recently played history, and store metadata using natural language. Zero-config install via npx steam-mcp.
    5
    10 npm
    5
    MIT
  • F
    license
    Not graded
    quality
    D
    maintenance
    Enables interaction with SQLite databases, filesystem, AWS IAM, and Gmail through a master MCP server with a Streamlit UI optimized for Claude.
    1
    -
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables Claude Code and other MCP clients to interact with Microsoft SQL Server databases through standardized tools for query execution, schema exploration, table management, and stored procedure execution.
    64 npm
    1
    MIT