← Back to Skills Marketplace
Auto Pivot Table
by
SHENRUIYANG
· GitHub ↗
· v1.0.0
· MIT-0
102
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install auto-pivot-table
Description
Build ORBCAFE advanced analytics and voice navigation with CPivotTable/usePivotTable and CAINavProvider/useVoiceInput using official examples patterns. Use f...
README (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,避免输入框场景误触。
Usage Guidance
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.
Capability Analysis
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.
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install auto-pivot-table - After installation, invoke the skill by name or use
/auto-pivot-table - Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Frequently Asked Questions
What is Auto Pivot Table?
Build ORBCAFE advanced analytics and voice navigation with CPivotTable/usePivotTable and CAINavProvider/useVoiceInput using official examples patterns. Use f... It is an AI Agent Skill for Claude Code / OpenClaw, with 102 downloads so far.
How do I install Auto Pivot Table?
Run "/install auto-pivot-table" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Auto Pivot Table free?
Yes, Auto Pivot Table is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Auto Pivot Table support?
Auto Pivot Table is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Auto Pivot Table?
It is built and maintained by SHENRUIYANG (@shenruiyang); the current version is v1.0.0.
More Skills