广告合作
MCP.so
登录

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

@aqara-docs

代码仓库

基本信息

分类

记忆与知识

许可证

MIT

传输方式

stdio

作者

aqara-docs

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

暂无概览

#mysql#mcp-server#database-communication

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

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

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

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

1

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.

2

What environment variables are required?

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

3

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

4

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.

5

How can I debug MySQL MCP Server?

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

评论

记忆与知识 分类下的更多 MCP 服务器

Semantic Ui React

Semantic-Org

The official Semantic-UI-React integration

13.2K

M1K3

Round-Tower

Local AI agent for your Mac with a built-in MCP server: 18 tools for your notes and PDFs, a temporal memory graph, an on-device LLM and a neural voice. No account, no telemetry. No data centers required.

7

Neither MCP

stonianua

Project context your AI can query through MCP — with source evidence.

UmmahAPI

Yousuf Kazmi

Islamic source data for assistants: Quran, hadith, tafsir, duas, prayer times and qibla. Answers come from real sources with citations instead of recalled text, so verses and hadith are not hallucinated. 36,000+ hadiths

agentleFS

agentleFS

One permissioned folder your team and your AI agents both log into.

广告合作