MCP.so
ログイン

Smithery AI에 등록하는 방법을 알기 위해서 다음 사이트의 코드를 한글로만 바꿔서 올렸습니다.

@aqara-docs

リポジトリ

Smithery AI에 등록하는 방법을 알기 위해서 다음 사이트의 코드를 한글로만 바꿔서 올렸습니다. について

概要はまだありません

#mysql#mcp-server#database-communication

基本情報

カテゴリ

メモリとナレッジ

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

aqara-docs

設定

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

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

ツール

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

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

概要

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) implementation that enables safe, structured interaction between AI applications (hosts/clients) and MySQL databases. It is designed as a communication protocol component, not a standalone server, to facilitate database exploration and analysis through a controlled interface.

How to use MySQL MCP Server?

Install via pip (pip install mysql-mcp-server) or automatically via Smithery for Claude Desktop. Configure required environment variables: MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, and optionally MYSQL_PORT (default 3306). Add the server configuration to your AI client’s settings (e.g., claude_desktop_config.json for Claude Desktop or mcp.json for VS Code). For debugging, use the MCP Inspector instead of running the Python script directly.

Key features of MySQL MCP Server

  • Lists available MySQL tables as resources
  • Reads table contents for analysis
  • Executes SQL queries with proper error handling
  • Secure database access via environment variables
  • Comprehensive logging for monitoring

Use cases of MySQL MCP Server

  • AI-powered database exploration and querying
  • Controlled data analysis within a safe interface
  • Automated database interaction in AI applications
  • Secure integration of MySQL with AI assistants

FAQ from MySQL MCP Server

Is MySQL MCP Server meant to run standalone?

No, it is designed as a communication protocol implementation between AI applications and MySQL databases, not as a standalone server.

What environment variables are required?

You must set MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE. Optionally set MYSQL_PORT (default 3306).

How do I install MySQL MCP Server?

Install via pip: pip install mysql-mcp-server. For Claude Desktop, you can also use Smithery: npx -y @smithery/cli install mysql-mcp-server --client claude.

What are the security best practices?

Use a dedicated MySQL user with minimal privileges, never use root credentials, restrict access to necessary operations, enable logging, and perform regular security reviews.

How can I debug MySQL MCP Server?

Use the MCP Inspector tool. Do not try to run the server as a standalone Python program.

コメント

「メモリとナレッジ」の他のコンテンツ

Notion MCP Server

makenotion

Official Notion MCP Server

4.5K

Memory

modelcontextprotocol

Model Context Protocol Servers

88.1K

Notion MCP Server

suekou

A Model Context Protocol server for connecting Notion to MCP-compatible clients

910

🧠 Ultimate MCP Server

Dicklesworthstone

Comprehensive MCP server exposing dozens of capabilities to AI agents: multi-provider LLM delegation, browser automation, document processing, vector ops, and cognitive memory systems

154

MemoryMesh

CheMiguel23

A knowledge graph server that uses the Model Context Protocol (MCP) to provide structured memory persistence for AI models.

348