広告掲載
MCP.so
ログイン

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

よくある質問

1

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.

2

What are the runtime requirements?

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

3

How can I connect to a remote database?

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

4

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.

5

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.

コメント

「データベース」の他のコンテンツ

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

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

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

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.

広告掲載