蔬菜行情查询
MCP 服务配置
复制以下 JSON 到 OPClaw 或其他 MCP 客户端的配置文件中即可使用
{
"mcpServers": {
"vegetable_price_mcp": {
"args": [],
"command": "python app.py",
"env": {}
}
}
}
该服务需要配置环境变量:MYSQL_DATABASE、MYSQL_HOST、MYSQL_PASSWORD、MYSQL_USER
服务介绍
MySQL Vegetable Price MCP Server
This lightweight MCP server exposes the company and vegetable_price tables so tools can query markets and price history via the Model Context Protocol.
Features
list_markets(limit)– recent entries fromcompany(returns{description, data}).search_market(keyword)– fuzzy search on market names (returns{description, data}).recent_prices(market_id, limit)– latest price rows for a given market id (returns{description, unit, data}and every row containsunit).query_price(...)– keyword and date filtered lookup across the joined tables (returns{description, unit, data}and every row containsunit).