広告掲載
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.

コメント

「その他」の他のコンテンツ

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

広告掲載