SQL Server MCP by InsightfulPipe

com.insightfulpipe由 insightfulpipe.com 发布v1.0.0更新于 Oct 27, 2026

Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.

已验证Streamable HTTP可网页运行数据库数据与分析

概览

AI 生成的概览

托管式 SQL Server MCP 服务器，让助手浏览架构与表、查看元数据、分析查询计划，并对自有 SQL Server 或 Azure SQL 数据库执行 T-SQL。

可以做什么
  • 列出所连数据库中的架构、表、视图和序列
  • 读取表或视图的列定义，以及约束、索引和预估大小等完整元数据
  • 通过 SHOWPLAN_XML 解释查询，并从查询统计中列出最耗资源的查询
  • 检查数据库健康状况：连接状态、内存 clerk 与日志复用情况
  • 通过唯一的写入操作执行 T-SQL 语句，管理员可将其保持关闭
适用场景
适合希望助手在不本地安装任何组件的情况下探查和查询现有 Microsoft SQL Server 或 Azure SQL 实例的场景，例如回答表结构问题、查看查询计划或在受控登录下执行临时 T-SQL。
运行要求
通过 streamable HTTP 访问的远程 MCP 端点，无需本地包或运行时。需要 InsightfulPipe 账户并通过 OAuth 登录；订阅为付费制，7 天试用后每月 29.99 美元起。还需一个 SQL Server 或 Azure SQL 登录，其 GRANT/REVOKE 权限决定只读或读写。客户端支持不一：ChatGPT 需开启开发者模式并具备相应套餐。
安装前请注意
该连接器会对你的数据库执行 T-SQL，读写登录加上启用的 run_query 操作可能修改或删除数据；除非确有需要，应使用只读登录并保持破坏性操作关闭。访问范围由登录权限和按账户的操作开关共同决定。登录经由 InsightfulPipe 完成，查询与架构信息会经过其托管服务。使用需付费订阅。

安装

在 SourceWeft 中

  1. 打开 控制台中的 SQL Server MCP by InsightfulPipe，将其添加到工作区。
  2. 连接 所需的 凭据。它们会被私密存储，绝不会在公开页面上展示。
  3. 为需要使用其工具的对话启用该服务。

Web executable，通过 Streamable HTTP。 远程服务在工作区中配置后即可从网页运行时运行。

交给智能体安装

把这段提示词粘贴到 Claude Code、Codex、Cursor 等智能体，或 SourceWeft 对话中。智能体会读取该服务器的安装指南，先向你展示发布者、端点和登录方式，经你同意后再把它添加到你的客户端。密钥不会写进任何命令。

阅读 https://sourceweft.com/mcp/com.insightfulpipe%2Fmssql/install.md，并按其中说明把这个 MCP 服务器接入我的客户端。修改任何配置之前，先告诉我它的发布者、端点和登录方式，等我确认。不要把 API 密钥写进命令或我会提交的文件；问我密钥应从哪里获取。

查看智能体所依据的安装指南

其他 MCP 客户端

把它添加到你客户端的 mcpServers 配置中。 客户端会在首次连接时完成 OAuth 登录。

{
  "mcpServers": {
    "sql-by-insightfulpipe": {
      "type": "http",
      "url": "https://mssql.insightfulmcp.com/"
    }
  }
}

README

SQL Server MCP Server by Insightful Pipe

[MCP Compatible] [Insightful Pipe] [License]

Connect SQL Server to AI assistants: schemas, tables, T-SQL and database health for SQL Server and Azure SQL.

Part of the Insightful Pipe MCP Server Collection — use SQL Server from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).

[SQL Server MCP Server]

MCP Server URL

https://mssql.insightfulmcp.com/

What is SQL Server MCP?

SQL Server MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Browse schemas, inspect tables, and run T-SQL against your own Microsoft SQL Server or Azure SQL instance. Read vs. read-write is decided by the GRANT/REVOKE privileges on the login this connector uses.

Installation

Claude

  1. Copy the MCP Server URL: https://mssql.insightfulmcp.com/
  2. Open Claude Connectors Settings
  3. Scroll to the bottom and click Add custom connector
  4. Paste the URL and click Add
  5. Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.

ChatGPT

Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.

  1. Turn on Developer mode in ChatGPT settings
  2. Create a new app for a remote MCP server and paste the URL: https://mssql.insightfulmcp.com/
  3. Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.

See OpenAI's guide: Developer mode and MCP apps in ChatGPT

Claude Code

bash
claude mcp add --transport http mssql https://mssql.insightfulmcp.com/

Cursor

Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):

json
{  "mcpServers": {    "mssql": {      "url": "https://mssql.insightfulmcp.com/"    }  }}

When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.

Available Actions

8 actions: 7 read, 1 write.

Read Actions (7)

ActionDescription
analyze_db_healthConnection state + memory clerks + log-reuse health
explain_querySHOWPLAN_XML for a query
get_table_metadataFull metadata: columns + constraints + indexes + estimated size
get_table_schemaColumn list for a table or view
get_top_queriesHeaviest queries from sys.dm_exec_query_stats
list_schemasList all schemas in the connected database
list_tablesList tables, views, or sequences in a schema

Write Actions (1)

ActionDescription
run_queryExecute a T-SQL statement

Control What Your AI Can Do

You decide what AI agents can do with each connected account:

  • Turn individual actions on or off for every connected account, so agents only see the actions you allow.
  • Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
  • Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
  • Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.

Usage Examples

"List the tables in the dbo schema"
"Show the schema of the Orders table"
"Check my database health"

Pricing

The SQL Server MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month, and you can try it for 7 days. See insightfulpipe.com/pricing for current plans.

Explore More MCP Servers by Insightful Pipe

Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.

View All MCP Servers →

Resources

Support

Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.

来源：README.md，提交 21415db

工具

0
该服务器需要登录，因此 SourceWeft 无法在没有账号的情况下读取其工具，也未收录。已连接账号所能看到的内容可能因账号及其权限而异。

版本历史

1
  1. v1.0.0最新Oct 21, 2026

评分

已满足适用检查项的 85%

该评分衡量此收录条目的完整程度，依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价，也不表示服务器安全或当前可用：可连通性是带日期的检查结果，评分也不包含安装量或用户评价。

  • 近 30 天内可连通必需25 分
  • 已声明认证方式必需10 分
  • 已列出工具15 分

    请让服务器在无凭据时响应 tools/list，或发布可在沙箱中无凭据启动的软件包。

  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分