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.

常见问题

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

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