Sponsored by Deepsite.site

mysql_mcpserver_stdio

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

mysql_mcpserver_stdio

mcp格式如此标准,一定可以批量制作server文件。
批量生成基于mysql数据库的mcpserver,支持stdio传输。Generate MCP servers in batch based on MySQL database, supporting stdio transmission.
语言python 前端FLASK
安装:虚拟环境安装requirments.txt.
运行:python app.py
浏览器输入地址:127.0.0.1:5000 进入server文件生成页面。输入mysql数据库参数,包括:ip,端口,用户名(最好专门建一个账号),密码,数据库名。生成的mcp server名,需要带.py。目录下生成py文件。默认自带check_database函数,检查数据库连接用的。
进入工具函数添加页面:输入你定义的工具函数名,SQL语句(mysql的mcpserver文件当然从查询工具开始),
SQL查询后的输出格式(可以不填)参考下面:
for row in rows:
content.append("设备账号: " + row['username'])
content.append("IPv4地址: " + row['user_ip4'])
content.append("MAC地址: " + row['user_mac'].replace(":", "-"))
注意对齐,content前面有四个空格。
生成的server文件可以先用MCP Inspector测试一下,看看工具调用是否正常。
mcp client就直接用现成的工具。推荐用cherrystudio,比较方便。

Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
Baidu Map百度地图核心API现已全面兼容MCP协议,是国内首家兼容MCP协议的地图服务商。
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
Playwright McpPlaywright MCP server
Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.
DeepChatYour AI Partner on Desktop
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
ChatWiseThe second fastest AI chatbot™
WindsurfThe new purpose-built IDE to harness magic
BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.
Amap Maps高德地图官方 MCP Server
TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
Tavily Mcp
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
CursorThe AI Code Editor
Howtocook Mcp基于Anduin2017 / HowToCook (程序员在家做饭指南)的mcp server,帮你推荐菜谱、规划膳食,解决“今天吃什么“的世纪难题; Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
Serper MCP ServerA Serper MCP Server
Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.