{"slug":"sqlite-query-from-a-question-ca85f041","name":"SQLite Query From a Question","summary":"SQLite Query From a Question for D1 — Writes the SQL query for SQLite or Cloudflare D1 that answers a question about the data, from the question and the table definitions you paste, so it returns the right rows and not only rows that look right. Knows where plain-language questions turn into wrong results on SQLite - NOT IN against a column that holds NULL, integer division in percentages and money, COUNT of a column that holds NULLs, a LEFT JOIN that a WHERE turns back into an inner join, two …","status":"live","headings":[{"slug":"databases","title":"Databases"}],"indexable":true,"listed_since":"2026-10-25T17:52:13.721731Z","sources":[{"source":"x402_bazaar","external_id":"https://api.aiskills402.com/v1/skills/sqlite-query-from-question/file","owner_address":"0xbc0dcc70d8b5d85541d86ffc68d988fd59c22e68","seen_at":"2026-11-10T07:55:42.921167Z","removed_at":null}],"endpoints":[{"url":"https://api.aiskills402.com/v1/skills/sqlite-query-from-question/file","host":"api.aiskills402.com","protocol":"x402","state":"live","last_probe_at":"2026-11-09T20:33:42.334369Z","last_ok_at":"2026-11-09T20:33:42.334369Z","tools_count":null,"tools_changed_at":null,"uptime_24h":1.0,"uptime_30d":1.0}],"also_listed_as":[{"slug":"api-aiskills402-com-62d86cc3","name":"api.aiskills402.com"}],"payment_options":[{"endpoint_url":"https://api.aiskills402.com/v1/skills/sqlite-query-from-question/file","network":"eip155:8453","scheme":"exact","rail":"exact","asset":"0x833589fcd6edb6e08f4c7c32d4f71b54bda02913","coin":"USDC","asset_label":"USD Coin","amount":"30000","pay_to":"0xbc0dcc70d8b5d85541d86ffc68d988fd59c22e68","observed_at":"2026-11-09T20:33:42.334369Z"}],"usage":{"source":"x402_bazaar","unique_payers_30d":2,"paid_calls_30d":3,"last_paid_at":"2026-11-02T19:20:17.492Z","reported_at":"2026-11-10T07:55:42.921167Z"},"assessment":{"method":"2026.10.2","checks":[{"id":"answers","state":"pass","reason":"Answered a check 3 hours ago."},{"id":"owner","state":"fail","reason":"No one has proven control of its domain or of the wallet it is paid at."},{"id":"track_record","state":"fail","reason":"Listed for 15 days; 30 are needed."},{"id":"real_customers","state":"fail","reason":"2 different wallets paid it in 30 days, as the x402 Bazaar reports (not yet counted by addrbook); 10 are needed."},{"id":"clean_scan","state":"not_applicable","reason":"Not an MCP server."}],"passed":1,"applicable":4,"contradicted":false,"computed_at":"2026-11-10T00:27:02.088744Z"},"identity":{"endpoint_domains":["aiskills402.com"],"proven_domains":[],"proven_wallets":[],"namesakes":[],"namesake_count":0,"identity_checks":[],"wallet_attestations":[],"human_backings":[]},"replies":[],"customers":null,"scan":null,"notice":"Not affiliated with addrbook — claim or request removal."}