广告合作
MCP.so
登录

MCP Server for MySQL based on NodeJS

@MCP-Mirror

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

MCP-Mirror

关于 MCP Server for MySQL based on NodeJS

Mirror of

#mcp-server#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": "",
        "MYSQL_DB": "db_name"
      }
    }
  }
}

MCP Server for MySQL based on NodeJS 工具

1

Execute read-only SQL queries against the connected database

概览

What is MCP Server for MySQL based on NodeJS?

A Model Context Protocol server that provides read-only access to MySQL databases. It enables LLMs to inspect database schemas and execute read-only SQL queries. This server is designed for developers using MCP clients like Claude Desktop.

How to use MCP Server for MySQL based on NodeJS?

Add the provided configuration to the mcpServers section of your claude_desktop_config.json. Set environment variables MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, and MYSQL_DB. If npx is not in your default PATH, specify the full binary path and include PATH in the environment.

Key features of MCP Server for MySQL based on NodeJS

  • Read-only SQL query execution via the mysql_query tool
  • All queries run within a READ ONLY transaction
  • Automatic discovery of table schemas from database metadata
  • JSON schema output including column names and data types
  • Simple configuration for Claude Desktop integration

Use cases of MCP Server for MySQL based on NodeJS

  • Allowing an LLM to explore a MySQL database schema before generating queries
  • Enabling AI assistants to answer questions by querying a MySQL database
  • Providing read-only data access for natural language to SQL workflows
  • Automating database inspection and documentation

常见问题

1

Is this server read-only?

Yes. All queries are executed within a READ ONLY transaction. No write operations are supported.

2

What environment variables are required?

`MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASS`, and `MYSQL_DB` must be set. `MYSQL_DB` can be left blank to retrieve all databases.

3

How do I troubleshoot connection errors?

If you see "Could not connect to MCP server", you may need to explicitly set the full path to the `npx` binary and include the `PATH` environment variable in the configuration.

4

What license does this server use?

This MCP server is licensed under the MIT License.

评论

数据库 分类下的更多 MCP 服务器

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

MCP Server for MySQL based on NodeJS

benborla

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.

1.9K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539
广告合作