mcp-steampipe

by b0ttle-neck

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.

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.

-
security - not tested
-
license - not tested
-
quality - not tested

local-only server

The server can only run on the client's local machine because it depends on local resources.

This is an MCP written for steampipe. This Steampipe MCP tool allows Claude to interact directly with your Steampipe installation using natural language requests. It executes provided SQL queries via the Steampipe CLI and returns the data results as JSON back to Claude.

Related MCP Servers

  • -
    security
    A
    license
    -
    quality
    Connects Claude Desktop directly to databases, allowing it to explore database structures, write SQL queries, analyze datasets, and create reports through an API layer with tools for table exploration and query execution.
    Last updated -
    182
    Python
    Mozilla Public License 2.0
    • Apple
  • A
    security
    A
    license
    A
    quality
    An MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata for querying, modifying, and managing objects and records.
    Last updated -
    7
    18
    4
    TypeScript
    MIT License
    • Apple
    • Linux
  • -
    security
    F
    license
    -
    quality
    This is a Model Context Protocol (MCP) server for executing SQL queries against Databricks using the Statement Execution API. It enables AI assistants to directly query Databricks data warehouses, analyze database schemas, and retrieve query results in a structured format
    Last updated -
    4
    Python
    • Linux
    • Apple
  • -
    security
    F
    license
    -
    quality
    A natural language interface that allows Claude to execute SQL queries on your local MySQL databases, enabling database interaction using natural language.
    Last updated -
    2
    Python
    • Linux
    • Apple

View all related MCP servers

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/b0ttle-neck/mcp-steampipe'

If you have feedback or need assistance with the MCP directory API, please join our Discord server