MCP.so
ログイン

MySQL Database Access MCP Server

@allizwellai

基本情報

カテゴリ

データベース

最終更新

ライセンス

MIT license

トランスポート

stdio

作者

allizwellai

MySQL Database Access 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?

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

よくある質問

1

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).

2

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.

3

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.

4

What environment variables are required?

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

5

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.

コメント

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