← 返回 Skills 市场
Auto Pivot Table
作者
SHENRUIYANG
· GitHub ↗
· v1.0.0
· MIT-0
102
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install auto-pivot-table
功能描述
Build ORBCAFE advanced analytics and voice navigation with CPivotTable/usePivotTable and CAINavProvider/useVoiceInput using official examples patterns. Use f...
使用说明 (SKILL.md)
ORBCAFE Pivot + AINav
Workflow
- 先对照
skills/orbcafe-ui-component-usage/references/module-contracts.md,确认这是Hook-first模块。 - 用
references/domain-patterns.md判定 pivot、voice 或组合模式。 - 执行安装与最小可运行接入。
- 用
references/recipes.md产出实现骨架。 - 对 pivot 需求额外检查是否需要三段式布局(配置区 + 图表区 + 结果区)、独立折叠、图表选择器和 preset 图表快照。
- 用
references/guardrails.md检查受控状态、preset 持久化、ASR 配置。 - 输出验收步骤与“没效果”排障。
Installation and Bootstrapping (Mandatory)
npm install orbcafe-ui @mui/material @mui/icons-material @mui/x-date-pickers @emotion/react @emotion/styled dayjs
本仓库联调:
npm run build
cd examples
npm install
npm run dev
参考实现:
examples/app/_components/PivotTableExampleClient.tsxexamples/app/_components/AINavExampleClient.tsxsrc/components/PivotTable/PivotChart/
Output Contract
Mode:Hook-first.Module choice: pivot or AINav (or both).Minimal implementation: controlled if persistence/integration needed.Ops note: preset 持久化、PivotChart 默认逻辑或 ASR 契约。Verify: 至少包括拖拽布局生效、聚合切换、图表切换、独立折叠、生效后持久化、语音触发与回调。Troubleshooting: 至少包含 3 条失效排查点。
Examples-Based Experience Summary
- 需要持久化时优先
usePivotTable受控模式,不要只依赖组件内部状态。 - preset 持久化应在
onPresetsChange回调落地(本地可用 localStorage,生产建议服务端)。 - Pivot 默认是三段式:配置区、PivotChart、结果表格;图表区和表格区都能独立折叠。
- PivotChart 最多只映射 1 个维度和 2 个度量。默认维度优先取
rows[0],否则columns[0];默认主度量取values[0]。 - 多维或多度量时,图表工具条应显示 4 个统一宽度的下拉:
Dimension / Measure / Compare measure / Chart type。 - preset 不只保存布局和筛选,也要保存图表维度、主度量、对比度量和图表类型。
- localStorage 读写放在浏览器安全边界(初始化判定
window,写入放useEffect)。 - AINav 强制提供
onVoiceSubmit,否则“录音了但业务不动作”。 - 空格热键建议保持
ignoreWhenFocusedInput=true,避免输入框场景误触。
安全使用建议
This skill is a development helper and appears internally consistent. Before using it: (1) run npm install/build only in a trusted repository (npm packages will be fetched from registries); (2) review example code referenced (examples/* and src/*) before running the dev server to ensure no unexpected behavior; (3) ensure ASR/websocket endpoints and any auth are provided via your app config (not hardcoded), and don't point production secrets to localhost or unknown external hosts; (4) if you plan to persist presets server-side, verify the backend integration and credentials separately.
功能分析
Type: OpenClaw Skill
Name: auto-pivot-table
Version: 1.0.0
The skill bundle provides a structured workflow and code patterns for implementing pivot tables and voice navigation using the 'orbcafe-ui' library. It includes standard UI dependencies (MUI, Emotion, Day.js) and follows security best practices by advising against hardcoding secrets for ASR (Automatic Speech Recognition) authentication in 'references/guardrails.md'. The instructions and recipes are consistent with the stated purpose and do not exhibit signs of malicious intent or data exfiltration.
能力评估
Purpose & Capability
Name/description (pivot + AINav) match the SKILL.md and the included reference examples and recipes. The npm packages and example file paths shown are consistent with implementing a React UI pivot/voice feature; nothing requested is out of scope for that purpose.
Instruction Scope
The SKILL.md instructs the agent/developer to inspect repository files (e.g., skills/orbcafe-ui-component-usage/...), run npm install, build and run example dev servers, and use localStorage or server persistence. These actions are normal for a development helper but do require executing project code from the repository; the skill does not instruct reading unrelated system files or exfiltrating data.
Install Mechanism
There is no registry install spec and no downloaded archives. The document tells developers to run npm install/build in their project — a typical developer workflow. No external or obscure URLs or archive extraction are requested by the skill itself.
Credentials
The skill does not request environment variables, credentials, or config paths. Guardrails explicitly call out that ASR auth and wsUrl should come from app config (and not hardcoded secrets). Example wsUrl uses ws://localhost:8765, which is local testing-oriented, not an external secret.
Persistence & Privilege
The skill is not marked always:true, does not request persistent system privileges, and is instruction-only. It does not modify other skills or system-wide agent settings.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install auto-pivot-table - 安装完成后,直接呼叫该 Skill 的名称或使用
/auto-pivot-table触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
Initial release of the ORBCAFE Pivot + AINav integration skill.
- Guides integration of advanced pivot analytics and voice navigation, matching official module and domain patterns.
- Provides step-by-step install, bootstrap, and minimal implementation instructions.
- Outlines three-zone layout, aggregation/chart controls, persistence, and usage guardrails for pivot tables.
- Details output contract, including controlled state, presets, ASR requirements, and troubleshooting guidance.
- References included: usage domain patterns, guardrails, and recipes for consistent implementation.
元数据
常见问题
Auto Pivot Table 是什么?
Build ORBCAFE advanced analytics and voice navigation with CPivotTable/usePivotTable and CAINavProvider/useVoiceInput using official examples patterns. Use f... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 102 次。
如何安装 Auto Pivot Table?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install auto-pivot-table」即可一键安装,无需额外配置。
Auto Pivot Table 是免费的吗?
是的,Auto Pivot Table 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。
Auto Pivot Table 支持哪些平台?
Auto Pivot Table 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 Auto Pivot Table?
由 SHENRUIYANG(@shenruiyang)开发并维护,当前版本 v1.0.0。
推荐 Skills