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#batch-generation

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.

Repository

Mysql 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_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.

Frequently asked questions

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

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.

Comments

More Databases MCP servers

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note