MCP.so
Sign In

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

@aqara-docs

Repository

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

No overview available yet

#mysql#mcp-server#database-communication

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

Fetch the live tool list by running this server in a temporary sandbox using the button above.

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.

Frequently asked questions

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

Basic information

Category

Memory & Knowledge

License

MIT

Transports

stdio

Author

aqara-docs

More Memory & Knowledge MCP servers

Context7 MCP - Up-to-date Docs For Any Cursor Prompt

upstash

Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors

58.7K

Memlord

MyrikLD

Memlord is a remote MCP server available at https://app.memlord.com.

Anytype MCP Server

anyproto

An MCP server enabling AI assistants to interact with Anytype - your encrypted, local and collaborative wiki - to organize objects, lists, and more through natural language.

467

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.

286

minutes

silverstein

Every meeting, every idea, every voice note — searchable by your AI. Open-source, privacy-first conversation memory layer.

1.3K