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
Docs MCP Server
araboldGrounded Docs MCP Server: Open-Source Alternative to Context7, Nia, and Ref.Tools
JupyterMCP - Jupyter Notebook Model Context Protocol Integration
jjsantos01A Model Context Protocol (MCP) for Jupyter Notebook
MCP Apple Notes
RafalWilinskiTalk with your notes in Claude. RAG over your Apple Notes using Model Context Protocol.
Ultimate Google Docs & Drive MCP Server
a-bonusThe Ultimate Google Docs, Sheets, Drive, Gmail, & Google Calendar MCP Server. This MCP (primarily for use in Claude Desktop) gains full access to your google suite and lets claude do its thing.
Obsidian MCP Server
StevenStavrakisA simple MCP server for Obsidian
Comments