Agent skill

Yida Aggregate Table

by openyida in openyida/openyida

宜搭聚合表(virtualView)管理。用于列出、创建空聚合表、读取/预览设计配置、保存草稿、发布配置和查询构建状态;严格区分 stash 与 live revision,并在写入前校验固定前端已确认的六数组契约。

MITAuto-check passed

Install Yida Aggregate Table

skills CLI
$ npx skills add openyida/openyida --skill yida-aggregate-table -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install openyida/openyida yida-aggregate-table --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/openyida/openyida.git skills-src && mkdir -p .claude/skills && cp -r skills-src/yida-skills/skills/yida-aggregate-table .claude/skills/yida-aggregate-table && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
yida-aggregate-table
GitHub stars
220
Token cost
~721 tokens
SKILL.md length
185 words
Files
1
Skills in repo
58
Repo updated
First seen
Licence
MIT

At a glance

宜搭聚合表(virtualView)管理。用于列出、创建空聚合表、读取/预览设计配置、保存草稿、发布配置和查询构建状态;严格区分 stash 与 live revision,并在写入前校验固定前端已确认的六数组契约。

  • Works in 3 steps: 读取目标与现状 → 准备设计 JSON → 预览、保存与发布
  • SKILL.md covers 触发条件, 安全边界, 工作流 and 完成契约, plus 1 more section
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Yida Aggregate Table is an agent skill from openyida/openyida. 宜搭聚合表(virtualView)管理。用于列出、创建空聚合表、读取/预览设计配置、保存草稿、发布配置和查询构建状态;严格区分 stash 与 live revision,并在写入前校验固定前端已确认的六数组契约。

Its SKILL.md is about 720 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

The repository describes itself as: Your own personal YiDA AI assistant! The licence is MIT.

Example prompts

  • “/yida-aggregate-table”

Workflow steps

3 steps, taken from the step headings in SKILL.md.

  1. 读取目标与现状
  2. 准备设计 JSON
  3. 预览、保存与发布

What it can do on your machine

Read from SKILL.md and the folder at commit 3dd4693. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are bash).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Yida Aggregate Table loads about 721 tokens when it runs. Until then it costs about 32 tokens; SKILL.md has 185 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~32
When it runs · the whole SKILL.md, loaded when a task matches
~721

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from openyida/openyida at commit 3dd4693, republished under its MIT licence (© openyida). 185 words, ~721 tokens.

