majia-guanyuan SKILL.md skillA

majia-guanyuan from maojiebc/majia-guanyuan is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add maojiebc/majia-guanyuan/majia-guanyuan@v3.5.1

Pins v3.5.1 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
maojiebc/majia-guanyuan
Path
SKILL.md
Versions recorded
12
Latest version
v3.5.1, committed Nov 2, 2026
First version recorded
Sep 14, 2026
Size
38,718 bytes
Repository stars
17
License
MIT

观远 BI(Guandata)实战增益层。标准查数、指标批量查询、本地分析、建卡发布、ETL、数据集和表单结构管理、工作流、指标写入路由官方六组件。专攻 ETL 整库治理、SmartETL 全链路重写、引擎报错、自定义图表与 HTML 看板排障、看板口径档案与只读逐格验收、v7 发布兼容、移动端 phoneLayout、门店手机成绩单、SuperApp 的 LLM 中转及历史兼容、AI-native ADS 架构判断。餐饮会员公式见 majia-huiyuan。触发:execute-sql 5001、SQL 直查不可用、ETL 预览汇总、分块取数、历史数据抽取、预览截断、数字出处、看板口径档案、看板答案对账、观远、Guandata、会员、订单、复购率、RFM、ETL 治理、payload_json、自定义图表、HTML 看板、门店手机成绩单、换店滤空、phoneLayout、60004、SuperApp、ILLEGAL_JSON_RES、数据架构。.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# 观远 BI · 马甲实战版(V3.5.1)

> **结构说明(V1.5.0 引入 progressive disclosure)**:本文档是**路由层 + 关键规则**,详细操作手册下沉到 `references/`。每个 Part 的入口章节会指出"何时回到 references/ 查全表"。完整章节索引见末尾的 [📚 References 目录](#-references-目录)。

## 🧭 Part 选择

| 你想做 | 走 |
|---|---|
| 查数据、建卡、出报表、标准 ETL / 数据集 CRUD / 指标写 / 洞察问答 | [官方六组件路由](#官方全家桶--本-skill-分工总表) → 交给官方全家桶(`guancli` / `guanvis` / `guanetl` / `guanwf` / `guands` / `guanmetric`),见路由总表 |
| execute-sql 不可用 / 要全量汇总但只能预览 / 大数据集分块读取 / 预览疑似截断 / 季度或历史取数要留数字出处 | [受限环境取数速查](references/restricted-query-playbook.md),先核权限、完整性与预览名额,再选择只读汇总或分块读取 |
| 分块已完成但要核实覆盖、互斥与实际数据范围 / 要验收报告及数字出处 | [分块结果验收](references/extraction-evidence.md),只读本地账本,不发 BI 请求、不补取 |
| 给已有看板接 AI / 固化指标口径 / 核对答案与页面筛选 / 检测公式或隐藏筛选变化 | [看板口径档案与只读验收](references/dashboard-evidence.md),用 `scripts/dashboard_evidence.py` 管理本地定义、原始取数与逐格断言 |
| 扫整库 ETL 治理 / 新建/修改/删除 ETL / 字段使用度审计 / 修复 ETL 报错 | [Part B:ETL 治理](references/part-b-governance.md) |
| 把整条 SmartETL 链改写成 SQL 版 + 页面副本验收 + 差异定位 + 空快照阻塞 | **Part B-17:全链路重写方法论**(拆到 [references/part-b17-fullchain-rewrite.md](references/part-b17-fullchain-rewrite.md)) |
| 30+ 张表批量迁移 / 跨多日工程 / 复杂重构需要项目化追踪 | [B-17.11 ExecPlan 工作法](references/part-b17-fullchain-rewrite.md)(§11) |
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add maojiebc/majia-guanyuan/majia-guanyuan@sha256:cf316395de1c12e7

The line at the top of this page pins the label v3.5.1, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_iqwb5g4nfqriyrd5.svg)](https://markdownregistry.com/a/art_iqwb5g4nfqriyrd5)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 12 versions of this file, between Sep 14, 2026 and Nov 2, 2026, about one every 5 days.

versioncommittedcommitsizeaudit
v3.5.1 latest2026-11-02 39512e7 38,718 BA view · diff
v3.5.02026-10-14 179282d 37,908 BA view · diff
v3.4.12026-10-12 e71742d 36,597 BA view · diff
v3.4.02026-10-12 16002ea 35,812 BA view · diff
v3.3.02026-09-30 7090733 79,627 BA view · diff
v3.2.32026-09-28 5723fcb 78,217 BA view · diff
v3.2.22026-09-22 5270796 77,673 BA view · diff
v3.2.12026-09-20 a28786c 77,618 BA view · diff
v3.2.02026-09-14 ccc9623 77,023 BA view · diff
v3.1.122026-09-14 f97463a 76,422 BA view · diff
v3.1.122026-09-14 639f617 76,409 BA view · diff
v3.1.112026-09-14 70e56ef 75,414 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (38718 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

maojiebc/majia-guanyuan · 17 stars · license MIT · pushed 2026-11-02 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_iqwb5g4nfqriyrd5
GET https://markdownregistry.com/api/v1/resolve?ref=maojiebc/majia-guanyuan/majia-guanyuan
GET https://markdownregistry.com/api/v1/blob/cf316395de1c12e7a418e34738b05270b466769e2d05ab40d1760ac037f0b1d4

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from maojiebc/majia-guanyuan

AGENTS.md AGENTS.md file
maojiebc/majia-guanyuan · AGENTS.md
git:20261102.39512e7 · audit A · 17 stars
llms.txt llms.txt file
maojiebc/majia-guanyuan · llms.txt
git:20261014.179282d · audit A · 17 stars

Every file in maojiebc/majia-guanyuan

Browse by kind, by grade A, or by owner.