MySQL MCP by InsightfulPipe

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

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

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

概览

AI 生成的概览

托管的 MySQL/MariaDB MCP 服务器，让助手浏览库表结构、查看元数据、分析执行计划并对你的数据库执行 SQL。

可以做什么
  • 列出所连 MySQL 或 MariaDB 实例中的 schema、表、视图和插件
  • 读取表结构及完整元数据：列、约束、索引和估算大小
  • 分析查询执行计划，并从 performance_schema 中找出最耗资源的语句
  • 检查数据库健康状况：连接池、缓冲池大小以及存在可回收空间的表
  • 通过唯一的写入操作执行 SQL 语句（需为该账号开启）
适用场景
适合希望让 AI 助手在不本地安装任何东西的情况下探索和查询现有 MySQL 或 MariaDB 数据库的场景，例如询问表结构、优化查询和临时报表。权限按连接账号控制，也适合需要只读或受限访问的团队。
运行要求
需在 Claude、ChatGPT（开发者模式）、Claude Code 或 Cursor 中按 URL 添加远程 MCP 端点，并通过 OAuth 登录 InsightfulPipe 账号。你自己的 MySQL 或 MariaDB 实例须可被该连接器访问，登录角色的 GRANT/REVOKE 权限决定只读还是读写。7 天试用后需付费订阅 InsightfulPipe。
安装前请注意
连接器以你指定的角色登录数据库，其 GRANT/REVOKE 权限决定助手的能力上限，非必要请使用只读角色。run_query 会执行 SQL 语句，默认关闭，一旦开启可能修改或删除数据。数据库元数据和查询结果会经过第三方托管服务。权限按账号控制，请检查每个已连接账号开启了哪些操作。

安装

在 SourceWeft 中

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

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

交给智能体安装

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

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

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

其他 MCP 客户端

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

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

README

MySQL MCP Server by Insightful Pipe

[MCP Compatible] [Insightful Pipe] [License]

Connect MySQL to AI assistants: schemas, tables, SQL and database health for MySQL and MariaDB.

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

[MySQL MCP Server]

MCP Server URL

https://mysql.insightfulmcp.com/

What is MySQL MCP?

MySQL MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Browse schemas, inspect tables, and run SQL against your own MySQL or MariaDB instance. Read vs. read-write is decided by the GRANT/REVOKE privileges on the role this connector logs in as.

Installation

Claude

  1. Copy the MCP Server URL: https://mysql.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://mysql.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 mysql https://mysql.insightfulmcp.com/

Cursor

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

json
{  "mcpServers": {    "mysql": {      "url": "https://mysql.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 pool + buffer pool size + tables with reclaimable space
explain_queryEXPLAIN plan for a query
get_table_metadataFull metadata: columns + constraints + indexes + estimated size
get_table_schemaColumn list (name, data_type, is_nullable, default) for a table or view
get_top_queriesHeaviest queries from performance_schema.events_statements_summary_by_digest
list_schemasList all schemas (databases) on the server
list_tablesList tables, views, or plugins in a schema

Write Actions (1)

ActionDescription
run_queryExecute a 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 my database"
"Show the schema of the orders table"
"Run a query for revenue by month"

Pricing

The MySQL 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，提交 6ac06c8

工具

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

版本历史

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

评分

已满足适用检查项的 85%

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

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

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

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