{"api":"v1","generated_at":"2026-09-15T21:46:36.164Z","licence":{"name":"CC BY 4.0","url":"https://creativecommons.org/licenses/by/4.0/","attribution":"TOLL, with a link to the page cited"},"page":"https://tollindex.com/e/intel-rallylive-ca-dev-sql-format-2a2ae6","pinned_page":"https://tollindex.com/e/intel-rallylive-ca-dev-sql-format-2a2ae6/at/2026-09-15T21-20Z","pinned":false,"method":"https://tollindex.com/ledger/method","snapshot_at":"2026-09-15T21:20:12.737Z","snapshot_stamp":"2026-09-15T21-20Z","endpoint":{"slug":"intel-rallylive-ca-dev-sql-format-2a2ae6","canonical_url":"https://intel.rallylive.ca/dev/sql-format","resource":"https://intel.rallylive.ca/dev/sql-format","http_method":"POST","type":"http","x402_version":2,"registries":["cdp"],"primary_registry":"cdp","curated_by_coinbase":false,"description":"SQL formatter: upper-cases keywords, breaks the statement into SELECT/FROM/JOIN/WHERE/GROUP BY/ORDER BY clauses, one column per line, indents AND/OR, and reports the statement type, tables referenced and whether it looks like a write (INSERT/UPDATE/DELETE/DROP). Works on most ANSI SQL dialects. $0.01 per statement.","service_name":"sql-format","declared_category":null,"declared_tags":["sql","format","query","readability","database"],"route_template":null,"registry_updated":"2026-09-13T10:27:06.758Z"},"derived":{"note":"fields no registry supplies; TOLL derives them and marks them derived on the page","title":"dev sql format","category":"scraping","first_observed_by_toll":"2026-09-12T04:32:46.837Z","last_observed_by_toll":"2026-09-15T21:20:12.737Z","observation_began":"2026-09-10"},"presence":{"listed_now":true,"first_absent_at":null,"delisting_confirmed_at":null,"events":[{"registry":"cdp","at":"2026-09-12T04:32:46.838Z","event":"listed"}]},"accepts":[{"registry":"cdp","ordinal":0,"network":"eip155:8453","asset":"0x833589fcd6edb6e08f4c7c32d4f71b54bda02913","asset_name":"USD Coin","symbol":"USDC","decimals":6,"amount_display":"0.01 USDC","amount_units":0.01,"decimals_known":true,"pay_to":"0x91D568599fB802Cb3f03F067D2063785dBAF0abd","scheme":"exact"},{"registry":"cdp","ordinal":1,"network":"eip155:84532","asset":"0x036cbd53842c5426634e7929541ec2318f3dcf7e","asset_name":"USDC","symbol":"USDC","decimals":6,"amount_display":"0.01 USDC","amount_units":0.01,"decimals_known":true,"pay_to":"0x91D568599fB802Cb3f03F067D2063785dBAF0abd","scheme":"exact"}],"counters":{"observed_at":"2026-09-15T21:20:12.737Z","calls_30d":2,"unique_payers_30d":2,"last_called_at":"2026-09-13T10:27:06.651Z"},"validation":{"latest":{"observed_at":"2026-09-15T04:16:25.293Z","state":"pass","failed_checks":[],"endpoint_http_status":402,"run_id":"daily-2026-09-15"},"uptime":[{"days":7,"observed":5,"passed":5,"ratio":1},{"days":30,"observed":5,"passed":5,"ratio":1},{"days":90,"observed":5,"passed":5,"ratio":1}],"history_90d":[{"observed_at":"2026-09-15T04:16:25.293Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-15","state_changed":false},{"observed_at":"2026-09-14T04:14:15.809Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-14","state_changed":false},{"observed_at":"2026-09-13T04:13:46.525Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-13","state_changed":false},{"observed_at":"2026-09-12T06:29:09.401Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-12","state_changed":false},{"observed_at":"2026-09-12T05:13:31.944Z","state":"pass","failed_checks":[],"run_id":"new-2026-09-12T05-13-20-874Z","state_changed":true}]},"seller":{"wallet":"0x91D568599fB802Cb3f03F067D2063785dBAF0abd","page":"https://tollindex.com/seller/0x91D568599fB802Cb3f03F067D2063785dBAF0abd","endpoints":820,"hosts":1},"reports":0,"registry_record":{"cdp":[{"tags":["sql","format","query","readability","database"],"type":"http","accepts":[{"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","extra":{"name":"USD Coin","version":"2"},"payTo":"0x91D568599fB802Cb3f03F067D2063785dBAF0abd","amount":"10000","scheme":"exact","network":"eip155:8453","maxTimeoutSeconds":120},{"asset":"0x036CbD53842c5426634e7929541eC2318f3dCF7e","extra":{"name":"USDC","version":"2"},"payTo":"0x91D568599fB802Cb3f03F067D2063785dBAF0abd","amount":"10000","scheme":"exact","network":"eip155:84532","maxTimeoutSeconds":120}],"quality":{"lastCalledAt":"2026-09-13T10:27:06.651Z","l30DaysTotalCalls":2,"l30DaysUniquePayers":2},"resource":"https://intel.rallylive.ca/dev/sql-format","extensions":{"bazaar":{"info":{"input":{"body":{"text":"select u.id, u.name, count(o.id) as orders from users u left join orders o on o.user_id = u.id where u.active = true and u.created_at > '2026-01-01' group by u.id, u.name order by orders desc limit 20"},"type":"http","method":"POST","bodyType":"json"},"output":{"type":"json","example":{"type":"SELECT","tables":["users","orders"],"is_write":false,"formatted":"SELECT u.id,\n  u.name…"}}},"schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"properties":{}},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}}}},"description":"SQL formatter: upper-cases keywords, breaks the statement into SELECT/FROM/JOIN/WHERE/GROUP BY/ORDER BY clauses, one column per line, indents AND/OR, and reports the statement type, tables referenced and whether it looks like a write (INSERT/UPDATE/DELETE/DROP). Works on most ANSI SQL dialects. $0.01 per statement.","lastUpdated":"2026-09-13T10:27:06.758Z","serviceName":"sql-format","x402Version":2}]}}