goofish-price-mcp
Reads an ai-goofish-monitor SQLite database in read-only mode to query Xianyu second-hand market price statistics, recent listings, market overviews, and watch task details.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@goofish-price-mcp DDR4 16G 现在什么行情?有低于 300 的吗?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
goofish-price-mcp
把 ai-goofish-monitor 积累的闲鱼行情数据暴露成 MCP(Model Context Protocol)工具,让任意 AI Agent(Claude Desktop / Cursor / Cline / 本地 harness…)直接查询二手价格、历史趋势和蹲守结果。
Read-only MCP server that exposes Xianyu (Goofish) second-hand market prices collected by ai-goofish-monitor watch tasks.
它解决什么问题
ai-goofish-monitor 在浏览器里 7×24 蹲守关键词,把每次搜索页看到的挂牌价存进本地 SQLite。 本项目只读这份数据库(不碰网站、零风控风险、毫秒级响应),把它翻译成 Agent 友好的工具:
你:“DDR4 16G 现在什么行情?有没有低于 300 的单条?” Agent 调
get_price_stats("DDR4")+latest_items("DDR4", max_price=300)→ 直接给出均价、趋势和具体商品链接。
Related MCP server: dbridge-mcp
Tools
Tool | 说明 |
| 行情统计:均价/中位/最低/最高、按天趋势、最便宜的 5 条商品(含链接)。关键词模糊匹配 |
| 最近蹲到的在售商品明细(标题/价格/链接/卖家/发布时间) |
| 所有已监控关键词的行情速览 |
| 蹲守任务清单(关键词、价格区间、cron、判定模式、已入库数量) |
样本口径:
get_price_stats的数据 = 监控任务在其搜索条件(价格区间/个人闲置等筛选)下每次运行实际看到的挂牌价,会受任务筛选条件影响,不等于全网成交均价。
Quick start
前置:本机已部署 ai-goofish-monitor 且至少跑过一个蹲守任务(产生 data/app.sqlite3)。
pip install -e . # 或 uv pip install -e .
export GOOFISH_DB_PATH=/path/to/ai-goofish-monitor/data/app.sqlite3
goofish-price-mcp # stdio MCP server,打印 DB 路径到 stderr 后等待连接接入 MCP 客户端(以 Claude Desktop / 通用 mcpServers 配置为例):
{
"mcpServers": {
"goofish-price": {
"command": "/path/to/venv/bin/goofish-price-mcp",
"env": { "GOOFISH_DB_PATH": "/path/to/ai-goofish-monitor/data/app.sqlite3" }
}
}
}DB 路径解析顺序:GOOFISH_DB_PATH → ./data/app.sqlite3 → /app/data/app.sqlite3 → ~/.ai-goofish/data/app.sqlite3。
Development
python tests/test_queries.py # 内存库单元测试,无外部依赖只读连接(file:...?mode=ro)与监控进程的 WAL 写入共存,不会阻塞爬虫。
Roadmap (v0.2+)
refresh_price(keyword):按需现抓一屏实时价(复用登录态 + 进程锁排队)add_watch_task(keyword, max_price):Agent 一句话建立新蹲守任务PyPI 发布(
uvx goofish-price-mcp)
License
MIT · 数据归属其来源(闲鱼页面公开展示信息),本项目仅供学习研究。
Available Tools
4 toolsget_price_statsA
查询某关键词的闲鱼二手行情:均价/中位/最低价、按天价格趋势、最便宜的商品链接。
keyword 支持模糊匹配(如 "DDR4");days 为回看天数(1-365)。 样本 = 监控任务在搜索条件下每次运行实际看到的挂牌价。
Inputs: keyword (required), days. Returns: object
latest_itemsA
列出最近蹲到的在售商品明细(标题/价格/链接/卖家/发布时间),按抓取时间倒序。
可按关键词、价格区间过滤;recommended_only=True 只看判定为推荐的商品。
Inputs: limit, keyword, max_price, min_price, +1 more. Returns: object
list_watch_tasksB
列出监控端的蹲守任务(关键词、价格区间、cron、判定模式、已入库数量)。
Inputs: no named parameters. Returns: object
market_overviewA
所有已监控关键词的行情速览:最近一天均价/最低价、累计样本量、运行时间。
Inputs: no named parameters. Returns: object
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 4 tools
Each tool has a reasonably distinct target: per-keyword deep stats, per-item listing, cross-keyword snapshot, and task listing. The only soft overlap is between get_price_stats and market_overview, which both return aggregate prices (one deep per keyword, one shallow across all); descriptions clarify the split but an agent could still pick the wrong one for a quick check.
All names are snake_case, but the conventions are mixed: get_price_stats and list_watch_tasks use verb_noun while latest_items and market_overview are bare noun phrases. It remains readable, but the set does not follow a single predictable pattern.
Four tools is on the lean side but each covers a distinct query surface (stats, items, overview, tasks) with no filler. It is appropriately scoped for a read/query-oriented price monitoring server.
The read side is covered (stats, item lists, overview, task listing), but the monitoring lifecycle is incomplete: list_watch_tasks exists with no create_watch_task, update, or delete counterpart, so an agent cannot start or stop monitoring a keyword. No tool exposes per-item history or cross-keyword comparison either.
Maintenance
Related MCP Connectors
Read-only Google Search Console MCP server for AI assistants.
Read-only MCP server for The Quiet Protocol's engines, benchmarks, proof, and business data.
Agent-native MCP server over the public saagarpatel.dev corpus. Read-only, stateless.
Related MCP Servers
- AlicenseAqualityBmaintenanceRead-only MCP server for querying PostgreSQL, MySQL, and SQLite from AI agents — multi-database, safe by default.4268 npm1ISC
- AlicenseAqualityCmaintenanceRead-only MCP server that lets AI agents safely query SQLite, PostgreSQL, and MySQL/MariaDB. Enforces read-only transactions with column masking, row caps, query timeouts, EXPLAIN-based cost rejection, and rate limiting.734 npm2MIT
- AlicenseNot gradedqualityCmaintenanceRead-only MCP server for SQLite databases, enabling AI assistants to safely query and inspect database schemas without write access.MIT
- FlicenseAqualityDmaintenanceA local MCP server that enables querying Amazon Selling Partner API for profitability analysis (revenue, fees, COGS, net margin) and inventory alerts (FBA stock levels and low-stock warnings) using read-only operations.9-