広告掲載
MCP.so
ログイン

Mysql Mcpserver Stdio MCP Server

@lanjunfei

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

lanjunfei

Mysql Mcpserver Stdio MCP Server について

批量生成基于mysql数据库的mcpserver,支持stdio传输。Generate MCP servers in batch based on MySQL database, supporting stdio transmission.

#mysql#mcpserver#batch-generation

Mysql Mcpserver Stdio MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

Mysql Mcpserver Stdio MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is mysql_mcpserver_stdio?

mysql_mcpserver_stdio is a Flask-based Python tool that generates MCP server files in batch based on a MySQL database, supporting stdio transmission. It is intended for users who need to quickly create multiple MCP server files that query MySQL databases.

How to use mysql_mcpserver_stdio?

Create a virtual environment, install the dependencies from requirments.txt, and run python app.py. Open a browser to 127.0.0.1:5000 to access the server file generation page. Input the MySQL parameters (IP, port, username, password, database name), specify a file name ending with .py, and the tool generates a Python MCP server file. Then use the tool function addition page to define custom SQL queries and optional output formatting. The generated server can be tested with MCP Inspector and used with any stdio‑compatible MCP client.

Key features of mysql_mcpserver_stdio

  • Batch generation of MCP server files from MySQL databases.
  • Default check_database function for database connection verification.
  • Custom tool functions with user‑defined SQL statements and output formatting.
  • Compatible with stdio transmission protocol.
  • Testable with MCP Inspector.
  • Recommended client: Cherry Studio.

Use cases of mysql_mcpserver_stdio

  • Rapidly create multiple MCP servers for different MySQL databases.
  • Generate query‑only MCP tools for database maintenance teams.
  • Prototype MCP‑based SQL interfaces without manual coding.
  • Build a library of reusable MySQL query services for AI assistants.

よくある質問

1

What parameters are needed to generate a server?

You need the MySQL IP, port, username (preferably a dedicated account), password, and database name. The generated server file name must include `.py`.

2

How to add custom tool functions?

On the tool function addition page, enter a function name and a SQL statement. Optionally, specify the output format using the example template (aligning `content.append(...)` with a four‑space indent).

3

How can I test the generated server?

Use MCP Inspector to verify that the tool functions are called correctly.

4

What MCP client is recommended?

Cherry Studio is recommended for its convenience.

5

What default function is included in every generated server?

A `check_database` function that checks the database connection is included by default.

コメント

「データベース」の他のコンテンツ

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Elasticsearch MCP Server

elastic

685

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412
広告掲載