広告掲載
MCP.so
ログイン

MySQL MCP Server

@affannahmed

リポジトリ

基本情報

カテゴリ

AI とエージェント

ライセンス

MIT license

トランスポート

stdio

作者

affannahmed

MySQL MCP Server について

概要はまだありません

#mysql#mcp-server#ai-integration

MySQL MCP Server の設定

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

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

MySQL MCP Server のツール

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

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

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

概要

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

よくある質問

1

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.

2

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.

3

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.

4

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`.

コメント

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

BlazingCDN MCP - Content Delivery for Video, Software & Static Files

BlazingCDN

Official MCP server for BlazingCDN - AI agents (Claude, Cursor, Windsurf) manage CDN resources, purge cache, query metrics, domains, Anycast CDN, Video CDN and Media CDN

1

Transform MCP

Unstructured

The Unstructured Transform MCP Server connects your ADK agent to Unstructured, a document processing platform that turns raw files into structured, AI-ready data. This integration gives your agent the ability to parse PD

HeyLead: LinkedIn Outreach & Lead Generation MCP Server

D4umak

HeyLead: AI agent for LinkedIn outreach. Finds the right people, writes in your voice, follows up and handles replies, from Claude Code, Cursor, any MCP client or a web dashboard.

9

Gemina

Gemina Tech Ltd.

Extract, search and tag any document — invoices, receipts, contracts, forms, or your own templates. 13 tools, one sign-in (OAuth 2.1) or API key, free FileTag tier, data residency in the EU, US, Israel or Asia.

treg.to

Jason Zhou

OpenRouter for tools & data — 3,028 APIs for your agent, one token, pay per call. treg.to is a remote MCP server at https://treg.to/mcp/ that gives an agent 3,028 ready-to-call API endpoints across 82 platforms: SEO and

広告掲載