Steampipe MCP server to query cloud infrastructure, SaaS, code and more with SQL using AI.
Connect Steampipe to Claude, Cursor or any other MCP client and it stops being a tab you switch to. Steampipe MCP server to query cloud infrastructure, SaaS, code and more with SQL using AI. The steampipe mcp server is what makes that connection.
Unlock the power of AI-driven infrastructure analysis with Steampipe! This Model Context Protocol server seamlessly connects AI assistants like Claude to your cloud infrastructure data, enabling natural language exploration and analysis of your entire cloud estate.
The toolset is worth reading before you wire it up, because it tells you what the integration is really for:
steampipe_query — Query cloud and security logs with SQLInput — sql (string): The SQL query to execute using PostgreSQL syntaxsteampipe_table_list — List all available Steampipe tablessteampipe_table_show — Get detailed information about a specific table, including column definitions, data types, and descriptionssteampipe_plugin_list — List all Steampipe plugins installed on the system. Plugins provide access to different data sources like AWS, GCP, or Azuresteampipe_plugin_show — Get details for a specific Steampipe plugin installation, including version, memory limits, and configurationPrerequisites — The Prerequisites tool exposed by this serverConfiguration — Add Steampipe MCP to your AI assistant's configuration file:Tools — The Tools tool exposed by this serverPrompts — The Prompts tool exposed by this serverResources — This resource enables AI tools to check and verify the connection status to your Steampipe instanceTesting — To test your local development build with AI tools that support MCP, update your MCP configuration to use the local dist/index.js instead of the npmnpx) - For local use: Steampipe installed and running (steampipe service start) - For Turbot Pipes: A Turbot Pipes workspace and connection stringThe server ships on npm as @modelcontextprotocol/inspector, so your MCP client can launch it on demand — there is no separate build step. Add the server block to your client's configuration, restart it, and the tools register themselves.
Plenty of database access servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. Steampipe's toolset — steampipe_query, Input, steampipe_table_list and 9 more — is a fair guide to whether it matches your workflow. It is maintained by e-gineer; worth a glance at recent repository activity before you build anything load-bearing on it.
We check each listing at SyncDev against the project's documentation before it goes live — if something here drifts out of date, it is a bug worth reporting.
| Tool | What it does |
|---|---|
| steampipe_query | Query cloud and security logs with SQL. |
| Input | sql (string): The SQL query to execute using PostgreSQL syntax |
| steampipe_table_list | List all available Steampipe tables. |
| steampipe_table_show | Get detailed information about a specific table, including column definitions, data types, and descriptions. |
| steampipe_plugin_list | List all Steampipe plugins installed on the system. Plugins provide access to different data sources like AWS, GCP, or Azure. |
| steampipe_plugin_show | Get details for a specific Steampipe plugin installation, including version, memory limits, and configuration. |
| Prerequisites | The Prerequisites tool exposed by this server. |
| Configuration | Add Steampipe MCP to your AI assistant's configuration file: |
| Tools | The Tools tool exposed by this server. |
| Prompts | The Prompts tool exposed by this server. |
| Resources | This resource enables AI tools to check and verify the connection status to your Steampipe instance. |
| Testing | To test your local development build with AI tools that support MCP, update your MCP configuration to use the local dist/index.js instead of the npm package. For example: |
{
"mcpServers": {
"steampipe": {
"command": "npx",
"args": [
"-y",
"@turbot/steampipe-mcp"
]
}
}
}Configuration as documented by the project. Restart the client after saving.
npx) - For local use: Steampipe installed and running (steampipe service start) - For Turbot Pipes: A Turbot Pipes workspace and connection stringRead-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.