MySQL MCP Server

Name: MySQL MCP Server
Author: he426100

@he426100

リポジトリ

MySQL MCP Server について

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

基本情報

カテゴリ

データベース

ライセンス

MIT license

ランタイム

php

トランスポート

stdio

公開者

he426100

設定

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

{
  "mcpServers": {
    "mysql-mcp-server-he426100": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mysql-mcp-server",
        "."
      ]
    }
  }
}

ツール

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

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

概要

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) server that enables secure interaction with MySQL databases. It allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.

How to use MySQL MCP Server?

Clone the repository, install dependencies with Composer, and set environment variables for database connection (DB_HOST, DB_PORT, DB_USERNAME, DB_PASSWORD, DB_DATABASE). Run as a standalone server with php bin/console or via Docker.

Key features of MySQL MCP Server

List available MySQL tables as resources
Read table contents
Execute SQL queries with proper error handling
Secure database access through environment variables
Comprehensive logging

Use cases of MySQL MCP Server

AI-assisted database exploration and schema discovery
Controlled read and query access for AI assistants
Secure, logged database interaction in development environments
Automated data retrieval and analysis workflows

FAQ from MySQL MCP Server

How does MySQL MCP Server ensure security?

It uses environment variables for credentials, recommends creating a dedicated MySQL user with minimal permissions, never uses root credentials, and enables logging for audit purposes.