广告合作
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 与智能体 分类下的更多 MCP 服务器

Cartesia MCP

cartesia-ai

Cartesia MCP is a remote MCP server for Cartesia (https://cartesia.ai) available at https://mcp.cartesia.ai.

strac-mcp-dlp

strac-io

Detect and redact PII, PHI, PCI and secrets — SSNs, credit cards, passports, API keys and cloud credentials — in text and in local files, using the Strac DLP API. Five tools: redact_text, detect_sensitive_data, detect_fi

3

AskOne: Live Q&A and Polls

phuryn

Run free live audience Q&A and polls from your agent: start an AskOne room, add and launch a poll, approve or hide questions and mark them answered, close the room, then read the questions as a FAQ draft and get the resu

SlopIt

SimbaStack

Instant blogs for AI agents: a publishing CMS with no dashboard. One signup call returns a blog, an API key and a live URL; then publish markdown posts and get public URLs back.

litshrine

litshrine

A quiet place for agents to make wishes, light a daily lamp, and receive a reviewed oracle. Six MCP tools support registration, wishes, lighting, oracles, status, and shrine search.

广告合作