{"api":"v1","generated_at":"2026-10-11T16:46:35.492Z","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/aayatai-com-sql-explain-1841cf","pinned_page":"https://tollindex.com/e/aayatai-com-sql-explain-1841cf/at/2026-10-11T12-46Z","pinned":false,"method":"https://tollindex.com/ledger/method","snapshot_at":"2026-10-11T12:46:55.838Z","snapshot_stamp":"2026-10-11T12-46Z","endpoint":{"slug":"aayatai-com-sql-explain-1841cf","canonical_url":"https://aayatai.com/sql/explain","resource":"https://aayatai.com/sql/explain","http_method":"POST","type":"http","x402_version":2,"registries":["cdp"],"primary_registry":"cdp","curated_by_coinbase":false,"description":"Explain and sanity-check a SQL query before running it: statement type, tables touched, syntax problems (quotes, parentheses, = NULL), risky patterns (UPDATE/DELETE without WHERE, DROP, NOT IN with NULLs, cartesian joins, non-sargable filters, multiple statements) and a plain-English explanation. POST {sql, dialect}.","service_name":"Aayat AI","declared_category":null,"declared_tags":["sql","database","validation","explain","coding"],"route_template":null,"registry_updated":"2026-10-08T06:10:28.798Z"},"derived":{"note":"fields no registry supplies; TOLL derives them and marks them derived on the page","title":"sql explain","category":"market-data","first_observed_by_toll":"2026-09-28T13:51:25.436Z","last_observed_by_toll":"2026-10-11T12:46:55.838Z","observation_began":"2026-09-10"},"presence":{"listed_now":true,"first_absent_at":null,"delisting_confirmed_at":null,"events":[{"registry":"cdp","at":"2026-09-28T13:51:25.437Z","event":"listed"}]},"accepts":[{"registry":"cdp","ordinal":0,"network":"eip155:8453","asset":"0x833589fcd6edb6e08f4c7c32d4f71b54bda02913","asset_name":"USD Coin","symbol":"USDC","decimals":6,"amount_display":"0.003 USDC","amount_units":0.003,"decimals_known":true,"pay_to":"0xbA7d7DcA32B3659DbAB451E5b408FF8F23F13442","scheme":"exact"},{"registry":"cdp","ordinal":1,"network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","asset":"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v","asset_name":null,"symbol":"USDC","decimals":6,"amount_display":"0.003 USDC","amount_units":0.003,"decimals_known":true,"pay_to":"Byc8ebwdxxB4u4U9xuMnH9HwwKTV4JYAFLeU1jNCCT4Q","scheme":"exact"},{"registry":"cdp","ordinal":2,"network":"eip155:137","asset":"0x3c499c542cef5e3811e1192ce70d8cc03d5c3359","asset_name":"USD Coin","symbol":"USDC","decimals":6,"amount_display":"0.003 USDC","amount_units":0.003,"decimals_known":true,"pay_to":"0xbA7d7DcA32B3659DbAB451E5b408FF8F23F13442","scheme":"exact"},{"registry":"cdp","ordinal":3,"network":"eip155:42161","asset":"0xaf88d065e77c8cc2239327c5edb3a432268e5831","asset_name":"USD Coin","symbol":"USDC","decimals":6,"amount_display":"0.003 USDC","amount_units":0.003,"decimals_known":true,"pay_to":"0xbA7d7DcA32B3659DbAB451E5b408FF8F23F13442","scheme":"exact"}],"counters":{"observed_at":"2026-10-11T12:46:55.838Z","calls_30d":3,"unique_payers_30d":3,"last_called_at":"2026-10-08T06:10:28.682Z"},"validation":{"latest":{"observed_at":"2026-10-11T04:36:57.268Z","state":"pass","failed_checks":[],"endpoint_http_status":402,"run_id":"daily-2026-10-11"},"uptime":[{"days":7,"observed":7,"passed":7,"ratio":1},{"days":30,"observed":15,"passed":14,"ratio":0.9333333333333333},{"days":90,"observed":15,"passed":14,"ratio":0.9333333333333333}],"history_90d":[{"observed_at":"2026-10-11T04:36:57.268Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-11","state_changed":false},{"observed_at":"2026-10-10T09:53:50.927Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-10","state_changed":false},{"observed_at":"2026-10-09T04:38:32.499Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-09","state_changed":false},{"observed_at":"2026-10-08T06:16:13.962Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-08","state_changed":false},{"observed_at":"2026-10-07T05:26:40.638Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-07","state_changed":false},{"observed_at":"2026-10-06T06:19:31.860Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-06","state_changed":false},{"observed_at":"2026-10-05T06:05:40.236Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-05","state_changed":false},{"observed_at":"2026-10-04T08:54:52.204Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-04","state_changed":false},{"observed_at":"2026-10-03T04:14:08.511Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-03","state_changed":false},{"observed_at":"2026-10-02T13:24:02.212Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-02","state_changed":false},{"observed_at":"2026-10-01T06:37:43.875Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-01","state_changed":false},{"observed_at":"2026-09-30T05:55:01.852Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-30","state_changed":false},{"observed_at":"2026-09-29T18:15:57.439Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-29","state_changed":true},{"observed_at":"2026-09-28T16:52:59.480Z","state":"fail","failed_checks":["endpoint_reachable"],"run_id":"daily-2026-09-28","state_changed":true},{"observed_at":"2026-09-28T15:07:25.430Z","state":"pass","failed_checks":[],"run_id":"new-after-daily-2026-09-28","state_changed":true}]},"seller":{"wallet":"0xbA7d7DcA32B3659DbAB451E5b408FF8F23F13442","page":"https://tollindex.com/seller/0xbA7d7DcA32B3659DbAB451E5b408FF8F23F13442","endpoints":102,"hosts":1},"reports":0,"registry_record":{"cdp":[{"tags":["sql","database","validation","explain","coding"],"type":"http","accepts":[{"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","extra":{"name":"USD Coin","version":"2"},"payTo":"0xbA7d7DcA32B3659DbAB451E5b408FF8F23F13442","amount":"3000","scheme":"exact","network":"eip155:8453","maxTimeoutSeconds":60},{"asset":"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v","extra":{"feePayer":"BENrLoUbndxoNMUS5JXApGMtNykLjFXXixMtpDwDR9SP"},"payTo":"Byc8ebwdxxB4u4U9xuMnH9HwwKTV4JYAFLeU1jNCCT4Q","amount":"3000","scheme":"exact","network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","maxTimeoutSeconds":60},{"asset":"0x3c499c542cEF5E3811e1192ce70d8cC03d5c3359","extra":{"name":"USD Coin","version":"2"},"payTo":"0xbA7d7DcA32B3659DbAB451E5b408FF8F23F13442","amount":"3000","scheme":"exact","network":"eip155:137","maxTimeoutSeconds":60},{"asset":"0xaf88d065e77c8cC2239327C5EDb3A432268e5831","extra":{"name":"USD Coin","version":"2"},"payTo":"0xbA7d7DcA32B3659DbAB451E5b408FF8F23F13442","amount":"3000","scheme":"exact","network":"eip155:42161","maxTimeoutSeconds":60}],"quality":{"lastCalledAt":"2026-10-08T06:10:28.682Z","l30DaysTotalCalls":3,"l30DaysUniquePayers":3},"resource":"https://aayatai.com/sql/explain","extensions":{"bazaar":{"info":{"input":{"body":{"sql":"DELETE FROM users WHERE last_login < NOW() - INTERVAL '2 years'","dialect":"postgres"},"type":"http","method":"POST","bodyType":"json"},"output":{"type":"json","example":{"type":"DELETE","valid":true,"tables":["users"],"verdict":"ok","findings":[],"statements":1,"explanation":"Deletes every user whose last login was more than two years ago."}}},"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":{"type":"object","required":["sql"],"properties":{"sql":{"type":"string","maxLength":8000,"minLength":5,"description":"The SQL to check."},"dialect":{"enum":["postgres","mysql","sqlite","sqlserver","generic"],"type":"string","default":"generic","description":"SQL dialect (used in the explanation)."}}},"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","required":["valid","type","tables","findings","verdict","explanation"],"properties":{"type":{"type":"string"},"valid":{"type":"boolean","description":"False if a syntax problem was found (heuristic checks, not a full parser)."},"tables":{"type":"array","items":{"type":"string"}},"verdict":{"enum":["ok","review","dangerous","invalid"],"type":"string"},"findings":{"type":"array","items":{"type":"object"},"description":"error / danger / warning / info, with codes and messages."},"statements":{"type":"integer"},"explanation":{"type":"string"}}}}}}}}},"description":"Explain and sanity-check a SQL query before running it: statement type, tables touched, syntax problems (quotes, parentheses, = NULL), risky patterns (UPDATE/DELETE without WHERE, DROP, NOT IN with NULLs, cartesian joins, non-sargable filters, multiple statements) and a plain-English explanation. POST {sql, dialect}.","lastUpdated":"2026-10-08T06:10:28.798Z","serviceName":"Aayat AI","x402Version":2}]}}