広告掲載
MCP.so
ログイン

MySQL MCP Server

@actstorms

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

actstorms

MySQL MCP Server について

概要はまだありません

#mcp-mysql-server#database#mcp

MySQL MCP Server の設定

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

{
  "mcpServers": {
    "mcp-mysql-server-actstorms": {
      "command": "node",
      "args": [
        "build/index.js"
      ]
    }
  }
}

MySQL MCP Server のツール

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

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

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

概要

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) server that enables MCP clients (such as AI assistants) to query and modify data in a MySQL database. It connects to a user-configured MySQL instance and exposes tools for executing SQL statements over standard input/output (stdio).

How to use MySQL MCP Server?

Install dependencies with npm install, build the TypeScript code with npm run build, then run mysql-server (if linked globally) or node build/index.js. Configure connection via environment variables: MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE (required), and optionally MYSQL_PORT (default 3306). Set MYSQL_ALLOW_WRITE_OPS=true to enable write tools (insert, update, delete); otherwise only read-only queries are allowed.

Key features of MySQL MCP Server

  • Connects to MySQL using standard connection parameters.
  • Provides MCP tools for executing SQL queries and statements.
  • Read-only queries (SELECT, SHOW, DESCRIBE) via the query tool.
  • Write operations (INSERT, UPDATE, DELETE) via separate tools.
  • Write tools are gated by the MYSQL_ALLOW_WRITE_OPS environment variable.
  • Communicates over standard input/output (stdio).

Use cases of MySQL MCP Server

  • AI assistants executing read-only reports or analytics on a MySQL database.
  • Automating data entry with INSERT statements through a chat interface.
  • Managing small-scale updates or deletions in a database via natural language.

よくある質問

1

What does MySQL MCP Server do?

It acts as a bridge between MCP clients and a MySQL database, allowing AI assistants to run SQL queries and optionally modify data.

2

What are the dependencies for running MySQL MCP Server?

Node.js and npm are required to install and build the server. It also needs access to a running MySQL server and the corresponding connection credentials.

3

Where does the data reside?

All data stays in the user’s configured MySQL database. The server does not store or cache data externally.

4

What transport does MySQL MCP Server use?

It uses standard input/output (stdio) for communication with MCP clients.

5

How is authentication handled for MySQL?

Authentication is provided via the required environment variables `MYSQL_USER` and `MYSQL_PASSWORD`. Write operations can be further restricted by the optional `MYSQL_ALLOW_WRITE_OPS` variable, which defaults to `false`.

コメント

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

Elasticsearch MCP Server

elastic

685

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

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

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K
広告掲載