Advertise
MCP.so
Sign In

Steampipe MCP Server

@turbot

Repository

Basic information

Category

Other

License

Apache-2.0

Transports

stdio

Author

turbot

About Steampipe MCP Server

Enable AI assistants to explore and query your Steampipe data!

#ai#mcp#steampipe#turbot-pipes#mcp-server

Steampipe MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "steampipe": {
      "command": "npx",
      "args": [
        "-y",
        "@turbot/steampipe-mcp"
      ]
    }
  }
}

Steampipe MCP Server tools

5

Query cloud infrastructure, SaaS, APIs, code and more with SQL. Queries are read-only and must use PostgreSQL syntax. For best performance: limit columns requested, use materialized CTEs instead of joins. Trust the search path unless sure you need to specify a schema. Check available tables and columns before querying using steampipe_table_list and steampipe_table_show.

List all available Steampipe tables. Use schema and filter parameters to narrow down results.

Get detailed information about a specific Steampipe table, including column definitions, data types, and descriptions.

List all Steampipe plugins installed on the system. Plugins provide access to different data sources like AWS, GCP, or Azure.

Get details for a specific Steampipe plugin installation, including version, memory limits, and configuration.

Overview

What is Steampipe MCP Server?

The Steampipe MCP Server connects AI assistants like Claude to your cloud infrastructure data via Steampipe, enabling natural language exploration and analysis across AWS, Azure, GCP, and 100+ cloud services. It provides read‑only access to cloud and SaaS data for security, compliance, cost, and resource analysis.

How to use Steampipe MCP Server?

Install Node.js v16 or higher and have Steampipe running locally (steampipe service start) or a Turbot Pipes workspace. Add the server configuration to your AI assistant’s MCP config file (e.g., claude_desktop_config.json for Claude Desktop, ~/.cursor/mcp.json for Cursor). After restarting the assistant, run the best_practices prompt to teach the LLM how to work with Steampipe, then ask natural‑language questions about your infrastructure.

Key features of Steampipe MCP Server

  • Query cloud and security logs using SQL (PostgreSQL syntax).
  • List, filter, and inspect available Steampipe tables.
  • List and show details of installed Steampipe plugins.
  • Connect to local Steampipe or Turbot Pipes workspaces.
  • Provides a best_practices prompt to optimize LLM responses.
  • Exposes a status resource to verify connection state.

Use cases of Steampipe MCP Server

  • Explore cloud accounts and resources with natural language (e.g., “What AWS accounts can you see?”).
  • Generate infrastructure reports (e.g., “List EC2 instances with attached EBS volumes”).
  • Perform security analysis (e.g., “Find IAM users with unrotated access keys”).
  • Get compliance insights (e.g., “Show EC2 instances not complying with tagging standards”).
  • Analyze risks (e.g., “Check S3 buckets for public access and encryption”).

Frequently asked questions

1

What prerequisites are needed?

Node.js v16 or higher is required. For local use, Steampipe must be installed and running (`steampipe service start`). For cloud use, a Turbot Pipes workspace and connection string are needed.

2

How do I connect to Turbot Pipes instead of local Steampipe?

Add your Turbot Pipes connection string as an additional argument in the MCP configuration’s `args` array (e.g., `"postgresql://my_name:my_pw@workspace-name.usea1.db.pipes.turbot.com:9193/abc123"`).

3

What tools does the server provide?

The server provides five tools: `steampipe_query` (run SQL), `steampipe_table_list` (list tables), `steampipe_table_show` (details of a table), `steampipe_plugin_list` (list installed plugins), and `steampipe_plugin_show` (details of a plugin).

4

Are queries read‑only?

Yes, all queries are read‑only and use PostgreSQL syntax.

5

Is there a prompt to teach the LLM how to use Steampipe?

Yes, the `best_practices` prompt provides detailed guidance on SQL style, CTEs, optimization, and error handling. Run it first for best results.

Comments

More Other MCP servers

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K
Advertise