mcp-mysql-服务器

@f4ww4z/mcp-mysql-服务器

提供 MySQL 数据库操作的模型上下文协议服务器。该服务器使 AI 模型能够通过标准化接口与 MySQL 数据库交互。

安装

通过 Smithery 安装

要通过Smithery自动为 Claude Desktop 安装 MySQL 服务器：

npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude

手动安装

npx @f4ww4z/mcp-mysql-server

配置

服务器需要在您的 MCP 设置配置文件中设置以下环境变量：

建议使用

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@f4ww4z/mcp-mysql-server", "mysql://user:password@localhost:port/database"],
    }
  }
}

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@f4ww4z/mcp-mysql-server"],
      "env": {
        "MYSQL_HOST": "your_host",
        "MYSQL_USER": "your_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

运行评估

evals 包会加载一个 mcp 客户端，然后运行 index.ts 文件，因此测试之间无需重新构建。您可以通过在 npx 命令前添加前缀来加载环境变量。完整文档可在此处找到。

OPENAI_API_KEY=your-key  npx mcp-eval src/evals/evals.ts src/index.ts

可用工具

1. 连接数据库

使用提供的凭据建立与 MySQL 数据库的连接。

use_mcp_tool({
  server_name: "mysql",
  tool_name: "connect_db",
  arguments: {
    host: "localhost",
    user: "your_user",
    password: "your_password",
    database: "your_database"
  }
});

2. 查询

使用可选的准备好的语句参数执行 SELECT 查询。

use_mcp_tool({
  server_name: "mysql",
  tool_name: "query",
  arguments: {
    sql: "SELECT * FROM users WHERE id = ?",
    params: [1]
  }
});

3. 执行

使用可选的准备好的语句参数执行 INSERT、UPDATE 或 DELETE 查询。

use_mcp_tool({
  server_name: "mysql",
  tool_name: "execute",
  arguments: {
    sql: "INSERT INTO users (name, email) VALUES (?, ?)",
    params: ["John Doe", "john@example.com"]
  }
});

4. 列表表

列出所连接数据库中的所有表。

use_mcp_tool({
  server_name: "mysql",
  tool_name: "list_tables",
  arguments: {}
});

5. describe_table

获取特定表的结构。

use_mcp_tool({
  server_name: "mysql",
  tool_name: "describe_table",
  arguments: {
    table: "users"
  }
});

特征

通过自动清理来安全处理连接
查询参数的预处理语句支持
全面的错误处理和验证
TypeScript 支持
自动连接管理

安全

使用准备好的语句来防止 SQL 注入
支持通过环境变量进行安全密码处理
执行前验证查询
完成后自动关闭连接

错误处理

服务器提供了常见问题的详细错误消息：

连接失败
无效查询
缺少参数
数据库错误

贡献

欢迎贡献！请随时向https://github.com/f4ww4z/mcp-mysql-server提交 Pull 请求。

执照

麻省理工学院

Install Server

HTTP connection URL

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Tools

该服务器使AI模型能够通过标准化接口与MySQL数据库进行交互。

Related MCP Servers

MCP-MySQL Server
enemyrr
A
security
F
license
A
quality
Enables AI models to perform MySQL database operations through a standardized interface, supporting secure connections, query execution, and comprehensive schema management.
Last updated -
7
46
25
JavaScript
MySQL MCP Server
Mineru98
-
security
A
license
-
quality
A server that enables AI models to interact with MySQL databases through a Model Control Protocol, providing tools for table creation, schema inspection, query execution, and data retrieval.
Last updated -
26
Python
MIT License
MCP MySQL Server
Atomzzm
-
security
A
license
-
quality
A Model Context Protocol server that enables AI models to interact with MySQL databases, providing tools for querying, executing statements, listing tables, and describing table structures.
Last updated -
963
MIT License
MCP MySQL Server
kevinbin
A
security
F
license
A
quality
A Model Context Protocol server that enables AI models to interact with MySQL databases through a standardized interface, providing tools for querying, executing commands, and managing database schemas.
Last updated -
7
JavaScript

View all related MCP servers

mcp-mysql-server