MySQL Database Access MCP Server

@shensiqi0701

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

shensiqi0701

MySQL Database Access MCP Server について

概要はまだありません

MySQL Database Access MCP Server の設定

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

{
  "mcpServers": {
    "mysql-mcp-server-modification": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@dpflucas/mysql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

MySQL Database Access MCP Server のツール

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

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

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

概要

What is MySQL Database Access MCP Server?

A read-only MCP server that provides tools to interact with MySQL databases, including listing databases, listing tables, describing table structures, and executing read-only SQL queries.

How to use MySQL Database Access MCP Server?

Install via npm (npm install -g @valuprosys/mysql-mcp-server), set the required environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and optionally MYSQL_DATABASE), then add the server configuration to your MCP client config under mcpServers.mysql.

Key features of MySQL Database Access MCP Server

List all accessible databases on the MySQL server
List tables within a specified database
Describe table structure including column comments
Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)

Use cases of MySQL Database Access MCP Server

Querying database metadata without writing full SQL
Exploring table schemas during development or debugging
Performing safe, read-only data lookups from an AI assistant

よくある質問

What queries are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted. Other SQL statements will be rejected.

What environment variables are required?

`MYSQL_HOST`, `MYSQL_PORT` (default 3306), `MYSQL_USER`, and `MYSQL_PASSWORD` must be set. `MYSQL_DATABASE` (default database name) is optional.

How do I configure the server with my MCP client?

Add the following to your MCP configuration under `mcpServers.mysql`: command `npx`, args `["@valuprosys/mysql-mcp-server"]`, and the necessary environment variables.

Does the server modify data?

No. The server is strictly read-only and only accepts SELECT, SHOW, DESCRIBE, and EXPLAIN queries.

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

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.