outputs/db_chain_api_final.md

DB + Chain + API Audit — Final Report

Iterations run: 3 Total checks per iteration: 140

Summary (last iteration)

• Passed: 127 / 140
• Failed: 13
• Critical failures: 0
• Wall time: 38.12s

Per-iteration totals

Iter	Passed	Failed	Critical
1	128	12	0
2	126	14	0
3	127	13	0

Failed checks (last iteration)

• [4] A:DB :: few_shot D1-D8 +/- distribution — missing/imbalanced dims: ['D2']
• [7] A:DB :: backtest_results >= 100 — count=0
• [10] A:DB :: recent SUBMITTED events have 4 bids — violating_events=16 (over last 30 SUBMITTED events)
• [11] A:DB :: recent SUBMITTED events have >=2 distinct bid amounts — violating_events=12 (over last 30 SUBMITTED events)
• [12] A:DB :: recent winner (translator) == lowest bidder — violating_events=1 (over last 30 SUBMITTED events)
• [17] A:DB :: recent questions.builder_code matches env — violating=14, expected=0xa93402f8ae6a... (over last 30 events)
• [22] A:DB :: recent SUBMITTED events have questions.tx_hash — missing=15 (over last 30 events)
• [29] A:DB :: corpus_markets framing_pattern populated — non_null_count=0 (currently all NULL - feature not yet tagged)
• [30] A:DB :: sources table populated (>=8 RSS sources) — count=0 (sources table is unused / replaced by inline source JSON)
• [37] A:DB :: recent bids.agent_address looks like an addr — violating=12 (over last 30 SUBMITTED events)
• [89] B:Chain :: event logs present: BuilderFee-like — addr=0xcE7596d9..., log_count=0
• [90] B:Chain :: event logs present: ReputationUpdated-like — addr=0x00267FD2..., log_count=0
• [99] B:Chain :: historical tx#4 still on chain — tx=0x7afb4209afe8c88d..., found_on=None

DB row count snapshot

• corpus_markets: 75885
• events: 111
• events SUBMITTED: 79
• bids: 174
• translations: 94
• quality_scores: 93
• polymarket_submissions: 79
• questions: 79
• builder_fee_events: 79
• agent_reputation: 94

Report generated by scripts/db_chain_api_runner.py.