Download SKILL.mdSave it as .claude/skills/yida-aggregate-table/SKILL.md (or your agent's skills folder).
name
yida-aggregate-table
description
宜搭聚合表(virtualView)管理。用于列出、创建空聚合表、读取/预览设计配置、保存草稿、发布配置和查询构建状态;严格区分 stash 与 live revision,并在写入前校验固定前端已确认的六数组契约。

宜搭聚合表技能

触发条件

用户明确提到“聚合表”“虚拟视图”“virtualView”,或要检查、预览、保存、发布已有聚合表时使用本技能。普通统计报表使用 yida-report;自定义看板使用 yida-dashboard / yida-rechart,不要混用。

本技能只编排 openyida aggregate-table 已有的确定性窄命令,不生成通用高层 DSL,不复刻聚合公式引擎,不调用前端 AI authoring 接口。

安全边界

  • 写操作前必须从当前资源上下文取得精确 appType 和聚合表 formUuid,不得按名称猜 ID。
  • preview 是远端计算请求但不持久化;save 写草稿;publish 写 live 配置并触发构建。
  • save 的并发轴是 stashGmtModified,publish 的并发轴是 gmtModified。对应 GET readback 轴必须存在且前进;响应包含 revision 时还必须与该 readback 轴一致,不能用响应替代回读证据。
  • 设计 JSON 的六个顶层数组是 relationForms、relationships、aggregatedFields、auxFields、formulaFields、validators。显式错误类型必须失败,不能改成空数组继续写。
  • 不实现或猜测整表 delete。当前没有固定前端证据证明删除 API;物理 cleanup 必须报告 remote_cleanup_unsupported,不能声称删除成功。域内真实 E2E 只能在 exact runId/name ownership 证明成立后写入,并以 live revision 条件恢复至写前 canonical 配置;并发或归属证据变化时必须 restore_blocked,不得覆盖。
  • 动态租户 limits、真实公式语法、stash/live 可见性延迟、published runtime 查询和删除协议均为 PLATFORM_PROBE_REQUIRED。

工作流

1. 读取目标与现状
bash
openyida aggregate-table list <appType> --json
openyida aggregate-table inspect <appType> <formUuid> --json

需要新建资源且用户已授权时,才执行:

bash
openyida aggregate-table create-empty <appType> "<名称>" --no-open
2. 准备设计 JSON

设计 JSON 放在 <projectRoot>/.cache/openyida/<任务名>/aggregate-design.json,通过结构化文件写入工具创建。不要用 shell heredoc、cat、echo、printf、tee 或重定向生成。

发布前至少满足:

  • 每个 relationship 的 relationshipInfos 数量与 relationForms 数量一致。
  • relationId 唯一,并与 aggregatedFields[].id 一一对应。
  • 指标包含唯一 id、非空 name 和 formula。
  • validator 同时包含 formula 与非空 text.zh_CN。
  • filter rules 不超过固定前端默认上限 10,且每条 rule 有 operator。
  • aux field 包含唯一 id 与非空 name。

以上只做结构与引用完整性校验,不在本地判断聚合公式业务语义。

3. 预览、保存与发布
bash
openyida aggregate-table preview <appType> <formUuid> <design.json> --json
openyida aggregate-table save <appType> <formUuid> <design.json> --json --no-open
openyida aggregate-table publish <appType> <formUuid> <design.json> --json --no-open
openyida aggregate-table status <appType> <formUuid> --json

不要跳过 preview 后直接发布未经平台计算验证的复杂配置。发布成功只证明配置持久化;构建状态还必须精确读取到 SUCCESS。FAIL 时保留 errorMsg,不要无修改重复发布。

完成契约

  • 只读任务:返回精确 appType/formUuid、当前六数组摘要与 revision 状态。
  • 草稿任务:revisionAxis=stashGmtModified、stash readback revision 已前进且六数组 canonical readback 一致;响应 revision 存在时须与 stash readback 一致。
  • 发布任务:revisionAxis=gmtModified、live readback revision 已前进且六数组 canonical readback 一致;响应 revision 存在时须与 live readback 一致,并读取构建终态。
  • 真实运行态结果与物理 cleanup 在平台协议未探明前必须明确标注 PLATFORM_PROBE_REQUIRED / remote_cleanup_unsupported;域内 E2E 的 conditional restore 还必须单独给出 exact readback 证据,不能用命令退出 0 替代。

WHEN NOT(明确不做)

  • 整表 delete、模糊名称清理或跨 run 清理。
  • AI 文生聚合表、拖拽设计器复制、每个 UI 动作一个 CLI 子命令。
  • 通用 high-level DSL、动态 limits 平台或本地公式引擎。

© openyida, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in yida-skills/skills/yida-aggregate-table of openyida/openyida.

Open the folder on GitHubat commit 3dd4693

Compare with similar skills

Yida Aggregate Table next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Yida Aggregate Table compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Yida Aggregate Table this skillopenyida/openyida220—~721Automated safety check: PassMIT
Table Fitasgeirtj/system_prompts_leaks69k—~772Automated safety check: PassCC0-1.0
Ddd Aggregateruvnet/ruflo74k—~774Automated safety check: NotesMIT
Table Headersthedaviddias/Front-End-Checklist74k—~460Automated safety check: PassMIT
Accessible Tablesthedaviddias/Front-End-Checklist74k—~521Automated safety check: PassMIT
Data Table Managern8n-io/n8n207k—~2.3kAutomated safety check: PassCustom licence

Similar skills

  • Table Fit

    asgeirtj/system_prompts_leaks

    Keep a Markdown table readable in a narrow terminal of about 100 display columns - a wide table or one carrying prose in its cells wraps into unreadable ragged rows.

    69k GitHub stars~772 tokensUpdated today
    Testing & QAAuto-check passed
  • Ddd Aggregate

    ruvnet/ruflo

    Scaffold an aggregate root with entity, value objects, repository interface, domain events, and test stubs.

    74k GitHub stars~774 tokensUpdated today
    DevelopmentAuto-check: notes
  • Table Headers

    thedaviddias/Front-End-Checklist

    A skill your agent uses when reviewing rendered HTML, interactive components, or design-system patterns related to Define proper table headers.

    74k GitHub stars~460 tokensUpdated 2 days ago
    Frontend & DesignAuto-check passed
  • Accessible Tables

    thedaviddias/Front-End-Checklist

    A skill your agent uses when reviewing rendered HTML, interactive components, or design-system patterns related to Use semantic table markup for screen readers.

    74k GitHub stars~521 tokensUpdated 2 days ago
    Frontend & DesignAuto-check passed
  • Official

    Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.

    207k GitHub stars~2.3k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Table

    brycewang-stanford/Auto-Empirical-Research-Skills

    Econometrics skill for creating publication-quality LaTeX regression and summary tables.

    4.5k GitHub stars~3.3k tokensUpdated 3 days ago
    Documents & OfficeAuto-check passed

More from openyida/openyida

All 58 skills in this repo
  • Yida Canvas Custom Page

    openyida/openyida

    宜搭自定义页面开发规范,使用 YidaCodeCanvas 组件实现现代 React18 自定义页面。用于官网、看板、工作台、列表、详情、门户壳、可视化、hooks 交互、表单入口,以及需要门户组件、数据管理视图、成员、部门或上传组件的场景;发布层自动注入 yida/utils window 桥。

    220 GitHub stars~4.3k tokensUpdated 8 days ago
    Auto-check passed
  • Openyida Release

    openyida/openyida

    快速发布 OpenYida npm 正式版或测试版。用户说“发布正式版”“发布测试版”“发 beta”或要求按当天日期生成版本 tag 时使用;不用于宜搭应用或自定义页面发布。

    220 GitHub stars~520 tokensUpdated 8 days ago
    Auto-check passed
  • Yida Design Plan

    openyida/openyida

    Plan 模式的视觉设计分支。基于需求选择视觉方向,再结合业务页面规划维护 build-plan.json 的 visualStyle,供 CLI 派生 design.md。

    220 GitHub stars~756 tokensUpdated 8 days ago
    Auto-check passed
  • Prevent stale local OpenYida custom page source from overwriting live designer edits.

    220 GitHub stars~1.2k tokensUpdated 8 days ago
    Auto-check passed
  • Codemap

    openyida/openyida

    Generate, update, or drift-check agent-facing CodeMaps as progressive code terrain indexes for projects, features, capabilities, functions, modules, or bug chains.

    220 GitHub stars~1k tokensUpdated 8 days ago
    Auto-check passed
  • Sdd Riper One Light

    openyida/openyida

    面向 GPT-5.5 等强模型和熟练用户的轻量 AI Agent Harness / checkpoint-driven coding skill。默认用户已经把任务切到基本可执行的最小混沌单元;模型自行分解、探索与推进,人类通过最终目标、最小 spec、复述、checkpoint、证据验证与回写来低干扰控盘。

    220 GitHub stars~1.5k tokensUpdated 8 days ago
    Auto-check passed

Questions about Yida Aggregate Table

What does Yida Aggregate Table do?

宜搭聚合表(virtualView)管理。用于列出、创建空聚合表、读取/预览设计配置、保存草稿、发布配置和查询构建状态;严格区分 stash 与 live revision,并在写入前校验固定前端已确认的六数组契约。. Yida Aggregate Table is an agent skill from openyida/openyida.

How do I install Yida Aggregate Table in Claude Code?

Run `npx skills add openyida/openyida --skill yida-aggregate-table -a claude-code`. Or copy the skill folder (yida-skills/skills/yida-aggregate-table in openyida/openyida) into .claude/skills/yida-aggregate-table in your project. Claude Code loads it when a task matches its description.

How do I install Yida Aggregate Table in Codex?

Run `npx skills add openyida/openyida --skill yida-aggregate-table -a codex`. Or copy the skill folder (yida-skills/skills/yida-aggregate-table in openyida/openyida) into .agents/skills/yida-aggregate-table in your project. Codex loads it when a task matches its description.

Can I use Yida Aggregate Table in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add openyida/openyida --skill yida-aggregate-table -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/yida-aggregate-table, .gemini/skills/yida-aggregate-table, .github/skills/yida-aggregate-table and .opencode/skills/yida-aggregate-table in your project.

What does Yida Aggregate Table need to run?

SKILL.md names no scripts, command-line tools or credentials: Yida Aggregate Table is instructions for the agent only.

Does Yida Aggregate Table access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Yida Aggregate Table safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Yida Aggregate Table use?

Yida Aggregate Table is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Yida Aggregate Table use?

About 721 tokens (SKILL.md is roughly 2.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Yida Aggregate Table?

Skills that share tags, products or a category with Yida Aggregate Table: Table Fit (asgeirtj/system_prompts_leaks, 69k stars), Ddd Aggregate (ruvnet/ruflo, 74k stars), Table Headers (thedaviddias/Front-End-Checklist, 74k stars) and Accessible Tables (thedaviddias/Front-End-Checklist, 74k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Yida Aggregate Table?

openyida (a GitHub organization) maintains it in openyida/openyida, which has 220 GitHub stars. The repository holds 58 skills in this directory. The repository was last updated on September 30, 2026.

Source: openyida/openyida on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.