MySQL Database Access MCP Server

Name: MySQL Database Access MCP Server
Author: MCP-Mirror

@MCP-Mirror

リポジトリ

MySQL Database Access MCP Server について

Mirror of

#mysql #database #mcp-server

基本情報

カテゴリ

データベース

ライセンス

MIT license

ランタイム

node

トランスポート

stdio

公開者

MCP-Mirror

設定

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

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

ツール

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

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

概要

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

FAQ from MySQL Database Access MCP Server

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.