Majia Guanyuan

观远 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、数据架构。

17 stars 5 forksData & Analytics

Install

skills CLI (Claude Code, Cursor, Codex and more)

npx skills add maojiebc/majia-guanyuan --skill majia-guanyuan

Manual install

git clone --depth 1 https://github.com/maojiebc/majia-guanyuan.git /tmp/majia-guanyuan
mkdir -p ~/.claude/skills
cp -r /tmp/majia-guanyuan/. ~/.claude/skills/majia-guanyuan

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 观远 BI · 马甲实战版（V3.5.0）

> **结构说明（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） |
| 自定义图表 HTML/CSS/JS 注入、固定卡片/overlay、payload_json 取数、路由清理 | [Part C：自定义图表](references/part-c-runtime.md) |
| 从零生成 HTML 化经营分析应用（用户说"更高级 / 应用化 / 自定义模块 / 最完美 / 不限标准看板"）| **Part C-12：HTML 应用化看板生成**（拆到 [references/part-c-html-dashboard.md](references/part-c-html-dashboard.md)） |

Read the full skill on GitHub

Details

Skill name: majia-guanyuan
Repository: maojiebc/majia-guanyuan
License: MIT
Repo updated: 22 October 2026

FAQ

What does the Majia Guanyuan skill do?

How do I install the Majia Guanyuan skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add maojiebc/majia-guanyuan --skill majia-guanyuan. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Majia Guanyuan popular?

It lives in maojiebc/majia-guanyuan, which has 17 GitHub stars and 5 forks.

Related skills

Taoguba Crawler

lisniuse/taoguba-crawler-skill

This skill should be used when the user asks to "crawl taoguba", "crawl tgb", "scrape taoguba articles", "run the crawler", "crawl bbs", "crawl home page", "generate article HTML", or needs to run the Taoguba (tgb.cn) web crawlers.

Data & Analytics

Ha Bubble Dashboard

johnnyh1975/HA_Bubble_Skill

Home Assistant dashboard design with Bubble Card 3.x, Streamline Card, Sidebar Card and Mushroom — including a merged HA/Bubble/Mushroom CSS theme with colour intelligence, palette recipes, WCAG checks, typography, wall-panel support and full troubleshooting. TRIGGERS: Bubble Card (any card type), Lovelace dashboards, CSS themes, colour palettes, fonts, Streamline templates, Sidebar Card nav, Mushroom chips, room pop-ups, wall panels, masonry→sections migration, native-vs-custom dashboard decisions, troubleshooting. SYMPTOMS: hardcodes hex in YAML · uses pre-v3.2 pop-up format · places pop-up

Data & Analytics

Lemonwrench

bpawnzZ/lemonwrench

Use when looking up car repair procedures, torque specs, diagrams or service-manual steps. Scrapes free OEM manuals by vehicle, resolves the exact trim/engine, and cross-checks parts catalogs and field sources.

Data & Analytics

Notebooklm

JunSuzuki1973/notebooklm-antigravity-skill

Interact with Google NotebookLM via CLI (nlm). Use this when the user wants to manage notebooks, add sources, generate audio podcasts, research topics, query notebooks, or share content.

Data & Analytics

Ziwei Doushu

Linden-TR/ziwei-doushu-skill

When the user asks about 紫微斗数 / Ziwei Doushu / Purple Star Astrology — including 排盘 (chart casting), 命盘解读 (chart reading), 看运势 (fortune reading), 事业/感情/财运/健康等命理咨询, or mentions 十四主星 / 十二宫 / 四化 / 大限 / 流年 / 飞星 / 七星 / 六吉六煞 — use this skill. Also trigger when the user says 算命, 看盘, 算紫微, 帮我看运势, or any request for Chinese metaphysical destiny analysis. Multi-school methodology: Zhongzhou (primary), San He, Fei Xing, Qin Tian Si Hua, He Luo.

Data & Analytics

HTML Explainer

ds-vibe/html-explainer

Build a polished, lightly-interactive single-page web explainer for educational, informational, or explanatory content. Use when the user wants to explain, teach, summarize, or visualize a topic, concept, policy, dataset, process, or body of knowledge as an interactive web page — emphasizing progressive complexity, strong visual design, source-grounded accuracy, and an iterative quality loop. Triggers on requests like "make an interactive explainer / guide / walkthrough / one-pager," "turn this into a visual web page people can explore," or "help people get acquainted with X and drill down.

Data & Analytics

Browse the most popular Claude skills, all data & analytics skills, or write your own with the skills generator.