广告合作
MCP.so
登录

MCP Server for MySQL based on NodeJS

@MCP-Mirror

代码仓库

基本信息

分类

数据库

传输方式

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_myqsl": {
      "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?

MCP Server for MySQL based on NodeJS is 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.

How to use MCP Server for MySQL based on NodeJS?

Add the server configuration to the mcpServers section of your Claude Desktop configuration file (claude_desktop_config.json), using npx with environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB). The mysql_query tool can then be invoked for read‑only queries.

Key features of MCP Server for MySQL based on NodeJS

  • Read-only access to MySQL databases
  • Inspect database schemas automatically
  • Execute custom SQL queries via the mysql_query tool
  • All queries run within a READ ONLY transaction
  • Exposes JSON schema information for each table
  • Table schemas discovered from database metadata

Use cases of MCP Server for MySQL based on NodeJS

  • LLM-driven database schema exploration
  • Running read-only analysis queries against a MySQL database
  • Automating data retrieval for reporting or summarization

常见问题

1

What does the server do?

It provides a Model Context Protocol interface that gives an LLM read-only access to a MySQL database, allowing schema inspection and safe query execution.

2

How do I configure the database connection?

Set the environment variables `MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASS`, and `MYSQL_DB` in the server configuration inside `claude_desktop_config.json`.

3

Is the server truly read-only?

Yes. All SQL queries are executed within a READ ONLY transaction, preventing any write operations.

4

What resources does the server expose?

It exposes JSON schema information for each table, including column names and data types, automatically discovered from the database metadata.

5

What are the runtime requirements?

The server requires Node.js and `npx`. If the server fails to connect, you may need to explicitly set the `PATH` environment variable in the configuration to include the location of Node.js binaries.

评论

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

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Elasticsearch MCP Server

elastic

685

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

4

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

广告合作