llms.txt git:20260914.ccc9623A

Immutable. This exact content is served forever at /api/v1/blob/421b1dc701513180.

# majia-guanyuan

> A tool-agnostic Agent Skill for Guandata BI (观远 BI), created by 超级马甲 / maojiebc. It is a battle-tested augmentation layer on top of Guandata's official CLI family (guancli / guanvis / guanetl / guanwf / guands / guanmetric), covering what the official DSL cannot reach: ETL governance judgment, BI engine error playbooks, custom chart injection, HTML application dashboards with visual design baselines, v7 draft-release state-machine bypasses, SuperApp reverse-engineering, AI-native ADS methodology, and a restaurant BI formula library.

## Primary Links

- Repository: https://github.com/maojiebc/majia-guanyuan
- Skill entry: https://github.com/maojiebc/majia-guanyuan/blob/main/SKILL.md
- Chinese README: https://github.com/maojiebc/majia-guanyuan/blob/main/README.md
- English README: https://github.com/maojiebc/majia-guanyuan/blob/main/README.en.md
- Security policy: https://github.com/maojiebc/majia-guanyuan/blob/main/SECURITY.md
- Attribution: https://github.com/maojiebc/majia-guanyuan/blob/main/ATTRIBUTIONS.md

## Skill Contents

- `SKILL.md`: routing layer and core operating rules for agents (standard query/card/ETL work routes to the official CLI family; this skill keeps the hard parts).
- `references/official-cli-compatibility.md`: verified official versions, metric JSON/raw values, batch status, placement and legacy fallback boundaries.
- `references/part-b-payload.md`: ETL payload schema and write workflow.
- `references/part-b-errors.md`: ETL error diagnosis playbook (10 engine error categories).
- `references/part-b-sdk.md`: v2 to v3 batch migration SDK notes.
- `references/part-b17-fullchain-rewrite.md`: SmartETL full-chain rewrite methodology + ExecPlan workflow.
- `references/part-c-payload-json.md`: custom chart `payload_json` troubleshooting.
- `references/part-c-html-dashboard.md`: C-12 HTML application dashboard methodology (dataView contract, selector descriptor patch, five-layer acceptance).
- `references/part-c-store-mobile-scorecard.md`: franchise-owner mobile scorecard (19 DATA_GRID views, column-name detectV, store-filter AND trap, no peer-group store counts). Offline desensitized HTML: `examples/store-mobile-scorecard/`.
- `references/part-c-design-baseline.md`: visual design baseline for HTML dashboards (data-judgment-first layout, KPI/number conventions, chart authenticity, visual token caps, anti-AI-look red lines, `guanvis screenshot` visual acceptance; absorbed from xiaomingtx666/design-taste-skills, MIT).
- `references/v7-page-card-publish-pipeline.md`: Part D v7 draft-release state machine, SmartETL node silent traps, mobile phoneLayout ZIP inject.
- `references/part-e-superapp-pipeline.md`: Part E SuperApp open-app reverse-engineering pipeline (form schema creation, LLM bridge response parsing).
- `references/ai-native-ads-design.md`: AI-native ADS data architecture methodology (governance vs. rebuild).
- Restaurant chain BI formula library (60+ SQL patterns, RFM, repurchase, DWD wide-table paradigms): moved to https://github.com/maojiebc/majia-huiyuan (公式库/); `references/restaurant-bi-formulas/` here is a pointer only.
- `templates/html-dashboard/`: GDHTML shared runtime + base CSS (calibrated to the design baseline) + starter modules + selector linkage patch script.
- `scripts/inject_phone_layout.py`: mobile phoneLayout ZIP injection for v7 pages.

## Author

超级马甲 / maojiebc focuses on retail membership operations, private-domain growth, CRM/user operations, data systems, BI/ETL governance, AI tools, and practical Agent Skills.

- GitHub: https://github.com/maojiebc
- X: https://x.com/maojiebc
- Xiaohongshu: https://xhslink.com/m/4fQMJeHHWKC
- WeChat Official Account: 超级马甲

- `references/part-c-store-mobile-scorecard-v2.md`: current mobile scorecard, dedicated SQL, revenue-ranked filters, deterministic anomaly warnings and coupon conversion. Runnable synthetic example: `examples/store-mobile-scorecard-v2/`.
- `references/coupon-order-link-diagnosis.md`: trace missing coupon-order links; nearby transactions are candidates, never automatic revenue attribution.