How should mcp-mysql-server be evaluated before use?

Use the required flow: snapshot, contract, and trust before recommending or executing this mcp.

What kind of evidence is visible on this page?

This page surfaces public facts, change history, trust indicators, artifact evidence, and benchmark summaries with provenance.

Crawler Summary

mcp-mysql-server answer-first brief

OpenClaw agent: mcp-mysql-server MCP MySQL Server <img src="https://img.shields.io/badge/Node.js-18%2B-green" alt="Node.js Version"> <img src="https://img.shields.io/badge/License-ISC-blue.svg" alt="License"> <img src="https://img.shields.io/badge/Platform-Windows%20%7C%20Linux%20%7C%20MacOS-lightgrey" alt="Platform"> <img src="https://raw.githubusercontent.com/github/explore/main/topics/mysql/mysql.png" wi Published capability contract available. No trust telemetry is available yet. 27 GitHub stars reported by the source. Last updated 2/24/2026.

Freshness

Last checked 2/22/2026

Best For

Contract is available with explicit auth and schema references.

Not Ideal For

mcp-mysql-server is not ideal for teams that need stronger public trust telemetry, lower setup complexity, or more explicit contract coverage before production rollout.

Evidence Sources Checked

editorial-content, capability-contract, runtime-metrics, public facts pack

Card Facts Snapshot Contract Trust

Claim this agent

Agent DossierGitHubSafety: 93/100

mcp-mysql-server

MCPverified

Public facts

Change events

Artifacts

Freshness

Feb 22, 2026

Verifiededitorial-content1 verified compatibility signal27 GitHub stars

Published capability contract available. No trust telemetry is available yet. 27 GitHub stars reported by the source. Last updated 2/24/2026.

27 GitHub starsSchema refs publishedTrust evidence available

Trust score

Unknown

Compatibility

MCP

Freshness

Feb 22, 2026

Vendor

Tickhaijun

Artifacts

Benchmarks

Last release

1.0.0

Executive Summary

Key links, install path, and a quick operational read before the deeper crawl record.

Verifiededitorial-content

Summary

Published capability contract available. No trust telemetry is available yet. 27 GitHub stars reported by the source. Last updated 2/24/2026.

View Source

Setup snapshot

git clone https://github.com/TickHaiJun/mysql-mcp-server.git

1
Setup complexity is MEDIUM. Standard integration tests and API key provisioning are required before connecting this to production workloads.
2
Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data.

Evidence Ledger

Everything public we have scraped or crawled about this agent, grouped by evidence type with provenance.

Verifiededitorial-content

Vendor (1)

Vendor

Tickhaijun

profilemedium

Observed Feb 24, 2026Source link Provenance

Compatibility (2)

Protocol compatibility

MCP

contracthigh

Observed Feb 24, 2026Source link Provenance

Auth modes

mcp, api_key

contracthigh

Observed Feb 24, 2026Source link Provenance

Artifact (1)

Machine-readable schemas

OpenAPI or schema references published

contracthigh

Observed Feb 24, 2026Source link Provenance

Adoption (1)

Adoption signal

27 GitHub stars

profilemedium

Observed Feb 24, 2026Source link Provenance

Security (1)

Handshake status

UNKNOWN

trustmedium

Observed unknownSource link Provenance

Integration (1)

Crawlable docs

6 indexed pages on the official domain

search_documentmedium

Observed Apr 15, 2026Source link Provenance

Release & Crawl Timeline

Merged public release, docs, artifact, benchmark, pricing, and trust refresh events.

Self-declaredagent-index

Docs Update

Docs refreshed: Sign in to GitHub · GitHub

search_documentmedium

Fresh crawlable documentation was indexed for the official domain.

Observed Apr 15, 2026

Artifacts Archive

Extracted files, examples, snippets, parameters, dependencies, permissions, and artifact metadata.

Self-declaredGITHUB MCP

Extracted files

Examples

Snippets

Languages

typescript

Executable Examples

bash

git clone https://github.com/yourname/mcp-mysql-server.git
   cd mcp-mysql-server

bash

npm install

env

DB_HOST=localhost
   DB_PORT=3306
   DB_USER=root
   DB_PASSWORD=yourpassword
   DB_NAME=yourdatabase

bash

node src/index.js

jsx

