広告掲載
MCP.so
ログイン

MySQL MCP Server

@wuwen1030

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

wuwen1030

MySQL MCP Server について

A MySQL implementation of the Model Context Protocol (MCP) server. This server allows AI models to interact with MySQL databases through a standardized interface.

MySQL MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/ABSOLUTE/PATH/TO/PARENT/FOLDER/mysql-mcp-server/dist/index.js"
      ],
      "env": {
        "MYSQL_HOST": "",
        "MYSQL_PORT": "",
        "MYSQL_USER": "",
        "MYSQL_PASSWORD": "",
        "MYSQL_DATABASE": ""
      }
    }
  }
}

MySQL MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MySQL MCP Server?

A MySQL implementation of the Model Context Protocol (MCP) server that allows AI models to interact with MySQL databases through a standardized read-only interface.

How to use MySQL MCP Server?

Install with npm install and build with npm run build, then configure the server in your Claude Desktop app's claude_desktop_config.json by providing the absolute path to the built index.js and setting environment variables for MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE.

Key features of MySQL MCP Server

  • List available database tables
  • Get table schemas
  • Execute read-only SQL queries
  • Safe transaction handling with automatic rollback

Use cases of MySQL MCP Server

  • Explore a MySQL database schema through an AI assistant
  • Run read-only queries to retrieve data without risk of modification
  • Enable AI models to answer questions backed by live database content

よくある質問

1

What dependencies or runtime does MySQL MCP Server require?

Node.js is required. After cloning, run `npm install` and `npm run build` to compile the server.

2

How is authentication handled?

Authentication is configured via environment variables (`MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASSWORD`, `MYSQL_DATABASE`) passed to the server process.

3

Are write operations supported?

No. The server intentionally only supports read-only SQL queries and uses safe transaction handling with automatic rollback.

4

Where does the data live?

Data remains in the user's own MySQL database. The server does not store or persist any data externally.

5

What transport does the server use?

The server communicates over stdio, as configured in the Claude Desktop app's `claude_desktop_config.json` using the `command` and `args` fields.

コメント

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

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.

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

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
広告掲載