MySQL Database Access MCP Server

@MCP-Mirror

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT license

トランスポート

stdio

作者

MCP-Mirror

MySQL Database Access MCP Server について

Mirror of

#mysql #database #mcp-server

MySQL Database Access MCP Server の設定

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

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "mysql-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "",
        "MYSQL_PORT": "",
        "MYSQL_USER": "",
        "MYSQL_PASSWORD": "",
        "MYSQL_DATABASE": ""
      }
    }
  }
}

MySQL Database Access MCP Server のツール

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

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

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is MySQL Database Access MCP Server?

This MCP server provides read-only access to MySQL databases. It allows listing databases, listing tables, describing table schemas, and executing read-only SQL queries. It is designed for developers who need safe, read-only database exploration and querying via the Model Context Protocol.

How to use MySQL Database Access MCP Server?

Install globally via npm install -g mysql-mcp-server or locally. Configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE). Add the server to your MCP settings file using either npx mysql-mcp-server (npm install) or node /path/to/build/index.js (build from source).

Key features of MySQL Database Access MCP Server

Read-only access: only SELECT, SHOW, DESCRIBE, EXPLAIN allowed
Query validation prevents SQL injection and data modification
Query timeout prevents long-running queries
Row limit prevents excessive data return
Tools: list_databases, list_tables, describe_table, execute_query

Use cases of MySQL Database Access MCP Server

Exploring database structure (list tables, describe schemas)
Running safe, read-only analytics queries
Integrating MySQL data with AI assistants via MCP
Checking database content without write risk

よくある質問

What dependencies does this server require?

Node.js and npm. A MySQL database server accessible via the provided credentials is also required.

How is authentication handled?

Authentication uses environment variables: `MYSQL_USER`, `MYSQL_PASSWORD`, and optionally `MYSQL_HOST` and `MYSQL_PORT`.

What security restrictions are in place?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Query validation blocks injection and data modification attempts. A query timeout and row limit protect resources.

Do I need to set up a MySQL user with specific permissions?

Yes. Your MySQL user must have appropriate permissions to list databases, list tables, describe schemas, and execute read-only queries on the target databases.