jeecg-onlreport SKILL.md skillB

jeecg-onlreport from jeecgboot/skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add jeecgboot/skills/jeecg-onlreport@git:20260429.960f54a

Pins git:20260429.960f54a in mdr.lock. Pin the fingerprint instead.

Audit grade
B, 16 of 17 checks passed
Kind
SKILL.md skill
Repository
jeecgboot/skills
Path
jeecg-onlreport/SKILL.md
Versions recorded
5
Latest version
git:20260429.960f54a, committed Apr 29, 2026
First version recorded
Mar 14, 2026
Size
32,543 bytes
Repository stars
246
License
Apache-2.0

Use when user asks to create/edit/query Online reports, SQL reports, data reports, or says "创建报表", "生成报表", "新建报表", "查询报表", "online报表", "SQL报表", "数据报表", "统计报表", "create report", "generate report", "data report". Also triggers when user describes report requirements like "做一个销售统计报表", mentions JeecgBoot cgreport/online report, or says "查看现有报表" / "列出所有报表". This skill handles Online 报表 (SQL-driven data display/reports), not Online forms (cgform) or designer forms (desform).

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

# JeecgBoot Online 报表 AI 自动生成器

将自然语言描述的报表需求,转换为 Online 报表配置,并通过 API 自动创建/编辑/查询。

> **重要**:本 skill 处理「Online 报表」(SQL 驱动的只读数据报表),不涉及 Online 表单(cgform)或设计器表单(desform)。

## 核心能力

| 操作 | 说明 |
|------|------|
| **查询报表** | 列出系统中所有 Online 报表,查看字段和参数配置 |
| **新增报表** | 从自然语言需求或 SQL 创建报表 |
| **编辑报表** | 修改现有报表的字段、参数、SQL |

---

## Step 0: 收集凭证

**每次操作前必须收集以下信息**(如果用户已提供则跳过):

1. **API 地址** — JeecgBoot 后端地址,如 `https://boot3.jeecg.com/jeecgboot`
2. **X-Access-Token** — JWT 令牌,从浏览器 F12 → Network → 任意请求的 Request Headers 中复制

用户未提供时提示:
> 请提供 JeecgBoot 后端地址和 X-Access-Token。

---

## Step 1: 判断操作类型

根据用户意图判断操作类型:

| 用户意图关键词 | 操作 |
|---------------|------|
| 列出报表 / 查询报表 / 查看所有报表 / 有哪些报表 | **查询报表** → Step 2 |
| 创建 / 新建 / 做一个 / 生成报表 | **新增报表** → Step 3 |
| 修改 / 编辑 / 改字段 / 加字段 / 删除字段 | **编辑报表** → Step 4 |

> ⚠️ **菜单挂载与角色授权为可选操作,不得默认执行:**
> - 用户只说"创建报表"→ 仅执行 `create_report` + `validate_report`,**不挂载菜单,不授权角色**
> - 用户明确说"挂载到菜单"、"绑定菜单"、"授权给 xxx 角色"等关键词 → 才调用 `publish_report` 或 `create_and_publish`
> - 违反此规则会导致:超出用户意图、产生不必要的菜单记录、因全量拉取权限列表而显著增加耗时

---

## Step 2: 查询报表

