Related MCP Server Resources

Explore more AI models, providers, and integration options:

  • Explore AI Models
  • Explore AI Providers
  • Explore MCP Servers
  • LangDB Pricing
  • Documentation
  • AI Industry Blog
  • Azure Cosmos DB MCP Server
  • mcp-histfile
  • Powertools MCP Search Server
  • AGE-MCP-Server
  • Kintone MCP Server
Back to MCP Servers
mcp-steampipe

mcp-steampipe

Public
b0ttle-neck/mcp-steampipe

Bridge AI models with Steampipe using a Model Context Protocol server that enables executing Steampipe SQL queries via LLM tools for seamless data retrieval and integration.

python
0 tools
May 29, 2025
Updated Jun 4, 2025

Supercharge Your AI with mcp-steampipe

MCP Server

Unlock the full potential of mcp-steampipe through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.

Unified API Access
Complete Tracing
Instant Setup
Get Started Now

Free tier available • No credit card required

Instant Setup
99.9% Uptime
10,000+Monthly Requests

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.

Publicly Shared Threads0

Discover shared experiences

Shared threads will appear here, showcasing real-world applications and insights from the community. Check back soon for updates!

Share your threads to help others
Related MCPs5
  • Azure Cosmos DB MCP Server
    Azure Cosmos DB MCP Server

    Enables seamless, secure interaction between AI language models and Azure Cosmos DB by translating n...

    Added May 30, 2025
  • mcp-histfile
    mcp-histfile

    Access, search, and retrieve shell command history programmatically through the Model Context Protoc...

    Added May 30, 2025
  • Powertools MCP Search Server
    Powertools MCP Search Server

    Model Context Protocol server enabling efficient local search of AWS Lambda Powertools documentation...

    2 tools
    Added May 30, 2025
  • AGE-MCP-Server
    AGE-MCP-Server

    Enables integration of Apache AGE graph database capabilities with Azure Database for PostgreSQL thr...

    Added May 30, 2025
  • Kintone MCP Server
    Kintone MCP Server

    Enables seamless integration with kintone via Model Context Protocol, offering comprehensive capabil...

    25 tools
    Added May 30, 2025