MCP Server for MySQL based on NodeJS

@benborla

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

benborla

关于 MCP Server for MySQL based on NodeJS

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

#mcp-server-mysql#mysql #nodejs

MCP Server for MySQL based on NodeJS 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp_server_mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "password",
        "MYSQL_DB": "your_db",
        "ALLOW_INSERT_OPERATION": "true",
        "ALLOW_UPDATE_OPERATION": "true",
        "ALLOW_DELETE_OPERATION": "true"
      }
    }
  }
}

MCP Server for MySQL based on NodeJS 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is MCP Server for MySQL based on NodeJS?

This server enables LLMs like Claude to interact with MySQL databases through the Model Context Protocol, allowing inspection of schemas, query execution, and optional write operations. It is designed for developers who want AI agents to query MySQL databases securely, with read-only access by default.

How to use MCP Server for MySQL based on NodeJS?

Install via npx @benborla29/mcp-server-mysql with environment variables for host, port, user, password, and database. For Claude Code, use claude mcp add; for other clients, configure a JSON entry in mcpServers. Write operations are opt-in using ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, and ALLOW_DELETE_OPERATION environment flags.

Key features of MCP Server for MySQL based on NodeJS

Read-only by default, write operations opt-in
Built-in SSH tunnel for remote databases
Multi-database mode without reconnecting
Automatic PII redaction in results
Remote mode with HTTP and bearer token auth
SSL/TLS support with mTLS option

Use cases of MCP Server for MySQL based on NodeJS

AI assistant executing read-only SQL queries for data analysis
Schema inspection and metadata retrieval via mysql://tables resource
Secure cross-database queries from a single connection
Remote database access through SSH tunnels

常见问题

Is write support enabled by default?

No, all write operations (INSERT, UPDATE, DELETE) are disabled by default. They must be enabled individually via environment flags.

What are the runtime requirements?

Node.js v20+ and MySQL 5.7+ (8.0+ recommended). The MySQL user must have appropriate privileges.

How can I connect to a remote database?

The server includes built-in SSH tunnel support for securely accessing remote MySQL instances.

How do I enable write operations?

Set the environment variables `ALLOW_INSERT_OPERATION=true`, `ALLOW_UPDATE_OPERATION=true`, and `ALLOW_DELETE_OPERATION=true` as needed.

What data can the server access?

By default, it queries the configured database and exposes table metadata via the `mysql://tables` resource. Schema-specific permissions can be set per database.