MCP.so
Sign In

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

@aqara-docs

Repository

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

No overview available yet

#mysql#mcp-server#database-communication

Basic information

Category

Memory & Knowledge

License

MIT

Runtime

python

Transports

stdio

Publisher

aqara-docs

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.

Comments

More Memory & Knowledge MCP servers

Docs MCP Server

arabold

Grounded Docs MCP Server: Open-Source Alternative to Context7, Nia, and Ref.Tools

1.5K

MemoryMesh

CheMiguel23

A knowledge graph server that uses the Model Context Protocol (MCP) to provide structured memory persistence for AI models.

348

mcp-local-rag

nkapila6

"primitive" RAG-like web search model context protocol (MCP) server that runs locally. ✨ no APIs ✨

128

MCP Apple Notes

RafalWilinski

Talk with your notes in Claude. RAG over your Apple Notes using Model Context Protocol.

401

Basic Memory

basicmachines-co

AI conversations that actually remember. Never re-explain your project to your AI again. Join our Discord: https://discord.gg/tyvKNccgqN

3.4K