MCP.so
ログイン

MySQL MCP Server

@affannahmed

リポジトリ

MySQL MCP Server について

概要はまだありません

#mysql#mcp-server#ai-integration

基本情報

カテゴリ

AI とエージェント

ライセンス

MIT license

ランタイム

python

トランスポート

stdio

公開者

affannahmed

設定

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

{
  "mcpServers": {
    "MCP-Server-with-Claude-Ai": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "mysql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

ツール

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

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

概要

What is MySQL MCP Server?

A Model Context Protocol (MCP) implementation that enables secure interaction between AI applications and MySQL databases through a controlled interface, making database exploration and analysis safer and more structured.

How to use MySQL MCP Server?

Install via pip install mysql-mcp-server or automatically through Smithery. Configure by setting environment variables for MySQL host, port, user, password, and database. Integrate with Claude Desktop by adding the server configuration to claude_desktop_config.json.

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

  • Exploring database schemas by listing tables
  • Analyzing data by reading table contents
  • Running controlled SQL queries through AI applications

FAQ from MySQL MCP Server

Can MySQL MCP Server be run as a standalone server?

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

What are the dependencies and runtime requirements?

The server requires Python and can be installed via pip. It expects a running MySQL database accessible via environment variable configuration.

How is database access secured?

Access is configured through environment variables for host, port, user, password, and database. The README recommends creating a dedicated MySQL user with minimal permissions and never using root credentials.

What installation methods are available?

Manual installation via pip install mysql-mcp-server or automatic installation for Claude Desktop via Smithery using npx -y @smithery/cli install mysql-mcp-server --client claude.

What data does the server access and where does it live

コメント

「AI とエージェント」の他のコンテンツ

Mcp Agent

lastmile-ai

Build effective agents using Model Context Protocol and simple workflow patterns

8.4K

Model Context Protocol Server for Home Assistant

tevonsb

A MCP server for Home Assistant

574

MCP Server - Remote MacOs Use

baryhuang

The only general AI agent that does NOT requires extra API key, giving you full control on your local and remote MacOs from Claude Desktop App

487

MCP Client for Ollama (ollmcp)

jonigl

Harness the power of local LLMs with this TUI MCP Client for Ollama. Featuring all core MCP primitives (tools, prompts, resources), agent mode, multi-server, model switching, streaming responses, human-in-the-loop, thinking mode, model params config, system prompts, and saved pre

768

MCP-NixOS - Because Your AI Assistant Shouldn't Hallucinate About Packages

utensils

MCP-NixOS - Model Context Protocol Server for NixOS resources

739