AgentSkillsCN

audit-case-rag

采用本地优先、事件驱动的 RAG 技术，助力商业地产审计与调查案例文件夹的高效管理。以“项目问题编号__标题”的命名方式索引案例目录（包含诸如 01_政策依据/02_流程/04_结算支付等阶段性子文件夹），并通过引用链接（file:// 链接 + PDF）进行精准查询。

SKILL.md
--- frontmatter
name: audit-case-rag
description: Local-first, event-driven RAG for commercial real estate audit & investigation case folders. Index a case directory named like "项目问题编号__标题" (with stage subfolders such as 01_policy_basis/02_process/04_settlement_payment) and query it with citations (file:// links + PDF #page). Use when you need to organize 50-200 mixed documents (PDF/DOCX/PPTX/XLSX) per case, enforce case_id+stage filtering, retrieve evidence fast, and answer questions with page-level references for workpapers, 整改闭环, or 举报线索调查.

audit-case-rag

This skill packages a local-only workflow to build a searchable evidence index for a single audit/investigation case and query it with page-level citations.

Workflow

0) Prepare a case folder (事件驱动)

Create a case directory named:

  • •<项目问题编号>__<标题>

Inside, use stage folders (stage is inferred from folder name):

  • •01_policy_basis/ (basis) — 制度/流程/授权
  • •02_process/ (process) — 招采/定标/过程证据
  • •03_contract/ (contract) — 合同/补充协议
  • •04_settlement_payment/ (payment) — 结算/付款/发票/验收
  • •05_comm/ (comm) — 邮件/会议纪要/IM
  • •06_interviews/ (interview) — 访谈/笔录/询证
  • •07_workpapers/ (workpaper) — 底稿/抽样/复核表
  • •09_rectification/ (rectification) — 整改/闭环

Full template: references/case-folder-template.md

1) Install dependencies (local)

From the skill folder (or copy the script into your repo):

bash
python3 -m venv .venv
source .venv/bin/activate
pip install -r scripts/requirements.txt

LibreOffice is recommended for Office→PDF page citations:

  • •soffice must be available (PATH) or pass --soffice /path/to/soffice.

2) Index the case

bash
./scripts/audit_case_rag.py index \
  --case-dir "/path/to/<项目问题编号>__<标题>" \
  --out-dir  "/path/to/audit_rag_db"

Outputs:

  • •manifest.jsonl written into the case directory
  • •audit_rag_db/<case_id>.joblib (persistent local index)

3) Query with event filters

bash
./scripts/audit_case_rag.py query \
  --case "<项目问题编号>" \
  --stage payment \
  "付款节点是否倒挂？请给出处页码"

Notes:

  • •Evidence lines include clickable file://...#page=N citations when possible.
  • •Retrieval is hybrid: embedding recall + TF‑IDF rerank (alpha configurable).

Safety/Privacy

  • •No cloud APIs. Everything runs locally.
  • •Do not commit outputs (indices, converted PDFs) to git.