{"api_version":2,"receipt_profile":"zambo-hosted-receipt/1","schema_url":"https://zambo.dev/aer-1/hosted-profile.schema.json","id":"2c7cd8f5-8084-4802-a9fa-1460a52130d1","source_url":"https://zambo.dev/api/receipt/2c7cd8f5-8084-4802-a9fa-1460a52130d1","receipt":{"id":"2c7cd8f5-8084-4802-a9fa-1460a52130d1","created_at":"2026-11-04T03:05:35.771Z","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-11-04T03:05:33.966Z","completed_at":"2026-11-04T03:05:35.771Z"}],"output_hash":"sha256:91d6fb7a3637160019d4a56e63f09d2a02c1fcb008c6bd7f7d29d28e477022b5","hash_algorithm":"sha256","canonical_bytes":"eyJjYWxsZXIiOnsiYmFzaXMiOiJpcF91YV8zMGQiLCJpZCI6InNoYTI1Njo4ZTdiMzU2ZGQ5ZWY5YTYyZDM2N2ZkYzAwY2U5Y2UxYTQxZTM0ZDNlYzNiZWNhNjFiZTBhMjU4ZTBiYWM4YzgxIiwicm90YXRlc19hdCI6IjIwMjYtMTItMDNUMDA6MDA6MDAuMDAwWiIsInR5cGUiOiJhbm9ueW1vdXMifSwiaXNzdWVyX2NsYWltcyI6eyJwcm92ZW5hbmNlX2NsYXNzIjoiRVhFQ1VURUQgQlkgWkFNQk8ifSwib3V0cHV0Ijp7ImNvbW1vbl9taXN0YWtlcyI6IlVzaW5nIEJFVFdFRU4gd2l0aCBpbmNsdXNpdmUgYm91bmRzIGNhbiBpbmNsdWRlIHRoZSBmaXJzdCBkYXkgb2YgdGhlIG5leHQgbW9udGg7IHVzaW5nIE5PVygpIGluc2lkZSBhIGZ1bmN0aW9uIG9uIHRoZSBjb2x1bW4gcHJldmVudHMgaW5kZXggdXNhZ2U7IG9yZGVyaW5nIGJ5IGlkIGluc3RlYWQgb2YgY3JlYXRlZF9hdDsgaWdub3JpbmcgdGltZSB6b25lIGRpZmZlcmVuY2VzIGluIGNyZWF0ZWRfYXQuIiwiZGlhbGVjdCI6InBvc3RncmVzcWwiLCJleHBsYW5hdGlvbiI6IlJldHJpZXZlcyBhbGwgdXNlcnMgd2hvc2UgY3JlYXRlZF9hdCB0aW1lc3RhbXAgZmFsbHMgd2l0aGluIHRoZSBjdXJyZW50IGNhbGVuZGFyIG1vbnRoLCBzb3J0ZWQgYnkgc2lnbnVwIGRhdGUuIiwiaW5kZXhlc19uZWVkZWQiOlsiQ1JFQVRFIElOREVYIGlkeF91c2Vyc19jcmVhdGVkX2F0IE9OIHVzZXJzKGNyZWF0ZWRfYXQpOyJdLCJwZXJmb3JtYW5jZV9ub3RlcyI6IlRoZSByYW5nZSBjb25kaXRpb24gb24gY3JlYXRlZF9hdCBhbGxvd3MgdGhlIGluZGV4IHRvIGJlIHVzZWQuIEF2b2lkIHdyYXBwaW5nIGNyZWF0ZWRfYXQgaW4gYSBmdW5jdGlvbiB0byBrZWVwIHRoZSBpbmRleCB1c2FibGUuIFRoZSBPUkRFUiBCWSBvbiBjcmVhdGVkX2F0IGNhbiBiZSBzYXRpc2ZpZWQgYnkgdGhlIHNhbWUgaW5kZXggaWYgdGhlIHBsYW5uZXIgY2hvb3NlcyBhbiBpbmRleCBzY2FuIHdpdGggT1JERVIgQlkuIiwic3FsIjoiU0VMRUNUICogRlJPTSB1c2VycyBXSEVSRSBjcmVhdGVkX2F0ID49IGRhdGVfdHJ1bmMoJ21vbnRoJywgY3VycmVudF9kYXRlKSBBTkQgY3JlYXRlZF9hdCA8IGRhdGVfdHJ1bmMoJ21vbnRoJywgY3VycmVudF9kYXRlKSArIGludGVydmFsICcxIG1vbnRoJyBPUkRFUiBCWSBjcmVhdGVkX2F0OyIsInZhcmlhdGlvbnMiOlsiU0VMRUNUICogRlJPTSB1c2VycyBXSEVSRSBjcmVhdGVkX2F0ID49IGRhdGVfdHJ1bmMoJ21vbnRoJywgbm93KCkpIEFORCBjcmVhdGVkX2F0IDwgZGF0ZV90cnVuYygnbW9udGgnLCBub3coKSkgKyBpbnRlcnZhbCAnMSBtb250aCcgT1JERVIgQlkgY3JlYXRlZF9hdDsiLCJTRUxFQ1QgKiBGUk9NIHVzZXJzIFdIRVJFIGRhdGVfdHJ1bmMoJ21vbnRoJywgY3JlYXRlZF9hdCkgPSBkYXRlX3RydW5jKCdtb250aCcsIGN1cnJlbnRfZGF0ZSkgT1JERVIgQlkgY3JlYXRlZF9hdDsiXX0sInJlY2VpcHRfc2NoZW1hX3ZlcnNpb24iOiIwLjQiLCJzaWRlX2VmZmVjdHMiOnsiZGVjbGFyYXRpb25faGFzaCI6InNoYTI1Njo0NWFhZDM4ZjNhYTk4MmI5YWFmZTkyZWNiNDE2ZWJlOTg3OTFlZGRiYWY4YWI2ZGYwYmQwODYwNWI3YzFiZmVlIiwiZGVjbGFyZWQiOlsibm9uZSJdLCJzY2hlbWFfdmVyc2lvbiI6InphbWJvLXNpZGUtZWZmZWN0cy8xIn0sInRvb2wiOnsibmFtZSI6InNxbF9mcm9tX2VuZ2xpc2giLCJzY29wZSI6InB1YmxpYyIsInZlcnNpb24iOiI0LjAuMCJ9fQ==","canonical_bytes_withheld_for_privacy":false,"canonical_byte_length":1714,"verification_status":"verified","session_trail":[],"result_preview":"{\"sql\":\"SELECT * 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;\",\"explanation\":\"Retrieves all users whose created_at timestamp falls within the current calendar month, sorted by signup date.\",\"indexes_needed\":[\"CREATE INDEX idx_users_created_at ON users(created_at);\"],\"performance_notes\":\"The range condition on created_at allows the index to be used. Avoid wrapping created_at in a function to keep the index usable. The ORDER BY on created_at can be satisfied by the same index if the planner chooses an index scan with ORDER BY.\",\"common_mistakes\":\"Using BETWEEN with inclusive bounds can include the first day of the next month; using NOW() inside a function on the column prevents index usage; ordering by id instead of created_at; ignoring time zone differences in created_at.\",\"variations\":[\"SELECT * FROM users WHERE created_at >= date_trunc('month', now()) AND created_at < date_trunc('month', now()) + interval '1 month' ORDER BY created_at;\",\"SELECT * FROM users WHERE date_trunc('month', created_at) = date_trunc('month', current_date) ORDER BY created_at;\"],\"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:8e7b356dd9ef9a62d367fdc00ce9ce1a41e34d3ec3beca61be0a258e0bac8c81","basis":"ip_ua_30d","rotates_at":"2026-12-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":"empty","result_source":null,"evidence_source":null,"external_evidence":[],"provenance":{"result_source":null,"evidence_source":null,"evidence_status":"empty","evidence_captures":[]},"provenance_class":"EXECUTED BY ZAMBO","metadata_hash":"sha256:2afa5cc43ad1425ba6038b51cdd64fb77e58451c0f1ddb6e7dc8ee0d281a22c5","anchor":{"event_id":"dead90747af7adc8173277bbfdbd636525d4db7821836343b671bad8c8e489b6","pubkey":"e13475107d30c918ec664adf2ab1141024a22fb35190f82c9e933704fa49af41","relays":["wss://relay.damus.io","wss://nos.lol","wss://relay.primal.net"],"status":"partial","published_at":"2026-11-04T03:05:37.309Z","schema_version":"zambo-receipt-anchor/1","envelope":{"anchored_at":"2026-11-04T03:05:35.771Z","evidence_url":null,"receipt_uuid":"2c7cd8f5-8084-4802-a9fa-1460a52130d1","output_sha256":"sha256:91d6fb7a3637160019d4a56e63f09d2a02c1fcb008c6bd7f7d29d28e477022b5","schema_version":"zambo-receipt-anchor/1","evidence_sha256":null,"evidence_byte_length":null},"envelope_bytes":"{\"anchored_at\":\"2026-11-04T03:05:35.771Z\",\"evidence_byte_length\":null,\"evidence_sha256\":null,\"evidence_url\":null,\"output_sha256\":\"sha256:91d6fb7a3637160019d4a56e63f09d2a02c1fcb008c6bd7f7d29d28e477022b5\",\"receipt_uuid\":\"2c7cd8f5-8084-4802-a9fa-1460a52130d1\",\"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-11-04T03:05:35.771Z","detail":"The receipt store reports 2026-11-04T03:05:35.771Z; 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","quota_identity":{"meter_key":"sha256:f2a49000996da42197320f19ed2cf37361638cd811b8add15ce11581bfeb817e"}}},"evidence_status":"empty","verification_status":"verified","checks":{"commitment_matches":{"status":"pass","passed":true,"expected_hash":"sha256:91d6fb7a3637160019d4a56e63f09d2a02c1fcb008c6bd7f7d29d28e477022b5","computed_hash":"sha256:91d6fb7a3637160019d4a56e63f09d2a02c1fcb008c6bd7f7d29d28e477022b5","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."}}}