← Back to Skills Marketplace
107
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install indexquery
Description
基于Excel表格及指标定义，生成承运商维度的指数、行业平均数据，并支持历史趋势图展示与指标构成解析
README (SKILL.md)
\r \r
How To Use \r
当承运商或者运营查询某天的承运商物流指数总分时输出\r \r
Rules\r
- 用户输入excel路径，读取excel信息，表头行为统计日期，列为承运商名称\r
- 解析表格内容，查询输入中的承运商名称及统计日期的物流指数总分数据\r
- 计算出在该统计日期下所有承运商物流指数总分的平均值作为行业平均\r
- 计算查询的承运商在该统计日期下与行业平均的差值，及行业排名。若低于行业平均值大于5%，记为严重，红色标签；若低于行业平均值3%，记为警告，黄色标签；若低于行业平均值1%，记为提示，蓝色标签；\r
- 调用http://jingwe.jdl.com/#/indexCenter/indexDirection 获取物流指数总分分子指标的构成，及权重占比。\r
- 调用Delta法定位物流总分变动的主要影响子指标\r
- 点击下载后，调用在该统计日期下该承运商在影响最大子指标的异常明细才进行下载。http://jingwe.jdl.com/#/indexCenter/shipperOverview 在该网址下筛选条件为用户输入承运商、统计日期，省份默认全国\r \r
input\r
- 读取本地文件.xlsx 或 .csv 表格数据\r \r
output\r
- 该承运商在该统计日期的物流指数总分，行业平均值，与行业平均值的差值及标签，该承运商行业排名\r
- 该承运商在该统计日期T-7至统计日期的物流指数总分曲线图，行指标为日期，列值为该承运商在曲线日期的值\r
- 定位影响比例最大的子指标\r
- 输出运营建议及异常明细\r \r \r \r
Usage Guidance
Before installing or using this skill, consider the following:
- It will read local Excel/CSV files you supply — only provide data you are comfortable letting the agent access.
- The runtime instructions tell the agent to call two external web routes on jingwe.jdl.com and to download anomaly details from that site. Confirm whether that domain is trusted (e.g., an internal corporate service) and whether sending carrier names/dates to it is acceptable.
- The SKILL.md does not declare any authentication or credentials for those endpoints. Ask the developer (or require) explicit instructions on what requests are made, whether authentication is required, and what data will be transmitted.
- If you cannot confirm the endpoint's trustworthiness, avoid enabling outbound network access for this skill or run it in an offline/local-only mode (implement local equivalents of the index-definition and anomaly retrieval).
- Request that the skill author clarify request methods, data fields sent, and add explicit handling for authenticated APIs (and only request minimal credentials if needed).
Capability Analysis
Type: OpenClaw Skill
Name: indexquery
Version: 1.0.0
The skill is designed for logistics carrier performance analysis, processing local Excel/CSV data to calculate industry averages, rankings, and historical trends. It instructs the agent to reference JD Logistics web portals (jingwe.jdl.com) for index definitions and anomaly details. The logic is consistent with the stated business purpose and contains no indicators of malicious intent or unauthorized data exfiltration.
Capability Assessment
Purpose & Capability
Reading local Excel/CSV, computing averages, ranking, trend plots and identifying contributing sub-indicators all align with the described carrier-index purpose. Calling an external index-definition and overview pages could be legitimate if those pages provide needed metadata/weights, but the SKILL.md does not explain why these specific endpoints are required or whether they require auth.
Instruction Scope
Instructions explicitly require reading local files (expected) and 'calling' two external URLs (http://jingwe.jdl.com/#/indexCenter/indexDirection and http://jingwe.jdl.com/#/indexCenter/shipperOverview). The document does not state what data is sent to those endpoints, whether requests are GET/POST, or whether authentication is needed. The skill also instructs downloading anomaly details from that site filtered by user inputs — this could cause carrier names, dates, or other sensitive data to be transmitted externally. The instructions are vague about network behavior and error handling.
Install Mechanism
No install spec and no code files — instruction-only. This minimizes installation risk since nothing is written to disk by the skill itself.
Credentials
The skill does not request any environment variables or credentials, which is appropriate for a local Excel-processing tool. However, it nevertheless calls corporate-looking web endpoints; the lack of declared credentials or guidance for authenticated access is a gap. If those endpoints require org credentials, the skill should request them explicitly and justify their need.
Persistence & Privilege
always is false and there are no install hooks or modifications to other skills or system settings. The skill does not request elevated persistence or privileges.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install indexquery - After installation, invoke the skill by name or use
/indexquery - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of the carrier index query skill.
- Supports reading local .xlsx or .csv files for carrier index data.
- Calculates carrier’s index score, industry average, delta, and ranking for a specified date.
- Provides warning label based on deviation from industry average (serious, warning, tip).
- Displays historical trend chart (T-7 to specified date) for the carrier.
- Identifies major contributing sub-metric using Delta method.
- Outputs operational suggestions and allows download of detailed anomaly report for largest-impact sub-metric.
Metadata
Frequently Asked Questions
What is 承运商指数查询?
基于Excel表格及指标定义，生成承运商维度的指数、行业平均数据，并支持历史趋势图展示与指标构成解析. It is an AI Agent Skill for Claude Code / OpenClaw, with 107 downloads so far.
How do I install 承运商指数查询?
Run "/install indexquery" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is 承运商指数查询 free?
Yes, 承运商指数查询 is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does 承运商指数查询 support?
承运商指数查询 is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created 承运商指数查询?
It is built and maintained by a-vb (@a-vb); the current version is v1.0.0.
More Skills