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 のツール

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

よくある質問

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.

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`.

Is the server truly read-only?

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

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.

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.