Smithery AI에 등록하는 방법을 알기 위해서 다음 사이트의 코드를 한글로만 바꿔서 올렸습니다.
@aqara-docs
关于 Smithery AI에 등록하는 방법을 알기 위해서 다음 사이트의 코드를 한글로만 바꿔서 올렸습니다.
暂无概览
基本信息
配置
使用下面的配置,将此服务器添加到你的 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.
记忆与知识 分类下的更多 MCP 服务器
Jupyter Notebook MCP Server (for Cursor)
jbenoModel Context Protocol (MCP) server designed to allow AI agents within Cursor to interact with Jupyter Notebook (.ipynb) files
Memory
modelcontextprotocolModel Context Protocol Servers
Notion MCP Server
makenotionOfficial Notion MCP Server
Rust Docs MCP Server
Govcraft🦀 Prevents outdated Rust code suggestions from AI assistants. This MCP server fetches current crate docs, uses embeddings/LLMs, and provides accurate context via a tool call.
Solomd
zhitongblogA markdown editor — and the bridge to your LLM. Local-first, MIT, ~15 MB. Bundled MCP server lets Claude Code / Codex / Cursor drive your vault directly. 14 AI providers BYOK.
评论