MySQL Database Access MCP Server

@dpflucas

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

dpflucas

MySQL Database Access MCP Server について

An MCP server provides read-only access to MySQL databases.

MySQL Database Access MCP Server の設定

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

{
  "mcpServers": {
    "mysql-mcp-server": {
      "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?

This MCP server provides read-only access to MySQL databases, allowing users to list databases, list tables, describe schemas, and execute safe SQL queries. It is designed for AI assistants and tools that need to inspect or query MySQL data without modification.

How to use MySQL Database Access MCP Server?

Install via npm (npm install -g mysql-mcp-server), build from source, or use Smithery. Configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) and add the server to your MCP settings file. Once connected, invoke the tools list_databases, list_tables, describe_table, or execute_query with the required parameters.

Key features of MySQL Database Access MCP Server

Read-only access to MySQL databases
Query validation against injection and modification
Query timeout and row limit protection
Tools: list databases, list tables, describe schema
Execute SELECT, SHOW, DESCRIBE, EXPLAIN queries
Advanced connection pool configuration

Use cases of MySQL Database Access MCP Server

Exploring database structure (tables, schemas) via an AI assistant
Retrieving read-only data for analysis or reporting
Inspecting table schemas before integration or migration
Debugging queries without risk of accidental writes

よくある質問

What types of queries are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted. All other statements are blocked for safety.

What environment variables are required?

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

How do I install the server?

Install globally from npm (`npm install -g mysql-mcp-server`), locally in a project, build from source, or use the Smithery CLI.

Are there any limits on queries?

Yes: a query timeout prevents long-running queries, and a row limit prevents excessive data return. The connection pool is also configurable.

Can I write or modify data?

No. The server enforces read-only access; any attempt to execute INSERT, UPDATE, DELETE, or DDL statements is rejected.

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

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K