← 返回
未分类 Key

chip-trade-skills

Connects local ERP inventory with IC Trade Navigator API for real-time IC pricing, risk scores, and trade advice without exposing your financial data.
oppstie
未分类 clawhub v1.0.0 100000 Key: 需要
★ 0
Stars
📥 293
下载
💾 0
安装

概述

IC Trade Navigator — MCP Connector

Taiwan-neutral IC component quoting connector for Claude Desktop and MCP-compatible clients.

The bridge between your local ERP inventory and real-time IC market intelligence.

Connect your local ERP inventory to real-time market intelligence — without sending your pricing data to any server.


What This Is

This connector is the client-side component of the IC Trade Navigator system. It:

  • Reads your local inventory.xlsx (part numbers + stock quantities only)
  • Calls the IC Trade Navigator API (GET /v1/quote) to fetch market pricing, risk scores, and trade advisory
  • Merges both sources into a unified view — locally, on your machine
  • Exposes three MCP tools to Claude Desktop for conversational IC trading workflows

Your floor prices, purchase costs, and ERP financial data never leave your machine.


🛡️ Why Use This?

Privacy First: Your cost and financial data never leave your local machine.

Market Intelligence: Real-time pricing and risk scoring (low/medium/high).

Taiwan-Neutral: Specialized filtering and advisory for the Taiwan electronics trade.


Architecture

Your Machine                          IC Trade Navigator Server
─────────────────────────────         ──────────────────────────
inventory.xlsx  ←─ read               (Black-box API)
    │                                  • Market scraping
    │  part_number + qty only          • Risk scoring
    └──────────────────────────────►   • Multilingual advisory
                                       • Taiwan-neutral filtering
    ◄──────────────────────────────
    quoted_price, risk_level,
    advisory (en/de/ja/zh-TW/fr/ko)
         │
    merged_view  ─► Claude Desktop

Quick Start

1. Install dependencies

pip install httpx openpyxl

2. Configure environment

cp .env.example .env
# Edit .env:
#   QUOTE_ENGINE_URL     = https://api.ic-navigator.com   (or your self-hosted URL)
#   QUOTE_ENGINE_API_KEY = JAY-IC-xxxxxxxxxxxxxxxxxxxx
#   ERP_EXCEL_PATH       = /path/to/your/inventory.xlsx

3. Single quote (CLI)

python -m mcp_connector.client quote STM32L412CBU6 --qty 500 --lang zh-TW

4. Batch quote from inventory

python -m mcp_connector.client batch data/inventory.xlsx

5. JSON output (for ERP integration)

python -m mcp_connector.client quote GD32F103C8T6 --qty 1000 --lang en --json

MCP Tools (Claude Desktop)

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "ic-trade-navigator": {
      "command": "python",
      "args": ["-m", "mcp_connector.server"],
      "env": {
        "QUOTE_ENGINE_URL": "https://api.ic-navigator.com",
        "QUOTE_ENGINE_API_KEY": "JAY-IC-your-key-here",
        "ERP_EXCEL_PATH": "/absolute/path/to/inventory.xlsx"
      }
    }
  }
}

Available tools in Claude:

ToolDescription
------
quote_partGet market quote + risk score for one part number
read_erp_inventoryLook up your local stock for a part
get_combined_viewFull merged view: market + local ERP

Inventory File Format

Your inventory.xlsx should have these columns (column names are configurable):

Part NumberStock QtyStatusPackageDate Code
---------------
STM32L412CBU612000In StockUFQFPN322347
GD32F103C8T68000In StockLQFP482344

A sample file is included at data/inventory.xlsx.

Pricing columns are automatically blocked — even if present in your file, the connector will never read or transmit them.


Response Fields

{
  "part_number": "STM32L412CBU6",
  "quoted_price": 2.8500,
  "quote_action": "auto_quote",
  "risk_level": "low",
  "risk_index": 0.12,
  "tw_neutral_confidence": 0.88,
  "advisory": "Part is in normal active supply...",
  "advisory_lang": "en",
  "local_stock_qty": 12000,
  "recommendation": "✅ Auto-quote ready. Local stock: 12,000 units."
}

Risk Levels

LevelScoreMeaning
---------
🟢 low< 0.30Standard procurement confidence
🟡 medium0.30–0.65Request Certificate of Conformance
🔴 high≥ 0.65Escalate to procurement quality team

Advisory Languages

en · de · ja · zh-TW · fr · ko


Custom Column Mapping

If your Excel uses different column headers:

python -m mcp_connector.client batch inventory.xlsx \
  --col-pn "MPN" \
  --col-qty "Available" \
  --col-status "Lifecycle"

Environment Variables

VariableRequiredDefaultDescription
------------
QUOTE_ENGINE_URLAPI server base URL
QUOTE_ENGINE_API_KEYYour JAY-IC- API key
ERP_EXCEL_PATHdata/inventory.xlsxPath to local inventory file
CONNECTOR_TIMEOUT15HTTP timeout in seconds

Privacy Guarantee

This connector enforces a strict data boundary:

  • Sent to server: part_number, qty, lang — nothing else
  • Blocked fields: Any column header containing price, cost, floor, margin, sale, purchase, 底价, 售价, 进价, 含税
  • Client-side only: All ERP merging and display runs locally

License

MIT License — see LICENSE


Get an API Key

This connector requires access to the IC Trade Navigator API.

Contact: jay.ictw@gmail.com

版本历史

共 1 个版本

  • v1.0.0 当前
    2026-05-07 19:27 安全 安全

安全检测

暂无安全检测报告