Advertise
MCP.so
Sign In

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

@aqara-docs

Repository

Basic information

Category

Memory & Knowledge

License

MIT

Transports

stdio

Author

aqara-docs

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

No overview available yet

#mysql#mcp-server#database-communication

Smithery AI에 등록하는 방법을 알기 위해서 다음 사이트의 코드를 한글로만 바꿔서 올렸습니다. MCP Server 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"
      ]
    }
  }
}

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

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

Frequently asked questions

1

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.

2

What environment variables are required?

You must set `MYSQL_HOST`, `MYSQL_USER`, `MYSQL_PASSWORD`, and `MYSQL_DATABASE`. Optionally set `MYSQL_PORT` (default 3306).

3

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`.

4

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.

5

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

Scento Perfume API (MCP server): free fragrance API, no key

Scento

Scento Perfume API is a free fragrance API and perfume notes database for developers and AI agents. Search 1,500+ perfumes and 400+ ingredients, compare scents, find similar perfumes, map scent families and build occasio

Azquo

Azquo Holdings Ltd

Exact, shared memory for AI agents: a hierarchical database where totals always add up, every write is attributed to the agent and person behind it, and any figure traces back to its source file. Agents create databases,

Agimem

Persistent memory for AI agents. Hosted MCP server with capsule-scoped key/value storage, tags, TTL expiration, bulk ops, and RBAC.

Groundwork

Rarefied-Earth

Groundwork: company memory for your AI tools. Docs public. Source closed. Public proof needs no account.

1

OpenLore

aakarim

Serve your docs to AI agents over SSH and MCP. Agents use ls, cat, grep, find, and pipes against a virtual filesystem backed by your documentation. Identity-scoped access, governed writing with human approval, and portab

66
Advertise