@enemyrr/MCP Mysql Server

@enemyrr

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

enemyrr

@enemyrr/MCP Mysql Server について

概要はまだありません

@enemyrr/MCP Mysql Server の設定

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

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

@enemyrr/MCP Mysql Server のツール

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

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

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

概要

What is @enemyrr/mcp-mysql-server?

A Model Context Protocol (MCP) server that enables AI models to interact with MySQL databases through a standardized interface. This server provides SQL query execution, schema management, and database exploration, all controllable via MCP tools.

How to use @enemyrr/mcp-mysql-server?

Install via Smithery (npx -y @smithery/cli install @enemyrr/mcp-mysql-server --client claude) or clone and build manually. Configure database connection using a DATABASE_URL in .env, individual environment variables, or pass credentials directly via the connect_db tool. After connecting, use available tools such as query, execute, list_tables, and describe_table.

Key features of @enemyrr/mcp-mysql-server

14 database tools for queries and schema management
MCP Resources for browsing database schema
MCP Prompts for generating SQL queries
Multiple connection methods (URL, workspace, direct)
Secure prepared statements to prevent SQL injection
Automatic connection cleanup after use

Use cases of @enemyrr/mcp-mysql-server

AI assistants executing SQL SELECT queries and returning results
Automated schema management: create, alter, or drop tables and columns
Database exploration: list tables, describe structures, view indexes and foreign keys
Generating SQL templates for common operations (SELECT, INSERT, UPDATE)
Obtaining natural language explanations of database schema

よくある質問

How do I connect to a MySQL database?

You can connect via a database URL in `.env`, individual host/user/password environment variables, or directly through the `connect_db` tool’s arguments (URL, workspace path, or credentials).

How does the server prevent SQL injection?

All queries support prepared statements, and the server validates queries before execution, using parameterized inputs to prevent injection.

What tools are available for schema changes?

Tools include `create_table`, `add_column`, `alter_column`, `drop_column`, `drop_table`, and `truncate_table`. Destructive operations require a confirmation flag.

What MCP resources are exposed?

Resources are provided under URIs like `mysql://schema` (database overview), `mysql://tables` (list tables), `mysql://tables/{name}` (table details), and `mysql://tables/{name}/columns`, `indexes`, `sample` for column definitions, indexes, and sample rows.