\n\n- **HOLMES**: Wesley’s main evidence investigation. It decides whether the cited proof is strong enough to justify shipping this commit.\n- **WATSON**: An independent verification pass. It checks Holmes’s citations and score math instead of trusting them blindly.\n- **MORIARTY**: A readiness forecast over time. It is advisory trend analysis, not the release gate itself.\n- **Schema coverage score (SCS)**: How much of the schema has direct supporting evidence across generated artifacts and cited proof.\n- **Test confidence index (TCI)**: How much test evidence exists for constraints, policies, relationships, and operations.\n- **Migration risk index (MRI)**: How risky the schema change is to roll out. Lower is better.\n- **Evidence trust**: Whether the report is backed by exact citations, whole-file citations, or coarse references. Weak trust means the claim may be directionally right but not specific enough to trust blindly.\n- **Citation quality**: A count of exact line-span citations versus whole-file or coarse references.\n- **ELEMENTARY**: Ready to ship based on the current evidence.\n- **REQUIRES INVESTIGATION**: More work or review is needed before shipping.\n- **YOU SHALL NOT PASS**: Do not ship this change in its current state.\n\n

🕵️ SHA-lock HOLMES full report (click to expand)

\n\n### 🕵️ SHA-lock HOLMES Investigation\n\n- Generated: 2026-01-01T00:00:00.000Z\n- Commit SHA: ecab8d2021db3bc26511fa8d42d911e66c132f17\n- Bundle Version: 2.0.0\n\n> ⚠️ Evidence valid only for commit `ecab8d2`\n\n## 🔍 Executive Deduction\n\n\"Watson, after careful examination of the evidence, I deduce...\"\n\n**Weighted Completion**: ██████████ 95.0%\n**Scores**: SCS 95.0% · TCI 90.0% · MRI 10.0%\n**Verification Status**: 2 claims verified\n**Citation Quality**: 2 exact · 0 whole-file · 0 coarse\n**Evidence Trust**: strong\n**Ship Verdict**: ELEMENTARY\n\n## 🧩 SCS Breakdown\n\n| Component | Score | Coverage |\n|-----------|-------|----------|\n| Sql | 100.0% | 1.00/1.00 |\n| Types | 100.0% | 1.00/1.00 |\n| Validation | 100.0% | 1.00/1.00 |\n| Tests | 100.0% | 1.00/1.00 |\n\n## 🧪 TCI Breakdown\n\n| Component | Score | Coverage | Note |\n|-----------|-------|----------|------|\n| Unit Constraints | 100.0% | 1/1 | N/A |\n| Unit Rls | 100.0% | 1/1 | N/A |\n| Integration Relations | 100.0% | 1/1 | N/A |\n| E2e Ops | 90.0% | 9/10 | fixture |\n\n## ⚠️ MRI Breakdown\n\n| Component | Risk Share | Points | Count |\n|-----------|------------|--------|-------|\n| Drops | 0.0% | 0 | 0 |\n| Renames Without Uid | 0.0% | 0 | 0 |\n| Add Not Null Without Default | 100.0% | 1 | 1 |\n| Non Concurrent Indexes | 0.0% | 0 | 0 |\n\n## 📊 The Weight of Evidence\n\n\"Observe, Watson, how not all features carry equal importance...\"\n\n| Element | Weight | Status | Evidence | Strength | Deduction |\n|---------|--------|--------|----------|----------|-----------|\n| schema | 5 | ✅ Exact SQL & tests | test/fixtures/examples/.wesley-cache/shipme-fixture/tests.sql:1-1@ecab8d2 | exact | Elementary! |\n\n## 🚪 Security & Performance Gates\n\n\"Elementary security measures, Watson...\"\n\n| Gate | Status | Evidence | Holmes's Ruling |\n|------|--------|----------|-----------------|\n| Migration Risk | ✅ | MRI: 10.0% | \"Trivial risk\" |\n| Test Coverage | ✅ | TCI: 90.0% | \"Excellent coverage\" |\n| Sensitive Fields | ✅ | 0 fields | \"All secured\" |\n| Evidence Quality | ✅ | 2 exact · 0 whole-file · 0 coarse | \"All 2 citations resolve to exact line spans.\" |\n\n## 📋 The Verdict\n\n✅ **ELEMENTARY** - Ship immediately!\n\"The evidence is conclusive. No mysteries remain.\"\n\nSigned and sealed,\n- S. Holmes, Consulting Detective\n\n[END OF INVESTIGATION FOR COMMIT ecab8d2]\n\n## 🧵 Command Run\n\n- Run ID: run-81fb8b86-9372-4505-88d6-f2bec6da7951\n- Transmutation: holmes-investigate\n- Command: investigate\n- Status: completed\n- Ledger: /home/runner/work/wesley/wesley/test/fixtures/examples/.wesley-cache/ledger\n\n

\n\n---\n\n

🩺 Dr. WATSON full report (click to expand)

\n\n### 🩺 Dr. Watson's Independent Verification Report\n\n_Medical Examination of Evidence_\n\n- Examination Date: 2026-06-17T09:38:38.975Z\n- Patient SHA: ecab8d2021db3bc26511fa8d42d911e66c132f17\n\n## 🔬 Citation Verification\n\n\"Let me examine each piece of evidence independently...\"\n\n- **Citations Examined**: 2\n- **Verified**: 0 ✅\n- **Failed**: 0 ❌\n- **Unable to Verify**: 2\n- **Exact Subrange Citations**: 0\n- **Whole-file Citations**: 0\n- **Coarse Citations**: 0\n- **Evidence Trust**: missing\n- **Trust Note**: No evidence citations were available for trust analysis.\n\n**Verification Rate**: 0.0%\n\n## 📊 Mathematical Verification\n\n\"I shall recalculate Holmes's arithmetic...\"\n\nHolmes claimed SCS: 95.0%\nWatson calculates: 100.0%\nDifference: ⚠️ Significant\n\n## 🔍 Consistency Analysis\n\n\"Checking for contradictions in Holmes's deductions...\"\n\n✅ No logical inconsistencies detected\n\n## 🩺 Dr. Watson's Medical Opinion\n\n**VERIFICATION: CONCERNS NOTED** ⚠️\n\n\"While Holmes's methods are generally sound, I have noted some\"\n\"discrepancies that warrant further investigation. No evidence citations were available for trust analysis.\"\n\nRespectfully submitted,\n- Dr. J. Watson, M.D.\n Medical Examiner & Verification Specialist\n\n## 🧵 Command Run\n\n- Run ID: run-2dc19b50-0228-49c7-94d7-0adfcfe79ee0\n- Transmutation: watson-verify\n- Command: verify\n- Status: completed\n- Ledger: /home/runner/work/wesley/wesley/test/fixtures/examples/.wesley-cache/ledger\n\n

\n\n---\n\n

🔮 Professor MORIARTY full report (click to expand)

\n\n### 🧠 Professor Moriarty's Temporal Predictions\n\n_The Mathematics of Inevitability_\n\n- Analysis Date: 2026-06-17T09:39:18.713Z\n\n**INSUFFICIENT DATA**\n\n> \"I require at least two data points to predict the future.\"\n> \"Run Wesley generate multiple times to build history.\"\n\n## 🧵 Command Run\n\n- Run ID: run-17d26c7b-a393-4be4-908b-dacd4675d0d9\n- Transmutation: moriarty-predict\n- Command: predict\n- Status: completed\n- Ledger: /home/runner/work/wesley/wesley/test/fixtures/examples/.wesley-cache/ledger\n\n