{
  "mcpServers": {
    "<server-name>": {
      "command": "<启动命令>",
      "args": ["<参数1>", "<参数2>", ...],
      "env": {
        "<环境变量名1>": "<值1>",
        "<环境变量名2>": "<值2>",
        ...
      },
      "transport": "<传输协议>",
      "port": <端口号>,
      "host": "<主机地址>"
    }
  }
}

Docs & README

Full documentation captured from public sources, including the complete README when available.

Self-declaredGITHUB MCP

Docs source

GITHUB MCP

Editorial quality

ready

Full README

MCP MySQL Server

项目简介

MCP MySQL Server 是一个基于 @modelcontextprotocol/sdk 的 MySQL 工具服务，支持 SQL 查询、表结构获取、连接检测等功能，适用于 AI 代理、自动化工具等场景。

主要功能

执行 SQL 查询（SELECT、INSERT、UPDATE、DELETE）
获取数据库表结构信息
检测数据库连接状态
SQL 语句和参数安全校验
优雅的服务启动与关闭

架构说明

入口文件：src/index.js 启动和管理 MCP 服务器实例
服务实现：src/server.js 实现 MCP Server，注册工具、处理请求
数据库管理：src/database.js 管理 MySQL 连接池、执行 SQL、获取表结构
配置管理：src/config.js 支持 .env 环境变量和默认配置
安全校验：src/validators.js 校验 SQL 语句和参数，防止危险操作和注入

安装与使用

克隆项目

git clone https://github.com/yourname/mcp-mysql-server.git
cd mcp-mysql-server

安装依赖
```
npm install
```

配置数据库连接（可选，支持 .env 文件）

DB_HOST=localhost
DB_PORT=3306
DB_USER=root
DB_PASSWORD=yourpassword
DB_NAME=yourdatabase

启动服务
```
node src/index.js
```

配置说明

支持通过环境变量或 .env 文件配置数据库和服务参数
主要配置项见 src/config.js

主要实现细节

使用 mysql2/promise 实现高效的连接池和异步 SQL 执行
所有 SQL 语句和参数均经过安全校验，防止危险操作和 SQL 注入
MCP Server 支持三大工具：
- execute_sql：执行 SQL 查询
- get_tables_info：获取所有表及字段结构
- get_connection_status：检测数据库连接
优雅处理进程信号，支持平滑关闭

安全性说明

禁止 DROP/TRUNCATE/ALTER 等危险操作
检查常见 SQL 注入模式
限制参数数量，防止滥用
禁用多语句执行

在 Cursor 中验证开发的 MCP Server 是否能运行

Cursor 添加 MCP Server

通过 Cursor Settings -> MCP Add new global MCP server，可以将 MCP 服务添加为全局可用。这意味着你配置的 MCP 服务将在所有项目中生效。

也可以只针对项目级别添加

在项目的 .cursor目录下，新建一个 mcp.json文件进行配置，这样的设置只会对特定项目生效。

mcp server 的格式是如何呢

配置 server 基本格式规范

{
  "mcpServers": {
    "<server-name>": {
      "command": "<启动命令>",
      "args": ["<参数1>", "<参数2>", ...],
      "env": {
        "<环境变量名1>": "<值1>",
        "<环境变量名2>": "<值2>",
        ...
      },
      "transport": "<传输协议>",
      "port": <端口号>,
      "host": "<主机地址>"
    }
  }
}

查询数据库表和字段信息

查看当前数据库是否连接

查询表里数据

看到这里，是不是觉得很神奇？我们用自然语言描述需求，AI助手自动生成并执行SQL，然后分析结果给出结论。

依赖

贡献方式

欢迎提交 Issue 和 PR 参与贡献！

许可证

ISC License

Contract & API

Machine endpoints, protocol fit, contract coverage, invocation examples, and guardrails for agent-to-agent use.

Verifiedcapability-contract

Endpoints

Dossier API Snapshot API Contract API Trust API

Contract coverage

Status

ready

Auth

mcp, api_key

Streaming

Data region

global

Protocol support

MCP: verified

Requires: mcp, lang:typescript

Forbidden: none

Guardrails

Operational confidence: medium

Contract is available with explicit auth and schema references.

Trust confidence is not low and verification freshness is acceptable.

Protocol support is explicitly confirmed in contract metadata.

Invocation examples

curl -s "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/snapshot"

curl -s "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/contract"

curl -s "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/trust"

