{"api_version":2,"receipt_profile":"zambo-hosted-receipt/1","schema_url":"https://zambo.dev/aer-1/hosted-profile.schema.json","id":"749ee04d-670e-41f6-bbb5-a4a2b8d62651","source_url":"https://zambo.dev/api/receipt/749ee04d-670e-41f6-bbb5-a4a2b8d62651","receipt":{"id":"749ee04d-670e-41f6-bbb5-a4a2b8d62651","created_at":"2026-10-30T03:06:08.132Z","receipt_schema_version":"0.4","job_summary":"MCP tool execution: sql_from_english","tools":["sql_from_english"],"steps":[{"tool":"sql_from_english","status":"success","started_at":"2026-10-30T03:06:06.876Z","completed_at":"2026-10-30T03:06:08.132Z"}],"output_hash":"sha256:40f605fde8cceb42fbc222526271997f3781acb00c2e7d9da7a7c62eac4486fa","hash_algorithm":"sha256","canonical_bytes":"eyJjYWxsZXIiOnsiYmFzaXMiOiJpcF91YV8zMGQiLCJpZCI6InNoYTI1Njo4MzFjMGI2M2E4ZTUwOGE2ZTUzNzM4YzA4M2FjNDAxODE0MzhhZjhmNmQxYjFiZTdlYTU2ZmYwY2ZhNzY2OGE5Iiwicm90YXRlc19hdCI6IjIwMjYtMTEtMDNUMDA6MDA6MDAuMDAwWiIsInR5cGUiOiJhbm9ueW1vdXMifSwiaXNzdWVyX2NsYWltcyI6eyJwcm92ZW5hbmNlX2NsYXNzIjoiRVhFQ1VURUQgQlkgWkFNQk8ifSwib3V0cHV0Ijp7ImNvbW1vbl9taXN0YWtlcyI6IjEuIFVzaW5nIEJFVFdFRU4gd2l0aCBoYXJkY29kZWQgZGF0ZXMgaW5zdGVhZCBvZiBkeW5hbWljIGZ1bmN0aW9ucy4gMi4gQXBwbHlpbmcgZnVuY3Rpb25zIHRvIHRoZSBjb2x1bW4gaW4gdGhlIFdIRVJFIGNsYXVzZSAoZS5nLiwgV0hFUkUgREFURShjcmVhdGVkX2F0KSA9IC4uLikuIDMuIEZvcmdldHRpbmcgdG8gaGFuZGxlIHRpbWV6b25lIGRpZmZlcmVuY2VzIGlmIGNyZWF0ZWRfYXQgaXMgc3RvcmVkIGluIFVUQyBidXQgdGhlIHVzZXIgZXhwZWN0cyBsb2NhbCB0aW1lLiIsImRpYWxlY3QiOiJwb3N0Z3Jlc3FsIiwiZXhwbGFuYXRpb24iOiJTZWxlY3RzIHRoZSBpZCwgZW1haWwsIGFuZCBjcmVhdGlvbiB0aW1lc3RhbXAgZm9yIGFsbCB1c2VycyB3aG9zZSBzaWdudXAgZGF0ZSBmYWxscyB3aXRoaW4gdGhlIGN1cnJlbnQgY2FsZW5kYXIgbW9udGgsIHNvcnRlZCBjaHJvbm9sb2dpY2FsbHkgZnJvbSBvbGRlc3QgdG8gbmV3ZXN0LiIsImluZGV4ZXNfbmVlZGVkIjpbIkNSRUFURSBJTkRFWCBpZHhfdXNlcnNfY3JlYXRlZF9hdCBPTiB1c2VycyAoY3JlYXRlZF9hdCk7Il0sInBlcmZvcm1hbmNlX25vdGVzIjoiVXNpbmcgZGF0ZV90cnVuYygnbW9udGgnLCBDVVJSRU5UX0RBVEUpIGlzIHNhcmdhYmxlIGFuZCBhbGxvd3MgdGhlIGRhdGFiYXNlIHRvIHV0aWxpemUgYW4gaW5kZXggb24gY3JlYXRlZF9hdCBlZmZpY2llbnRseS4gQXZvaWQgd3JhcHBpbmcgdGhlIGNvbHVtbiBpbiBmdW5jdGlvbnMgKGUuZy4sIEVYVFJBQ1QoTU9OVEggRlJPTSBjcmVhdGVkX2F0KSkgYXMgdGhpcyBwcmV2ZW50cyBpbmRleCB1c2FnZSBhbmQgZm9yY2VzIGEgZnVsbCB0YWJsZSBzY2FuLiIsInNxbCI6IlNFTEVDVCBpZCwgZW1haWwsIGNyZWF0ZWRfYXQgRlJPTSB1c2VycyBXSEVSRSBjcmVhdGVkX2F0ID49IGRhdGVfdHJ1bmMoJ21vbnRoJywgQ1VSUkVOVF9EQVRFKSBPUkRFUiBCWSBjcmVhdGVkX2F0IEFTQzsiLCJ2YXJpYXRpb25zIjpbIlNFTEVDVCBpZCwgZW1haWwsIGNyZWF0ZWRfYXQgRlJPTSB1c2VycyBXSEVSRSBjcmVhdGVkX2F0ID49IGRhdGVfdHJ1bmMoJ21vbnRoJywgQ1VSUkVOVF9EQVRFKSBBTkQgY3JlYXRlZF9hdCA8IGRhdGVfdHJ1bmMoJ21vbnRoJywgQ1VSUkVOVF9EQVRFKSArIElOVEVSVkFMICcxIG1vbnRoJyBPUkRFUiBCWSBjcmVhdGVkX2F0IEFTQzsiLCJTRUxFQ1QgaWQsIGVtYWlsLCBjcmVhdGVkX2F0IEZST00gdXNlcnMgV0hFUkUgY3JlYXRlZF9hdCA+PSBkYXRlX3RydW5jKCdtb250aCcsIENVUlJFTlRfREFURSkgT1JERVIgQlkgY3JlYXRlZF9hdCBERVNDOyJdfSwicmVjZWlwdF9zY2hlbWFfdmVyc2lvbiI6IjAuNCIsInNpZGVfZWZmZWN0cyI6eyJkZWNsYXJhdGlvbl9oYXNoIjoic2hhMjU2OjQ1YWFkMzhmM2FhOTgyYjlhYWZlOTJlY2I0MTZlYmU5ODc5MWVkZGJhZjhhYjZkZjBiZDA4NjA1YjdjMWJmZWUiLCJkZWNsYXJlZCI6WyJub25lIl0sInNjaGVtYV92ZXJzaW9uIjoiemFtYm8tc2lkZS1lZmZlY3RzLzEifSwidG9vbCI6eyJuYW1lIjoic3FsX2Zyb21fZW5nbGlzaCIsInNjb3BlIjoicHVibGljIiwidmVyc2lvbiI6IjQuMC4wIn19","canonical_bytes_withheld_for_privacy":false,"canonical_byte_length":1821,"verification_status":"verified","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 (e.g., EXTRACT(MONTH FROM created_at)) as this prevents index usage and forces a full table scan.\",\"common_mistakes\":\"1. Using BETWEEN with hardcoded dates instead of dynamic functions. 2. Applying functions to the column in the WHERE clause (e.g., WHERE DATE(created_at) = ...). 3. Forgetting to handle timezone differences if created_at is stored in UTC but the user expects local time.\",\"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 >= date_trunc('month', CURRENT_DATE) ORDER BY created_at DESC;\"],\"dialect\":\"postgresql\"}","result_preview_integrity":"display_only_not_committed","result_preview_truncated":false,"input_hash":"sha256:9c603989f51e66db2e700d3a2a163554c1fe2e5925f2bd3a45ef11dcffc84358","input_hash_layout":"zambo-json-sorted-keys-utf8-v1","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:831c0b63a8e508a6e53738c083ac40181438af8f6d1b1be7ea56ff0cfa7668a9","basis":"ip_ua_30d","rotates_at":"2026-11-03T00:00:00.000Z"},"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":"sha256:6e91d0a1282d567f388bec48a0cb2e73acf1b0f390fad63ae6e8fe1c6bbec5c4","anchor":{"event_id":"79ef5ca44cab97ca8bdac3b10e5943769264e6c09318e13494e87e0753947fe8","pubkey":"e13475107d30c918ec664adf2ab1141024a22fb35190f82c9e933704fa49af41","relays":["wss://relay.damus.io","wss://nos.lol","wss://relay.primal.net"],"status":"partial","published_at":"2026-10-30T03:06:09.199Z","schema_version":"zambo-receipt-anchor/1","envelope":{"anchored_at":"2026-10-30T03:06:08.132Z","evidence_url":null,"receipt_uuid":"749ee04d-670e-41f6-bbb5-a4a2b8d62651","output_sha256":"sha256:40f605fde8cceb42fbc222526271997f3781acb00c2e7d9da7a7c62eac4486fa","schema_version":"zambo-receipt-anchor/1","evidence_sha256":null,"evidence_byte_length":null},"envelope_bytes":"{\"anchored_at\":\"2026-10-30T03:06:08.132Z\",\"evidence_byte_length\":null,\"evidence_sha256\":null,\"evidence_url\":null,\"output_sha256\":\"sha256:40f605fde8cceb42fbc222526271997f3781acb00c2e7d9da7a7c62eac4486fa\",\"receipt_uuid\":\"749ee04d-670e-41f6-bbb5-a4a2b8d62651\",\"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":"pass","passed":true,"detail":"The metadata claim is consistent with the verified receipt bytes; issuer is not authenticated."},"metadata_binding":{"label":"AER-1 metadata hash","status":"pass","passed":true,"detail":"metadata_hash matches the canonical metadata block."},"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-30T03:06:08.132Z","detail":"The receipt store reports 2026-10-30T03:06:08.132Z; immutability is not checked here."},"receipt_schema_version":"0.4","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."}},"execution_context":{"environment":"zambo.dev hosted MCP"}},"verification_status":"verified","checks":{"commitment_matches":{"status":"pass","passed":true,"expected_hash":"sha256:40f605fde8cceb42fbc222526271997f3781acb00c2e7d9da7a7c62eac4486fa","computed_hash":"sha256:40f605fde8cceb42fbc222526271997f3781acb00c2e7d9da7a7c62eac4486fa","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":"pass","passed":true,"detail":"The metadata claim is consistent with the verified receipt bytes; issuer is not authenticated."},"metadata_binding":{"label":"AER-1 metadata hash","status":"pass","passed":true,"detail":"metadata_hash matches the canonical metadata block."},"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."}}}