MySQL Database Access MCP Server

Name: MySQL Database Access MCP Server
Author: allizwellai

@allizwellai

リポジトリ

MySQL Database Access MCP Server について

概要はまだありません

基本情報

カテゴリ

データベース

ライセンス

MIT license

ランタイム

node

トランスポート

stdio

公開者

allizwellai

設定

以下の設定を使って、このサーバーを 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?

MySQL Database Access MCP Server provides read-only access to MySQL databases via the Model Context Protocol. It lets you list databases, list tables, describe table schemas, and execute read-only SQL queries. This server is designed for developers and AI agents who need to inspect MySQL schemas and query data without risk of modification.

How to use MySQL Database Access MCP Server?

Install globally via npm (npm install -g mysql-mcp-server) or build from source, then configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) and add the server configuration to your MCP settings file. Use the provided tools: list_databases, list_tables, describe_table, and execute_query.

Key features of MySQL Database Access MCP Server

Read‑only access: only SELECT, SHOW, DESCRIBE, and EXPLAIN allowed
Query validation prevents SQL injection and data modification
Query timeout prevents long‑running resource consumption
Row limit prevents excessive data return
Lists accessible databases, tables, and table schemas

Use cases of MySQL Database Access MCP Server

Exploring database structure without direct SQL access
Running analytical SELECT queries through an AI assistant
Verifying table schemas and column definitions
Auditing read‑only access for security‑sensitive environments

FAQ from MySQL Database Access MCP Server

What operations does MySQL Database Access MCP Server support?

It supports listing databases, listing tables, describing table schemas, and executing read‑only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN).

How do I install and configure the server?

Install from npm (npm install -g mysql-mcp-server) or build from source. Set environment variables for your MySQL connection (host, port, user, password, database) and add the server to your MCP settings file.

Can I modify data with this server?

No. The server enforces read‑only access; only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Data modification attempts are blocked.

What environment variables are required?

MYSQL_HOST, MYSQL_PORT, and MYSQL_USER are required. MYSQL_PASSWORD is optional but recommended. MYSQL_DATABASE is optional.

What happens if a query takes too long or returns too many rows?

The server has a query timeout to prevent long‑running queries from consuming resources and a row limit to prevent excessive data return.

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

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412