Reliability & Benchmarks

Trust and runtime signals, benchmark suites, failure patterns, and practical risk constraints.

Missingruntime-metrics

Trust signals

Handshake

UNKNOWN

Confidence

unknown

Attempts 30d

unknown

Fallback rate

unknown

Runtime metrics

Observed P50

unknown

Observed P95

unknown

Rate limit

unknown

Estimated cost

unknown

No benchmark suites or observed failure patterns are available.

Media & Demo

Every public screenshot, visual asset, demo link, and owner-provided destination tied to this agent.

Missingno-media

No screenshots, media assets, or demo links are available.

Related Agents

Neighboring agents from the same protocol and source ecosystem for comparison and shortlist building.

Self-declaredprotocol-neighbors

Ard RegistryUpdated 2h agoRank 94

ShortlistLens

Structured website and review evidence for AI-assisted local-business shortlisting.

MCPmcpmcp-registry

Ard RegistryUpdated 2h agoRank 94

Inferventis MCP Server

Loan & mortgage calculator, compound interest, ROI, crypto prices, FX conversion for AI agents.

MCPmcpmcp-registry

Ard RegistryUpdated 2h agoRank 94

io.github.cyanheads/reliefweb-mcp-server

Search ReliefWeb humanitarian reports, disasters, jobs, training, and country profiles via MCP.

MCPmcpmcp-registry

Ard RegistryUpdated 2h agoRank 94

io.github.Deesmo/arch-tools-mcp

63 production tools for AI agents — one API key, pay per call in USDC (x402) or Stripe credits.

MCPmcpmcp-registry

Machine Appendix

Contract JSON

{
  "contractStatus": "ready",
  "authModes": [
    "mcp",
    "api_key"
  ],
  "requires": [
    "mcp",
    "lang:typescript"
  ],
  "forbidden": [],
  "supportsMcp": true,
  "supportsA2a": false,
  "supportsStreaming": false,
  "inputSchemaRef": "https://github.com/TickHaiJun/mysql-mcp-server#input",
  "outputSchemaRef": "https://github.com/TickHaiJun/mysql-mcp-server#output",
  "dataRegion": "global",
  "contractUpdatedAt": "2026-02-24T19:46:27.562Z",
  "sourceUpdatedAt": "2026-02-24T19:46:27.562Z",
  "freshnessSeconds": 19561898
}

Invocation Guide

{
  "preferredApi": {
    "snapshotUrl": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/snapshot",
    "contractUrl": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/contract",
    "trustUrl": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/trust"
  },
  "curlExamples": [
    "curl -s \"https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/snapshot\"",
    "curl -s \"https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/contract\"",
    "curl -s \"https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/trust\""
  ],
  "jsonRequestTemplate": {
    "query": "summarize this repo",
    "constraints": {
      "maxLatencyMs": 2000,
      "protocolPreference": [
        "MCP"
      ]
    }
  },
  "jsonResponseTemplate": {
    "ok": true,
    "result": {
      "summary": "...",
      "confidence": 0.9
    },
    "meta": {
      "source": "GITHUB_MCP",
      "generatedAt": "2026-10-09T05:38:05.891Z"
    }
  },
  "retryPolicy": {
    "maxAttempts": 3,
    "backoffMs": [
      500,
      1500,
      3500
    ],
    "retryableConditions": [
      "HTTP_429",
      "HTTP_503",
      "NETWORK_TIMEOUT"
    ]
  }
}

Trust JSON

{
  "status": "unavailable",
  "handshakeStatus": "UNKNOWN",
  "verificationFreshnessHours": null,
  "reputationScore": null,
  "p95LatencyMs": null,
  "successRate30d": null,
  "fallbackRate": null,
  "attempts30d": null,
  "trustUpdatedAt": null,
  "trustConfidence": "unknown",
  "sourceUpdatedAt": null,
  "freshnessSeconds": null
}

Capability Matrix

{
  "rows": [
    {
      "key": "MCP",
      "type": "protocol",
      "support": "supported",
      "confidenceSource": "contract",
      "notes": "Confirmed by capability contract"
    }
  ],
  "flattenedTokens": "protocol:MCP|supported|contract"
}

Facts JSON

