script
unanchored
d1-count-all-tables
Count rows in every known table of helios-ledger D1.
d1sqlmonitoringcloudflare
Body
Set-Location "$env:USERPROFILE\\HELIOS\\helios-worker"\n$tables=@("records","merkle_tree","accounts","chatlog","commons_stamps","commons_registry","commons_members")\nforeach($t in $tables){\n $raw=npx wrangler d1 execute helios-ledger --command "SELECT COUNT(*) as n FROM $t" --remote --json 2>&1\n try{$n=($raw|ConvertFrom-Json)[0].results[0].n;Write-Output "$t`: $n"}catch{Write-Output "$t`: error"}\n}
Provenance
Cryptographic details
| id | reg_d1_count_tables |
| content sha256 | d59c051ef18aad8c64d73052049b675a20820177bc0636ac62210b0782448f28 |
Execute via API
POST /api/execute
{ "ref": "reg_d1_count_tables" }
// or by hash prefix:
{ "ref": "d59c051ef18aad8c" }
Resolves this artifact by hash — deterministic, provenance-proven. Generation cost is zero when the hash exists.