mcpField
L
ln-650-persistence-performance-auditor

ln-650-persistence-performance-auditor

github.com/levnikolaevichData & databases584369 installsUpdated 2d ago
Repository

About ln-650-persistence-performance-auditor

A coordinator skill that audits persistence performance, query efficiency, transaction correctness, and resource lifecycle. It researches database and framework practices, delegates focused checks to four worker skills, and produces a consolidated report with remediation steps.

Key features

  1. 01Audits queries, transactions, runtime, and resources
  2. 02Requires best-practice research
  3. 03Delegates to four domain auditors
  4. 04Aggregates and deduplicates findings
  5. 05Produces a report and remediation plan

Use cases

  1. 01Reviewing a data layer for inefficient queries
  2. 02Checking transaction handling and correctness
  3. 03Assessing runtime performance and resource cleanup

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/levnikolaevich/claude-code-skills --skill ln-650-persistence-performance-auditor

After installing, type/ln-650-persistence-performance-auditorin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

references/
audit_final_report_contract.md
epistemic_protocol.md
evaluation_coordinator_runtime_contract.md
evaluation_research_contract.md
evaluation_summary_contract.md
meta_analysis_protocol.md
research_tool_fallback.md

Details

From the project README

Paths: File paths (references/, ../ln-*) are relative to this skill directory.

Type: L2 Coordinator Category: 6XX Audit

Persistence Performance Auditor

Mandatory Read

MANDATORY READ: Load references/evaluation_coordinator_runtime_contract.md, references/evaluation_summary_contract.md, references/evaluation_research_contract.md MANDATORY READ: Load references/audit_final_report_contract.md MANDATORY READ: Load references/research_tool_fallback.md Conditional read: load references/epistemic_protocol.md only when source confidence or claim uncertainty affects issue validation.

Purpose

  • audit query efficiency, transaction correctness, runtime performance, and resource lifecycle
  • coordinate ln-651 through ln-654
  • require database and framework best-practice research before scoring

Runtime Contract

Runtime family:

  • evaluation-runtime

Identifier:

  • persistence-audit

Phase order:

  1. PHASE_0_CONFIG
  2. PHASE_1_DISCOVERY
  3. PHASE_2_RESEARCH
  4. PHASE_3_DELEGATE
  5. PHASE_4_AGGREGATE
  6. PHASE_5_REPORT
  7. PHASE_6_SELF_CHECK

Worker Set

  • ln-651-query-efficiency-auditor
  • ln-652-transaction-correctness-auditor
  • ln-653-runtime-performance-auditor
  • ln-654-resource-lifecycle-auditor

Worker Invocation (MANDATORY)

Host Skill Invocation: Skill(skill: "...", args: "...") is mandatory delegation.

  • Claude: call the Skill tool exactly as shown.
  • Codex: if no Skill tool exists, locate the named skill in available skills, read its SKILL.md, treat args as $ARGUMENTS, execute that skill workflow, then return here with its result/artifact.
  • Do not inline worker logic or mark the worker complete without executing the target skill.

Use the Skill tool for delegated workers. Do not inline worker logic inside the coordinator.

TodoWrite format (mandatory):

  • Resolve audit scope and build manifest
  • Load data layer and runtime profile
  • Run best-practice research
  • Delegate to domain audit workers
  • Aggregate worker findings
  • Generate final audit report and remediation plan
  • Verify cleanup and self-check

Representative invocations:

Skill(skill: "ln-651-query-efficiency-auditor", args: "{scope}")
Skill(skill: "ln-652-transaction-correctness-auditor", args: "{scope}")
Skill(skill: "ln-653-runtime-performance-auditor", args: "{scope}")
Skill(skill: "ln-654-resource-lifecycle-auditor", args: "{scope}")

Workflow

  1. Start evaluation-runtime.
  2. Discover database, ORM, transaction, and runtime context.
  3. Perform mandatory research.
  4. Delegate specialized workers.
  5. Aggregate findings into one persistence-performance audit by reading every worker report_path, normalizing and deduplicating issues, and validating actionable problems against references/evaluation_research_contract.md.
  6. Write .hex-skills/runtime-artifacts/runs/{run_id}/audit-report/ln-650--final-report.md with remediation plan per references/audit_final_report_contract.md.
  7. Remove temporary worker markdown reports and record cleanup evidence.
  8. Write the evaluation-coordinator summary with report_path set to the final report.

Definition of Done

  • Evaluation runtime started
  • Persistence context discovered
  • Mandatory research completed
  • All planned worker summaries recorded
  • Final report and remediation plan written
  • Temporary worker markdown reports removed
  • evaluation-coordinator summary written
  • Runtime completed

Meta-Analysis

Optional reference: load references/meta_analysis_protocol.md only when the user asks for post-run meta-analysis or protocol-formatted run reflection.

When requested after the coordinator run, analyze the session per protocol section 7 and include the protocol-formatted output with the final persistence-performance audit result.

References

  • Workers: ../ln-651-query-efficiency-auditor/SKILL.md, ../ln-652-transaction-correctness-auditor/SKILL.md, ../ln-653-runtime-performance-auditor/SKILL.md, ../ln-654-resource-lifecycle-auditor/SKILL.md

Version: 1.1.0 Last Updated: 2026-03-15

Comments

Markdown supported