広告掲載
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-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

広告掲載