Runwaystock

io.github.GillMacedo由 GitHub 账号 GillMacedo 发布v0.2.0更新于 Nov 3, 2026

Find what to reorder, stockout dates and dead stock from sales and stock CSVs, on your machine.

已验证STDIO仅桌面数据与分析商业与电商

概览

AI 生成的概览

本地 MCP 服务器,读取销售与库存 CSV,按 SKU 计算补货点、补货数量、缺货日期和滞销库存。

可以做什么
  • 用销售 CSV 和库存 CSV 执行库存检查,按紧急程度返回每个 SKU 的状态和建议补货数量。
  • 检查不熟悉的 CSV,显示识别到的列和可读取的行数,但不返回行内容。
  • 状态包括立即补货、即将补货、正常、库存过多和无近期销售,并给出补货点、安全库存和缺货日期。
  • 两个工具均为只读,不会下单,也不访问网络。
适用场景
适合用电子表格做库存规划的电商店铺、零售商和小型企业,让助手回答该补什么货、补多少、哪些商品最先售罄,以及有多少资金压在滞销库存上。
运行要求
通过 stdio 在本机运行;用 npx 启动需要 Node.js,或用 Go 1.27 及以上版本自行构建二进制。无需账号、API 密钥或网络访问。需要销售 CSV 和库存 CSV,且至少 28 天销售历史才能得到较可靠的结果。
安装前请注意
检查工具会把 SKU 和数量返回给 MCP 客户端,因此会传到你所使用的 AI 模型;命令行方式则全部留在本机。结果只是估算:模型不考虑季节性、促销和缺货流失的销量,且仅在虚构数据上测试过,采购前请自行核实。仅支持 CSV,最大 50 MB。

安装

在 SourceWeft 中

  1. 打开 控制台中的 Runwaystock,将其添加到工作区。
  2. 为需要使用其工具的对话启用该服务。

Desktop only,通过 STDIO。 STDIO 服务会启动本地进程,因此需要 SourceWeft 桌面宿主。

其他 MCP 客户端

参照 仓库 中的启动说明。

README

runwaystock: inventory reorder points from your sales and stock files

[npm] [CI] [MIT license] [MCP Registry]

Know what to reorder, how much to buy, when each product runs out, and how much money is stuck in dead stock. For e-commerce stores, retailers and small businesses that plan inventory in spreadsheets.

Inventory planning software is expensive, and spreadsheet formulas break. runwaystock reads a sales export and a stock count as CSV files, and applies the standard reorder point and safety stock formulas to every SKU. It's an MCP server and a single Go binary, with no account, no API key and no network access.

What you can ask your agent

  • "What do I need to reorder this week, and how much?"
  • "Which products will run out first?"
  • "How much money is tied up in dead stock?"
  • "Which products am I overstocked on?"

Install

As a Claude Code plugin, which adds the MCP server and a skill that tells Claude when to use it. You need Node, which runs the server through npx:

claude plugin marketplace add GillMacedo/runwaystockclaude plugin install runwaystock@runwaystock-marketplace

For other MCP clients:

json
{  "mcpServers": {    "runwaystock": {      "command": "npx",      "args": ["-y", "runwaystock", "serve"]    }  }}

Or build the binary with Go 1.27 or newer:

go install github.com/GillMacedo/runwaystock@latest

Usage

Without installing anything, run npx runwaystock check sales.csv stock.csv. This example uses the made-up files in examples/:

$ go run . check examples/sales.csv examples/stock.csvAs of 2026-09-30, using 90 days of salesORDER NOW        WIDGET-RED: buy 93  costs 418.50  (40 on hand, 2.83 a day, out by 2026-10-14, reorder at 48)OK               MUG-LARGE  (70 on hand, 35 days left)OK               CAP-DEMO  (300 on hand, 51 days left)OVERSTOCKED      WIDGET-BLUE  (120 on hand, 277 days left)OVERSTOCKED      BAG-CANVAS  (500 on hand, 3462 days left)NO RECENT SALES  POSTER-OLD  (60 on hand, worth 120.00)NO RECENT SALES  TSHIRT-UNSOLD  (35 on hand, worth 420.00)NOT IN STOCK FILE  STICKER-NEW sold recentlySKIPPED sales row 3281 to order now, costing 418.50. 540.00 tied up in stock with no recent sales.