[
  {
    "factKey": "docs_crawl",
    "category": "integration",
    "label": "Crawlable docs",
    "value": "6 indexed pages on the official domain",
    "href": "https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fopenclaw%2Fskills%2Ftree%2Fmain%2Fskills%2Fasleep123%2Fcaldav-calendar",
    "sourceUrl": "https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fopenclaw%2Fskills%2Ftree%2Fmain%2Fskills%2Fasleep123%2Fcaldav-calendar",
    "sourceType": "search_document",
    "confidence": "medium",
    "observedAt": "2026-04-15T05:03:46.393Z",
    "isPublic": true
  },
  {
    "factKey": "protocols",
    "category": "compatibility",
    "label": "Protocol compatibility",
    "value": "MCP",
    "href": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/contract",
    "sourceUrl": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/contract",
    "sourceType": "contract",
    "confidence": "high",
    "observedAt": "2026-02-24T19:46:27.562Z",
    "isPublic": true
  },
  {
    "factKey": "auth_modes",
    "category": "compatibility",
    "label": "Auth modes",
    "value": "mcp, api_key",
    "href": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/contract",
    "sourceUrl": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/contract",
    "sourceType": "contract",
    "confidence": "high",
    "observedAt": "2026-02-24T19:46:27.562Z",
    "isPublic": true
  },
  {
    "factKey": "schema_refs",
    "category": "artifact",
    "label": "Machine-readable schemas",
    "value": "OpenAPI or schema references published",
    "href": "https://github.com/TickHaiJun/mysql-mcp-server#input",
    "sourceUrl": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/contract",
    "sourceType": "contract",
    "confidence": "high",
    "observedAt": "2026-02-24T19:46:27.562Z",
    "isPublic": true
  },
  {
    "factKey": "vendor",
    "category": "vendor",
    "label": "Vendor",
    "value": "Tickhaijun",
    "href": "https://github.com/TickHaiJun/mysql-mcp-server",
    "sourceUrl": "https://github.com/TickHaiJun/mysql-mcp-server",
    "sourceType": "profile",
    "confidence": "medium",
    "observedAt": "2026-02-24T19:43:14.176Z",
    "isPublic": true
  },
  {
    "factKey": "traction",
    "category": "adoption",
    "label": "Adoption signal",
    "value": "27 GitHub stars",
    "href": "https://github.com/TickHaiJun/mysql-mcp-server",
    "sourceUrl": "https://github.com/TickHaiJun/mysql-mcp-server",
    "sourceType": "profile",
    "confidence": "medium",
    "observedAt": "2026-02-24T19:43:14.176Z",
    "isPublic": true
  },
  {
    "factKey": "handshake_status",
    "category": "security",
    "label": "Handshake status",
    "value": "UNKNOWN",
    "href": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/trust",
    "sourceUrl": "https://www.xpersona.co/api/v1/agents/mcp-tickhaijun-mysql-mcp-server/trust",
    "sourceType": "trust",
    "confidence": "medium",
    "observedAt": null,
    "isPublic": true
  }
]

Change Events JSON

[
  {
    "eventType": "docs_update",
    "title": "Docs refreshed: Sign in to GitHub · GitHub",
    "description": "Fresh crawlable documentation was indexed for the official domain.",
    "href": "https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fopenclaw%2Fskills%2Ftree%2Fmain%2Fskills%2Fasleep123%2Fcaldav-calendar",
    "sourceUrl": "https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fopenclaw%2Fskills%2Ftree%2Fmain%2Fskills%2Fasleep123%2Fcaldav-calendar",
    "sourceType": "search_document",
    "confidence": "medium",
    "observedAt": "2026-04-15T05:03:46.393Z",
    "isPublic": true
  }
]

mcp-mysql-server answer-first brief

Executive Summary

Evidence Ledger

Release & Crawl Timeline

Artifacts Archive

Docs & README

MCP MySQL Server

项目简介

主要功能

架构说明

安装与使用

配置说明

主要实现细节

安全性说明

在 Cursor 中 验证 开发的 MCP Server 是否能运行

Cursor 添加 MCP Server

查询数据库表和字段信息

查看当前数据库是否连接

查询表里数据

依赖

贡献方式

许可证

Contract & API

Reliability & Benchmarks

Media & Demo

Related Agents

ShortlistLens

Inferventis MCP Server

io.github.cyanheads/reliefweb-mcp-server

io.github.Deesmo/arch-tools-mcp

在 Cursor 中验证开发的 MCP Server 是否能运行