{"api_version":2,"receipt_profile":"zambo-hosted-receipt/1","schema_url":"https://zambo.dev/aer-1/hosted-profile.schema.json","id":"5d2092c7-f427-435d-9229-a14da6e836d5","source_url":"https://zambo.dev/api/receipt/5d2092c7-f427-435d-9229-a14da6e836d5","receipt":{"id":"5d2092c7-f427-435d-9229-a14da6e836d5","created_at":"2026-10-06T03:05:03.268Z","receipt_schema_version":"0.3","job_summary":"MCP tool execution: sql_from_english","tools":["sql_from_english"],"steps":[{"tool":"sql_from_english","status":"success","started_at":"2026-10-06T03:04:59.636Z","completed_at":"2026-10-06T03:05:03.166Z"}],"output_hash":"sha256:31e056ad77dbd92bdb5600b143c06146b55fc4369e9415732447c6f5f7d47d76","hash_algorithm":"sha256","canonical_bytes":"eyJjYWxsZXIiOnsiaWQiOiJzaGEyNTY6NDYyZTU4YTdjNzFlMjkwODM4MjUxM2EyYjNhYTY1MjZhZDg4MmUzMTVkYTU3NDY3MjhjOTQzMTMwYWVhNmRhNCIsInR5cGUiOiJhbm9ueW1vdXMifSwib3V0cHV0Ijp7InRleHQiOiJ7XCJzcWxcIjpcIlNFTEVDVCBpZCwgZW1haWwsIGNyZWF0ZWRfYXQgRlJPTSB1c2VycyBXSEVSRSBjcmVhdGVkX2F0ID49IGRhdGVfdHJ1bmMoJ21vbnRoJywgQ1VSUkVOVF9EQVRFKSBPUkRFUiBCWSBjcmVhdGVkX2F0IEFTQztcIixcImV4cGxhbmF0aW9uXCI6XCJTZWxlY3RzIHRoZSBpZCwgZW1haWwsIGFuZCBjcmVhdGlvbiB0aW1lc3RhbXAgZm9yIGFsbCB1c2VycyB3aG9zZSBzaWdudXAgZGF0ZSBmYWxscyB3aXRoaW4gdGhlIGN1cnJlbnQgY2FsZW5kYXIgbW9udGgsIHNvcnRlZCBjaHJvbm9sb2dpY2FsbHkgZnJvbSBvbGRlc3QgdG8gbmV3ZXN0LlwiLFwiaW5kZXhlc19uZWVkZWRcIjpbXCJDUkVBVEUgSU5ERVggaWR4X3VzZXJzX2NyZWF0ZWRfYXQgT04gdXNlcnMgKGNyZWF0ZWRfYXQpO1wiXSxcInBlcmZvcm1hbmNlX25vdGVzXCI6XCJVc2luZyBkYXRlX3RydW5jKCdtb250aCcsIENVUlJFTlRfREFURSkgaXMgc2FyZ2FibGUgYW5kIGFsbG93cyB0aGUgZGF0YWJhc2UgdG8gdXRpbGl6ZSBhbiBpbmRleCBvbiBjcmVhdGVkX2F0IGVmZmljaWVudGx5LiBBdm9pZCB3cmFwcGluZyB0aGUgY29sdW1uIGluIGZ1bmN0aW9ucyBsaWtlIEVYVFJBQ1Qgb3IgREFURSgpIGluIHRoZSBXSEVSRSBjbGF1c2UsIGFzIHRoaXMgcHJldmVudHMgaW5kZXggdXNhZ2UgYW5kIGZvcmNlcyBhIGZ1bGwgdGFibGUgc2Nhbi5cIixcImNvbW1vbl9taXN0YWtlc1wiOlwiMS4gVXNpbmcgV0hFUkUgY3JlYXRlZF9hdCA9IENVUlJFTlRfREFURSAob25seSBnZXRzIHRvZGF5LCBub3QgdGhlIG1vbnRoKS4gMi4gVXNpbmcgV0hFUkUgRVhUUkFDVChNT05USCBGUk9NIGNyZWF0ZWRfYXQpID0gRVhUUkFDVChNT05USCBGUk9NIENVUlJFTlRfREFURSkgKG5vbi1zYXJnYWJsZSwgaWdub3JlcyB5ZWFyLCBhbmQgc2xvdykuIDMuIEZvcmdldHRpbmcgdG8gaW5jbHVkZSB0aGUgeWVhciBpbiB0aGUgY29tcGFyaXNvbiBpZiB1c2luZyBtYW51YWwgZGF0ZSBjb25zdHJ1Y3Rpb24uXCIsXCJ2YXJpYXRpb25zXCI6W1wiU0VMRUNUIGlkLCBlbWFpbCwgY3JlYXRlZF9hdCBGUk9NIHVzZXJzIFdIRVJFIGNyZWF0ZWRfYXQgPj0gZGF0ZV90cnVuYygnbW9udGgnLCBDVVJSRU5UX0RBVEUpIEFORCBjcmVhdGVkX2F0IDwgZGF0ZV90cnVuYygnbW9udGgnLCBDVVJSRU5UX0RBVEUpICsgSU5URVJWQUwgJzEgbW9udGgnIE9SREVSIEJZIGNyZWF0ZWRfYXQgQVNDO1wiLFwiU0VMRUNUIGlkLCBlbWFpbCwgY3JlYXRlZF9hdCBGUk9NIHVzZXJzIFdIRVJFIGNyZWF0ZWRfYXQgPj0gbWFrZV9kYXRlKENVUlJFTlRfREFURSAtIElOVEVSVkFMICcxIG1vbnRoJywgMSwgMSkgQU5EIGNyZWF0ZWRfYXQgPCBtYWtlX2RhdGUoQ1VSUkVOVF9EQVRFLCAxLCAxKSBPUkRFUiBCWSBjcmVhdGVkX2F0IEFTQztcIl0sXCJkaWFsZWN0XCI6XCJwb3N0Z3Jlc3FsXCJ9XG5cbiQwLjk5IERheSBQYXNzIMK3IDI0aCBhY2Nlc3MgwrcgVVNEQyBvbiBCYXNlIOKAlCBhY3RpdmF0ZSB3aXRoIGRheV9wYXNzX2FjdGl2YXRlLiJ9LCJyZWNlaXB0X3NjaGVtYV92ZXJzaW9uIjoiMC4zIiwic2lkZV9lZmZlY3RzIjp7ImRlY2xhcmF0aW9uX2hhc2giOiJzaGEyNTY6NDVhYWQzOGYzYWE5ODJiOWFhZmU5MmVjYjQxNmViZTk4NzkxZWRkYmFmOGFiNmRmMGJkMDg2MDViN2MxYmZlZSIsImRlY2xhcmVkIjpbIm5vbmUiXSwic2NoZW1hX3ZlcnNpb24iOiJ6YW1iby1zaWRlLWVmZmVjdHMvMSJ9LCJ0b29sIjp7Im5hbWUiOiJzcWxfZnJvbV9lbmdsaXNoIiwic2NvcGUiOiJwdWJsaWMiLCJ2ZXJzaW9uIjoiNC4wLjAifX0=","canonical_bytes_withheld_for_privacy":false,"canonical_byte_length":1910,"verification_status":"legacy_receipt","session_trail":[],"result_preview":"{\"sql\":\"SELECT id, email, created_at FROM users WHERE created_at >= date_trunc('month', CURRENT_DATE) ORDER BY created_at ASC;\",\"explanation\":\"Selects the id, email, and creation timestamp for all users whose signup date falls within the current calendar month, sorted chronologically from oldest to newest.\",\"indexes_needed\":[\"CREATE INDEX idx_users_created_at ON users (created_at);\"],\"performance_notes\":\"Using date_trunc('month', CURRENT_DATE) is sargable and allows the database to utilize an index on created_at efficiently. Avoid wrapping the column in functions like EXTRACT or DATE() in the WHERE clause, as this prevents index usage and forces a full table scan.\",\"common_mistakes\":\"1. Using WHERE created_at = CURRENT_DATE (only gets today, not the month). 2. Using WHERE EXTRACT(MONTH FROM created_at) = EXTRACT(MONTH FROM CURRENT_DATE) (non-sargable, ignores year, and slow). 3. Forgetting to include the year in the comparison if using manual date construction.\",\"variations\":[\"SELECT id, email, created_at FROM users WHERE created_at >= date_trunc('month', CURRENT_DATE) AND created_at < date_trunc('month', CURRENT_DATE) + INTERVAL '1 month' ORDER BY created_at ASC;\",\"SELECT id, email, created_at FROM users WHERE created_at >= make_date(CURRENT_DATE - INTERVAL '1 month', 1, 1) AND created_at < make_date(CURRENT_DATE, 1, 1) ORDER BY created_at ASC;\"],\"dialect\":\"postgresql\"}\n\n$0.99 Day Pass · 24h access · USDC on Base — activate with day_pass_activate.","result_preview_integrity":"display_only_not_committed","result_preview_truncated":false,"free_used":0,"free_remaining":0,"free_limit":0,"signal_handle":null,"tool":{"name":"sql_from_english","version":"4.0.0","scope":"public"},"caller":{"type":"anonymous","id":"sha256:462e58a7c71e2908382513a2b3aa6526ad882e315da5746728c943130aea6da4"},"side_effects":{"declared":["none"],"schema_version":"zambo-side-effects/1","declaration_hash":"sha256:45aad38f3aa982b9aafe92ecb416ebe98791eddbaf8ab6df0bd08605b7c1bfee"},"evidence_sha256":null,"evidence_url":null,"evidence_byte_length":null,"evidence_content_type":null,"evidence_source_url":null,"evidence_status":"no_upstream_bytes_captured","external_evidence":[],"provenance":null,"provenance_class":"EXECUTED BY ZAMBO","metadata_hash":null,"anchor":{"event_id":"afc3f1a4e6d6a2cb73a572f46e67d7f62b188f049d9920ab8bf7ab6fd37ae058","pubkey":"e13475107d30c918ec664adf2ab1141024a22fb35190f82c9e933704fa49af41","relays":["wss://relay.damus.io","wss://nos.lol","wss://relay.primal.net"],"status":"partial","published_at":"2026-10-06T03:05:09.699Z","schema_version":"zambo-receipt-anchor/1","envelope":{"anchored_at":"2026-10-06T03:05:03.166Z","evidence_url":null,"receipt_uuid":"5d2092c7-f427-435d-9229-a14da6e836d5","output_sha256":"sha256:31e056ad77dbd92bdb5600b143c06146b55fc4369e9415732447c6f5f7d47d76","schema_version":"zambo-receipt-anchor/1","evidence_sha256":null,"evidence_byte_length":null},"envelope_bytes":"{\"anchored_at\":\"2026-10-06T03:05:03.166Z\",\"evidence_byte_length\":null,\"evidence_sha256\":null,\"evidence_url\":null,\"output_sha256\":\"sha256:31e056ad77dbd92bdb5600b143c06146b55fc4369e9415732447c6f5f7d47d76\",\"receipt_uuid\":\"5d2092c7-f427-435d-9229-a14da6e836d5\",\"schema_version\":\"zambo-receipt-anchor/1\"}"},"receipt_profile":"zambo-hosted-receipt/1","schema_url":"https://zambo.dev/aer-1/hosted-profile.schema.json","api_version":1,"verification_scope":"separate_sha256_commitment_and_provenance_binding_checks","checks":{"commitment_matches":{"label":"SHA-256 commitment","passed":true,"status":"pass","detail":"The exact decoded canonical bytes match the stored SHA-256 output hash."},"canonical_payload_matches":{"label":"Canonical payload reconstruction","passed":true,"status":"pass","detail":"The stored output and known call context reconstruct the exact canonical bytes."},"provenance_binding":{"label":"Provenance claim binding","status":"legacy","passed":false,"detail":"legacy receipt, provenance not cryptographically bound"},"metadata_binding":{"label":"AER-1 metadata hash","status":"legacy","passed":false,"detail":"legacy receipt, metadata is not cryptographically bound"},"signature":{"label":"Ed25519 signature (not checked)","passed":false,"status":"not_checked","detail":"No Ed25519 signature or pinned signing key was checked."},"chain":{"label":"Receipt chain (not checked)","passed":false,"status":"not_checked","detail":"No append-only receipt-chain proof was checked."},"issued_by_zambo_dev":{"label":"Issuer authentication","passed":false,"status":"not_checked","detail":"A zambo.dev receipt URL does not authenticate the issuer; no pinned signature or trusted issuer key was checked."},"immutable_log_timestamp":{"label":"Stored timestamp","passed":true,"timestamp":"2026-10-06T03:05:03.268Z","detail":"The receipt store reports 2026-10-06T03:05:03.268Z; immutability is not checked here."},"receipt_schema_version":"0.3","signature_valid":{"label":"Ed25519 signature (not checked)","passed":false,"status":"not_checked","detail":"Compatibility field only. No Ed25519 signature was checked; use API v2 checks.commitment_matches for the SHA-256 commitment."},"chain_valid":{"label":"Receipt chain (not checked)","passed":false,"status":"not_checked","detail":"This endpoint does not verify an append-only chain."}}},"verification_status":"legacy_receipt","checks":{"commitment_matches":{"status":"pass","passed":true,"expected_hash":"sha256:31e056ad77dbd92bdb5600b143c06146b55fc4369e9415732447c6f5f7d47d76","computed_hash":"sha256:31e056ad77dbd92bdb5600b143c06146b55fc4369e9415732447c6f5f7d47d76","detail":"SHA-256 of the exact decoded canonical bytes matches output_hash."},"canonical_payload_matches":{"label":"Canonical payload reconstruction","passed":true,"status":"pass","detail":"The stored output and known call context reconstruct the exact canonical bytes."},"provenance_binding":{"label":"Provenance claim binding","status":"legacy","passed":false,"detail":"legacy receipt, provenance not cryptographically bound"},"metadata_binding":{"label":"AER-1 metadata hash","status":"legacy","passed":false,"detail":"legacy receipt, metadata is not cryptographically bound"},"issuer_authentication":{"label":"Issuer authentication","passed":false,"status":"not_checked","detail":"A zambo.dev receipt URL does not authenticate the issuer; no pinned signature or trusted issuer key was checked."},"signature":{"status":"not_checked","detail":"No Ed25519 signature or pinned signing key is supplied."},"schema":{"status":"not_checked","detail":"Schema conformance is left to the client using the linked hosted-profile schema."},"chain":{"status":"not_checked","detail":"This endpoint does not verify an append-only receipt chain."}}}