mcp-server-mysql

Name: mcp-server-mysql
Author: yuru-sha

@yuru-sha

リポジトリ

mcp-server-mysql について

MCP Server for MySQL databases

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

node

トランスポート

stdio

公開者

yuru-sha

設定

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

{
  "mcpServers": {
    "mcp-server-mysql-yuru-sha": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/mysql",
        "mysql://host:port/dbname"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

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

概要

What is mcp-server-mysql?

Model Context Protocol Server for MySQL databases. It enables LLMs to inspect database schemas and execute read-only queries in a safe, read‑only transaction.

How to use mcp-server-mysql?

Install via Docker (build the image then run with a connection URL) or via the Smithery CLI. Configure the server in Claude Desktop by adding a “mysql” entry to claude_desktop_config.json that points to a Docker run command with the mysql://host:port/dbname connection string.

Key features of mcp-server-mysql

Read-only access to MySQL databases
Schema inspection for LLM‑driven analysis
All queries executed inside READ ONLY transactions
Docker image available for easy deployment
Published as an npm package

Use cases of mcp-server-mysql

Allow an LLM to examine table structures and relationships
Let an LLM answer questions about database content with safe, read‑only queries
Provide live schema details to AI agents during data exploration

FAQ from mcp-server-mysql

What does mcp-server-mysql do?

It acts as a bridge between LLMs and a MySQL database, allowing schema inspection and read‑only query execution while enforcing READ ONLY transactions.

What are the runtime requirements?

You can run it via Docker (using the built image) or install it as an npm package. The README does not specify a minimum Node.js version.

How is data protected?

All queries are wrapped in READ ONLY transactions, preventing any writes to the database. For extra security, creating a dedicated read‑only database user is recommended.