> **API 初始化(统一入口)**:所有 Python 操作前必须先调用 `init_api`,与 `desform_utils` 保持一致:
> ```python
> import sys
> sys.path.insert(0, r'<skill目录>/scripts')
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add jeecgboot/skills/jeecg-onlreport@sha256:ec2c7c848b1a43d6

The line at the top of this page pins the label git:20260429.960f54a, 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_4ibtuzo445nvrlaj.svg)](https://markdownregistry.com/a/art_4ibtuzo445nvrlaj)

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

Versions

The registry has recorded 5 versions of this file, between Mar 14, 2026 and Apr 29, 2026, about one every 11 days. Its first recorded version is graded A and its latest B.

versioncommittedcommitsizeaudit
git:20260429.960f54a latest2026-04-29 960f54a 32,543 BB view · diff
git:20260422.a42ea2d2026-04-22 a42ea2d 30,996 BB view · diff
git:20260402.6afd8d12026-04-02 6afd8d1 20,639 BB view · diff
git:20260316.a70098c2026-03-16 a70098c 19,834 BA view · diff
git:20260314.b21d3622026-03-14 b21d362 20,116 BA view

Audit of the latest version

B  16 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • fail: No link to a raw IP address (matched: http://127.0.0.1)
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (32543 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 script tag

Starting a new one? Use a template for SKILL.md on mdpantry, which passes every one of these checks and says what to change in it.

Source

GitHub

jeecgboot/skills · 246 stars · license Apache-2.0 · pushed 2026-10-14 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_4ibtuzo445nvrlaj
GET https://markdownregistry.com/api/v1/resolve?ref=jeecgboot/skills/jeecg-onlreport
GET https://markdownregistry.com/api/v1/blob/ec2c7c848b1a43d6489f2deb6e6301f0184e3b569e08015b75cda73d2a65a034

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 jeecgboot/skills

jeecg-aiflow SKILL.md skill
jeecgboot/skills · jeecg-aiflow/SKILL.md · JeecgBoot AI 编排流程(AIFlow)全生命周期管理——通过自然语言描述需求,自动创建、编辑、查询、删除、调试、发布 AI 编排流程。 只要用户意图涉及「AI编排」「AIFlow」就必须使用本技能,包括但不限于: 创建 AI…
git:20260605.10fcd31 · audit A · 246 stars
jeecg-bpmn SKILL.md skill
jeecgboot/skills · jeecg-bpmn/SKILL.md · Use when user asks to create/generate/edit/modify a BPM workflow, design a Flowable BPMN process, or says "创建流程"…
git:20260917.6191383 · audit B · 246 stars
jeecg-codegen-new SKILL.md skill
jeecgboot/skills · jeecg-codegen-new/SKILL.md · Use when user asks to generate JeecgBoot CRUD code, create a new module, add/modify fields on existing module, or says…
git:20260917.6191383 · audit A · 246 stars
jeecg-codegen SKILL.md skill
jeecgboot/skills · jeecg-codegen/SKILL.md · Use when user asks to generate JeecgBoot CRUD code, create a new module, add/modify fields on existing module, or says…
git:20260605.10fcd31 · audit B · 246 stars
jeecg-uniapp-codegen SKILL.md skill
jeecgboot/skills · jeecg-codegen/uniapp/SKILL.md · JeecgBoot UniApp3 移动端 CRUD 代码生成器。Use when user asks to generate UniApp3/mobile/APP CRUD pages, create mobile list/form…
git:20260530.aca74a2 · audit A · 246 stars
jeecg-dev SKILL.md skill
jeecgboot/skills · jeecg-dev/SKILL.md · JeecgBoot 开发规范(仅手动触发)。⚠️ 本技能只在用户显式输入 /jeecg-dev 或 $jeecg-dev 命令时使用,禁止自动触发——编写/修改 JeecgBoot 代码、应用 GitHub PR/issue 改动、修复…
git:20260917.35cb223 · audit A · 246 stars
jeecg-onlchart SKILL.md skill
jeecgboot/skills · jeecg-onlchart/SKILL.md · Use when user asks to create/edit Online graph charts, data visualization, or says "创建图表", "生成图表", "新建图表", "做一个图表"…
git:20260422.a42ea2d · audit B · 246 stars
jeecg-onlform SKILL.md skill
jeecgboot/skills · jeecg-onlform/SKILL.md · JeecgBoot Online表单(cgform)全生命周期管理——通过API自动创建/编辑数据库表和表单配置, 支持单表、主子表、树表,26种控件类型,以及JS/Java/SQL增强、权限配置、数据CRUD、积木报表集成。…
git:20261014.84a0fc7 · audit A · 246 stars
jeecg-portal SKILL.md skill
jeecgboot/skills · jeecg-portal/SKILL.md · JeecgBoot 门户(Portal)全生命周期管理——通过 API 自动创建、删除、配置门户,管理门户内的 14 种组件(轮播图、新闻动态、系统公告、流程中心、应用快捷入口、协同待办、我的计划、知识库、文本、iframe…
git:20260917.5c242f4 · audit A · 246 stars
jeecg-system SKILL.md skill
jeecgboot/skills · jeecg-system/SKILL.md · JeecgBoot 系统主数据查询与管理。Use when user asks to query/create/manage system master data, or says "查询角色", "查询用户", "查询部门"…
git:20261014.84a0fc7 · audit A · 246 stars
jimubi-bigscreen SKILL.md skill
jeecgboot/skills · jimubi-bigscreen/SKILL.md · Use when user asks to create/design a big screen (大屏), full-screen data visualization, or says "创建大屏", "生成大屏", "新建大屏"…
git:20260530.aca74a2 · audit A · 246 stars
jimureport SKILL.md skill
jeecgboot/skills · jimureport/SKILL.md · 积木报表生成器 — 自然语言描述报表需求或提供截图,自动生成积木报表(支持数据报表、打印报表、分组报表、循环报表、数据填报等全类型)。Use when user says "积木报表", "jmreport", "Excel报表"…
git:20260917.f72212f · audit B · 246 stars

Every file in jeecgboot/skills

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