Set your own assumptions with --lead 21, --cover 45, --window 60 and --service 99. A lead time in the stock file overrides --lead for that SKU. Add --json for machine-readable output.

How it calculates

safety stock  = z x standard deviation of daily sales x square root of lead daysreorder point = daily sales x lead days + safety stockorder qty     = daily sales x (lead days + cover days) + safety stock - on hand

Daily sales are averaged over calendar days, including days with no sales. Returns reduce demand. Orders round up to any minimum order quantity (MOQ) in the stock file. Service levels of 90, 95 and 99 use z values of 1.28, 1.65 and 2.33.

StatusMeaning
Order nowOn hand is at or below the reorder point
Order soonIt will reach the reorder point within 7 days
OkEnough stock for now
OverstockedMore than 180 days of stock left
No recent salesNo net sales in the window

MCP tools

ToolWhat it does
inventory_checkReturns each SKU's status and order, most urgent first
inventory_inspect_csvShows detected columns and row counts, without row contents

Both are read-only, and neither can place orders. inventory_check returns SKUs and quantities to the MCP client, so they reach whichever AI model you use. The CLI keeps everything on your machine.

FAQ

How do I calculate a reorder point? Use the formula above, or run npx runwaystock check sales.csv stock.csv to do it for every SKU.

Does it work with Shopify, Amazon or WooCommerce? It reads CSV and recognizes common column names such as Lineitem sku and Lineitem quantity, and you can name others with --sales-columns. It doesn't connect to those platforms, and it hasn't been tested on each one's real exports yet.

How much sales history do I need? At least 28 days, or it warns that figures are rough. It uses the last 90 days by default.

Limits

  • It assumes recent sales predict the near future, so it doesn't see seasonality, promotions or growth.
  • Sales lost while out of stock look like low demand, which understates what you'd need.
  • The safety stock formula assumes fairly regular demand and a fixed lead time, so treat results as a starting point and check before buying.
  • It reads CSV only, up to 50 MB, and doesn't handle bundles or unit conversions.
  • So far it has been tested on made-up data, not real exports. If yours fails, please open an issue with the column headers, not your data.

Contributing

Contributions are welcome, from people and from people working with AI agents. See CONTRIBUTING.md. Good first issues:

  • Add column names from more e-commerce platforms and languages
  • Add --out to write a purchase list to a CSV
  • Group the order list by supplier
  • Add a seasonality option that compares with the same period last year
  • Add a plugin icon

AI disclosure

This project was largely generated with Claude Code and reviewed by its maintainer.

About me

I'm Giulliano Macedo, and I build developer tools at GoTech Solutions. Follow along or get in touch:

If runwaystock saved you from a stockout, a star helps others find it.


MIT licensed.

Built by Giulliano Macedo, GoTech Solutions · LinkedIn · X

来源:README.md,提交 3e91907

工具

2

inventory_check

Check stock and reorder points

Works out what to reorder and how much from a sales CSV and a stock CSV, with reorder points, safety stock, stockout dates and dead stock. Use for inventory planning, purchase orders, or finding slow-moving stock. Read-only, and never uses the network. Results include SKUs and quantities from the files, so they reach the model. It can't place orders.

输入参数limitlead_dayscover_dayssales_path必填stock_path必填date_formatwindow_dayssales_columnsservice_levelstock_columns

inventory_inspect_csv

Inspect a sales or stock CSV

Shows which columns runwaystock detects in a CSV and how many rows it can read, without returning row contents. Use if a file is unfamiliar or a check failed.

输入参数kind必填path必填

版本历史

2
  1. v0.2.0最新Nov 1, 2026
  2. v0.1.0Oct 31, 2026

评分

已满足适用检查项的 90%

该评分衡量此收录条目的完整程度,依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价,也不表示服务器安全或当前可用:可连通性是带日期的检查结果,评分也不包含安装量或用户评价。

  • 近 30 天内可连通25 分
  • 已声明认证方式10 分

    请在注册中心条目中声明凭据请求头,或保持端点能够响应探测,以便判定其认证方式。

  • 已列出工具必需15 分
  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分