MCP cover image
See in Github
2025-04-07

该仓库包含用Python编写的用于SteamPipe的MCP。

1

Github Watches

0

Github Forks

1

Github Stars

Steampipe MCP

This is a simple steampipe MCP server. This acts as a bridge between your AI model and Steampipe tool.

Pre-requisites

  • Python 3.10+ installed.
  • uv installed (my fav) and mcp[cli]
  • Steampipe installed and working.
  • Steampipe plugin configured (e.g., github) with necessary credentials (e.g., token in ~/.steampipe/config/github.spc).
  • Any LLM supporting MCP. I am using Claude Here.
  • Node.js and npx installed (required for the MCP Inspector and potentially for running some MCP servers).

Running MCP Interceptor

This is an awesome tool for testing your if your MCP server is working as expected

  • Running the Interceptor npx -y @modelcontextprotocol/inspector uv --directory . run steampipe_mcp_server.py
  • A browser window should open with the MCP Inspector UI (usually at http://localhost:XXXX).
  • Wait for the "Connected" status on the left panel.
  • Go to the Tools tab.
  • You should see the run_steampipe_query tool listed with its description.
  • Click on the tool name.
  • In the "Arguments" JSON input field, enter a valid Steampipe query:
{
  "query": "select name, fork_count from github_my_repository "
}
  • execute and view the json results

Running the tool

Pretty straightforward. Just run the interceptor and make sure the tool is working from the directory. Then add the server configuration to the respective LLM and select the tool from the LLM. Screenshot 2025-04-06 at 11 53 23 PM Screenshot 2025-04-06 at 11 55 21 PM

TroubleShooting

  • If the tool is not found in the interceptor then that means @mcp.tool() decorator has some issue.
  • Execution error - Look at the "Result" in the Inspector and the server logs (stderr) in your terminal. Did Steampipe run? Was there a SQL error? A timeout? A JSON parsing error? Adjust the Python script accordingly.
tail -f ~/Library/Logs/Claude/mcp.log
tail -f ~/Library/Logs/Claude/mcp-server-steampipe.log

Security Risk Claude blindly executes your sql query in this POC so there is possibility to generate and execute arbitary SQL Queries via Steampipe using your configured credentials.

相关推荐

  • https://suefel.com
  • Latest advice and best practices for custom GPT development.

  • Yusuf Emre Yeşilyurt
  • I find academic articles and books for research and literature reviews.

  • https://maiplestudio.com
  • Find Exhibitors, Speakers and more

  • Carlos Ferrin
  • Encuentra películas y series en plataformas de streaming.

  • Joshua Armstrong
  • Confidential guide on numerology and astrology, based of GG33 Public information

  • Emmet Halm
  • Converts Figma frames into front-end code for various mobile frameworks.

  • Alexandru Strujac
  • Efficient thumbnail creator for YouTube videos

  • Elijah Ng Shi Yi
  • Advanced software engineer GPT that excels through nailing the basics.

  • lumpenspace
  • Take an adjectivised noun, and create images making it progressively more adjective!

  • Lists Tailwind CSS classes in monospaced font

  • https://zenepic.net
  • Embark on a thrilling diplomatic quest across a galaxy on the brink of war. Navigate complex politics and alien cultures to forge peace and avert catastrophe in this immersive interstellar adventure.

  • apappascs
  • 发现市场上最全面,最新的MCP服务器集合。该存储库充当集中式枢纽,提供了广泛的开源和专有MCP服务器目录,并提供功能,文档链接和贡献者。

  • ShrimpingIt
  • MCP系列GPIO Expander的基于Micropython I2C的操作,源自ADAFRUIT_MCP230XX

  • modelcontextprotocol
  • 模型上下文协议服务器

  • Mintplex-Labs
  • 带有内置抹布,AI代理,无代理构建器,MCP兼容性等的多合一桌面和Docker AI应用程序。

  • ravitemer
  • 一个功能强大的Neovim插件,用于管理MCP(模型上下文协议)服务器

  • jae-jae
  • MCP服务器使用剧作《无头浏览器》获取网页内容。

  • patruff
  • Ollama和MCP服务器之间的桥梁,使本地LLMS可以使用模型上下文协议工具

  • pontusab
  • 光标与风浪冲浪社区,查找规则和MCP

  • WangRongsheng
  • 🧑‍🚀 llm 资料总结(数据处理、模型训练、模型部署、 o1 模型、mcp 、小语言模型、视觉语言模型)|摘要世界上最好的LLM资源。

    Reviews

    2 (1)
    Avatar
    user_F5Ed2G3Y
    2025-04-18

    As a dedicated user of mcp applications, I can confidently say that mcp-steampipe by b0ttle-neck is an outstanding tool. It’s extremely reliable and well-crafted. The seamless integration and robust functionality make it a must-have for anyone serious about productivity and efficiency. Highly recommended!