广告合作
MCP.so
登录

MCP Server

@zll1203763934

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

zll1203763934

关于 MCP Server

暂无概览

#mcp-server#server#backend

MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-server-zll1203763934": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        "venv"
      ]
    }
  }
}

MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) integration server that enables Trae AI agents to interact with a MySQL database safely. It is designed for developers and AI users who need to execute SQL queries, inspect schema, and manage database operations through an MCP-compatible interface.

How to use MySQL MCP Server?

Install dependencies via pip install -r requirements.txt, edit config.json with database credentials and security rules, then start the server with python server.py. In the Trae IDE, add this server as a custom MCP server using the local URL (typically http://localhost:8000).

Key features of MySQL MCP Server

  • Secure connection to MySQL databases
  • Execute SQL queries and return results
  • Database schema inspection (tables, structure, relationships)
  • Configurable access control (allowed tables, operations, max rows)
  • Complete error handling and logging
  • Designed for integration with Trae AI IDE

Use cases of MySQL MCP Server

  • Query and analyze database records using natural language via Trae
  • Create, update, or inspect tables and schema without manual SQL
  • Generate reports from sales or other data with AI guidance
  • Automate routine database tasks with safety limits
  • Secure multi-user database access through allowed‑operation lists

常见问题

1

What runtime or dependencies does MySQL MCP Server require?

Python 3 and the packages listed in `requirements.txt` are required. The server runs as a Python process.

2

Where does the data reside?

All data is stored in the connected MySQL database; the server itself does not store data. It only queries and returns results through the MCP interface.

3

What transport protocol does the server use?

The server uses HTTP (local URL `http://localhost:8000`) as the transport for MCP communication.

4

How does authentication and access control work?

Authentication is configured in `config.json` with database credentials (host, port, user, password). Access is further restricted by `allowed_tables`, `allowed_operations` (e.g., SELECT, INSERT, UPDATE), and a `max_rows` limit. Security warnings advise against using default settings in production.

5

Are there any known limits?

Yes; the configurable `max_rows` setting limits the number of rows returned per query. The server also enforces allowed tables and operations to prevent unauthorised actions.

评论

其他 分类下的更多 MCP 服务器

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K
广告合作