@f4ww4z/mcp-mysql-server

Name: @f4ww4z/mcp-mysql-server
Author: f4ww4z

@f4ww4z

リポジトリ

@f4ww4z/mcp-mysql-server について

A Model Context Protocol server for MySQL database operations

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

node

トランスポート

stdio

公開者

f4ww4z

設定

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

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

ツール

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

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

概要

What is @f4ww4z/mcp-mysql-server?

@f4ww4z/mcp-mysql-server is a Model Context Protocol server that provides MySQL database operations. It enables AI models to interact with MySQL databases through a standardized interface.

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

Install via Smithery (npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude) or manually (npx @f4ww4z/mcp-mysql-server). Configure it in your MCP settings file using either a MySQL connection string (mysql://user:password@localhost:port/database) or environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE). Then use the provided tools to connect, query, execute statements, list tables, and describe tables.

Key features of @f4ww4z/mcp-mysql-server

Secure connection handling with automatic cleanup
Prepared statement support for query parameters
Comprehensive error handling and validation
TypeScript support
Automatic connection management
Support for SELECT, INSERT, UPDATE, and DELETE queries

Use cases of @f4ww4z/mcp-mysql-server

AI models querying MySQL databases using natural language
Automated database migrations and data manipulation
Dynamic table discovery and schema exploration
Secure read/write access to MySQL from AI workflows

FAQ from @f4ww4z/mcp-mysql-server

How do I install @f4ww4z/mcp-mysql-server?

You can install it via Smithery (npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude) or manually (npx @f4ww4z/mcp-mysql-server).

How do I configure the MySQL connection?

Pass a MySQL connection string as an argument (mysql://user:password@localhost:port/database) or set the environment variables MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in your MCP settings file.

What tools does this server provide?

It provides five tools: connect_db, query (SELECT statements), execute (INSERT, UPDATE, DELETE statements), list_tables, and describe_table.

How does the server handle security?

It uses prepared statements to prevent SQL injection, supports secure password handling through environment variables, validates queries before execution, and automatically closes connections when done.

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

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245