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`.
Mysql Mcpserver Stdio MCP Server
@lanjunfei
Basic information
About Mysql Mcpserver Stdio MCP Server
批量生成基于mysql数据库的mcpserver,支持stdio传输。Generate MCP servers in batch based on MySQL database, supporting stdio transmission.
Mysql Mcpserver Stdio MCP Server config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryMysql Mcpserver Stdio 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.
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
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_databasefunction 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.
Frequently asked questions
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).
How can I test the generated server?
Use MCP Inspector to verify that the tool functions are called correctly.
What MCP client is recommended?
Cherry Studio is recommended for its convenience.
What default function is included in every generated server?
A `check_database` function that checks the database connection is included by default.
More Databases MCP servers
MCP Alchemy
runekaagaardA 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
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
3.1K
Local YDB MCP
astandrikSafety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.
4
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
1.9K
golfdata.online - Verified Golf Clubs
golfdata.onlineVerified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes
Comments