Smithery AI에 등록하는 방법을 알기 위해서 다음 사이트의 코드를 한글로만 바꿔서 올렸습니다.
@aqara-docs
About Smithery AI에 등록하는 방법을 알기 위해서 다음 사이트의 코드를 한글로만 바꿔서 올렸습니다.
No overview available yet
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mysql-mcp-server-aqara-docs": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mysql-mcp-server",
"--client",
"claude"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
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.
More Memory & Knowledge MCP servers
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
MCP server for Obsidian
MarkusPfundsteinMCP server that interacts with Obsidian via the Obsidian rest API community plugin
Obsidian MCP Server
StevenStavrakisA simple MCP server for Obsidian
Context7 MCP - Up-to-date Docs For Any Cursor Prompt
upstashContext7 Platform -- Up-to-date code documentation for LLMs and AI code editors
Semantic Scholar MCP Server
YUZongminA FastMCP server implementation for the Semantic Scholar API, providing comprehensive access to academic paper data, author information, and citation networks.
Comments