{"api_version":2,"receipt_profile":"zambo-hosted-receipt/1","schema_url":"https://zambo.dev/aer-1/hosted-profile.schema.json","id":"772204ac-e2f7-490b-b423-8cacb4b1c55a","source_url":"https://zambo.dev/api/receipt/772204ac-e2f7-490b-b423-8cacb4b1c55a","receipt":{"id":"772204ac-e2f7-490b-b423-8cacb4b1c55a","created_at":"2026-10-26T03:04:35.538Z","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-26T03:04:34.463Z","completed_at":"2026-10-26T03:04:35.538Z"}],"output_hash":"sha256:abad52b00724a694c990075cf954690ed8ccccaa93a506f4787d296702c89a1b","hash_algorithm":"sha256","canonical_bytes":"eyJjYWxsZXIiOnsiYmFzaXMiOiJpcF91YV8zMGQiLCJpZCI6InNoYTI1Njo4MzFjMGI2M2E4ZTUwOGE2ZTUzNzM4YzA4M2FjNDAxODE0MzhhZjhmNmQxYjFiZTdlYTU2ZmYwY2ZhNzY2OGE5Iiwicm90YXRlc19hdCI6IjIwMjYtMTEtMDNUMDA6MDA6MDAuMDAwWiIsInR5cGUiOiJhbm9ueW1vdXMifSwiaXNzdWVyX2NsYWltcyI6eyJwcm92ZW5hbmNlX2NsYXNzIjoiRVhFQ1VURUQgQlkgWkFNQk8ifSwib3V0cHV0Ijp7ImNvbW1vbl9taXN0YWtlcyI6IjEuIFVzaW5nIEJFVFdFRU4gd2l0aCBoYXJkY29kZWQgZGF0ZXMgaW5zdGVhZCBvZiBkeW5hbWljIGZ1bmN0aW9ucy4gMi4gQXBwbHlpbmcgZnVuY3Rpb25zIHRvIHRoZSBjb2x1bW4gaW4gdGhlIFdIRVJFIGNsYXVzZSAoZS5nLiwgV0hFUkUgREFURShjcmVhdGVkX2F0KSA9IC4uLikuIDMuIEZvcmdldHRpbmcgdG8gaW5jbHVkZSB0aGUgdGltZSBjb21wb25lbnQsIHdoaWNoIG1pZ2h0IGV4Y2x1ZGUgdXNlcnMgd2hvIHNpZ25lZCB1cCBvbiB0aGUgbGFzdCBkYXkgb2YgdGhlIHByZXZpb3VzIG1vbnRoIGlmIG5vdCBoYW5kbGVkIGNvcnJlY3RseSAodGhvdWdoIGRhdGVfdHJ1bmMgaGFuZGxlcyB0aGUgc3RhcnQgYm91bmRhcnkgY29ycmVjdGx5KS4iLCJkaWFsZWN0IjoicG9zdGdyZXNxbCIsImV4cGxhbmF0aW9uIjoiU2VsZWN0cyB0aGUgaWQsIGVtYWlsLCBhbmQgY3JlYXRpb24gdGltZXN0YW1wIGZvciBhbGwgdXNlcnMgd2hvc2Ugc2lnbnVwIGRhdGUgZmFsbHMgd2l0aGluIHRoZSBjdXJyZW50IGNhbGVuZGFyIG1vbnRoLCBzb3J0ZWQgY2hyb25vbG9naWNhbGx5IGZyb20gb2xkZXN0IHRvIG5ld2VzdC4iLCJpbmRleGVzX25lZWRlZCI6WyJDUkVBVEUgSU5ERVggaWR4X3VzZXJzX2NyZWF0ZWRfYXQgT04gdXNlcnMgKGNyZWF0ZWRfYXQpOyJdLCJwZXJmb3JtYW5jZV9ub3RlcyI6IlVzaW5nIGRhdGVfdHJ1bmMoJ21vbnRoJywgQ1VSUkVOVF9EQVRFKSBjcmVhdGVzIGEgc2FyZ2FibGUgcHJlZGljYXRlIHRoYXQgYWxsb3dzIHRoZSBkYXRhYmFzZSB0byB1dGlsaXplIGEgQi10cmVlIGluZGV4IG9uIGNyZWF0ZWRfYXQgZWZmaWNpZW50bHkuIEF2b2lkIHdyYXBwaW5nIHRoZSBjb2x1bW4gaW4gZnVuY3Rpb25zIChlLmcuLCBFWFRSQUNUKE1PTlRIIEZST00gY3JlYXRlZF9hdCkpIGFzIHRoaXMgcHJldmVudHMgaW5kZXggdXNhZ2UgYW5kIGZvcmNlcyBhIGZ1bGwgdGFibGUgc2Nhbi4iLCJzcWwiOiJTRUxFQ1QgaWQsIGVtYWlsLCBjcmVhdGVkX2F0IEZST00gdXNlcnMgV0hFUkUgY3JlYXRlZF9hdCA+PSBkYXRlX3RydW5jKCdtb250aCcsIENVUlJFTlRfREFURSkgT1JERVIgQlkgY3JlYXRlZF9hdCBBU0M7IiwidmFyaWF0aW9ucyI6WyJTRUxFQ1QgaWQsIGVtYWlsLCBjcmVhdGVkX2F0IEZST00gdXNlcnMgV0hFUkUgY3JlYXRlZF9hdCA+PSBkYXRlX3RydW5jKCdtb250aCcsIENVUlJFTlRfREFURSkgQU5EIGNyZWF0ZWRfYXQgPCBkYXRlX3RydW5jKCdtb250aCcsIENVUlJFTlRfREFURSkgKyBJTlRFUlZBTCAnMSBtb250aCcgT1JERVIgQlkgY3JlYXRlZF9hdCBBU0M7IiwiU0VMRUNUIGlkLCBlbWFpbCwgY3JlYXRlZF9hdCBGUk9NIHVzZXJzIFdIRVJFIGNyZWF0ZWRfYXQgPj0gZGF0ZV90cnVuYygnbW9udGgnLCBDVVJSRU5UX0RBVEUpIE9SREVSIEJZIGNyZWF0ZWRfYXQgREVTQzsiXX0sInJlY2VpcHRfc2NoZW1hX3ZlcnNpb24iOiIwLjQiLCJzaWRlX2VmZmVjdHMiOnsiZGVjbGFyYXRpb25faGFzaCI6InNoYTI1Njo0NWFhZDM4ZjNhYTk4MmI5YWFmZTkyZWNiNDE2ZWJlOTg3OTFlZGRiYWY4YWI2ZGYwYmQwODYwNWI3YzFiZmVlIiwiZGVjbGFyZWQiOlsibm9uZSJdLCJzY2hlbWFfdmVyc2lvbiI6InphbWJvLXNpZGUtZWZmZWN0cy8xIn0sInRvb2wiOnsibmFtZSI6InNxbF9mcm9tX2VuZ2xpc2giLCJzY29wZSI6InB1YmxpYyIsInZlcnNpb24iOiI0LjAuMCJ9fQ==","canonical_bytes_withheld_for_privacy":false,"canonical_byte_length":1942,"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) creates a sargable predicate that allows the database to utilize a B-tree 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 include the time component, which might exclude users who signed up on the last day of the previous month if not handled correctly (though date_trunc handles the start boundary correctly).\",\"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:94ebb42351fe74e3184dda22a8dd9ae761e874f765e46423de95ebcaaa475e69","anchor":{"event_id":"4eac503d633fccf9a73e2e8d154e2c5d662d1c393aa08e3ce2d43071851bf0af","pubkey":"e13475107d30c918ec664adf2ab1141024a22fb35190f82c9e933704fa49af41","relays":["wss://relay.damus.io","wss://nos.lol","wss://relay.primal.net"],"status":"partial","published_at":"2026-10-26T03:04:36.475Z","schema_version":"zambo-receipt-anchor/1","envelope":{"anchored_at":"2026-10-26T03:04:35.538Z","evidence_url":null,"receipt_uuid":"772204ac-e2f7-490b-b423-8cacb4b1c55a","output_sha256":"sha256:abad52b00724a694c990075cf954690ed8ccccaa93a506f4787d296702c89a1b","schema_version":"zambo-receipt-anchor/1","evidence_sha256":null,"evidence_byte_length":null},"envelope_bytes":"{\"anchored_at\":\"2026-10-26T03:04:35.538Z\",\"evidence_byte_length\":null,\"evidence_sha256\":null,\"evidence_url\":null,\"output_sha256\":\"sha256:abad52b00724a694c990075cf954690ed8ccccaa93a506f4787d296702c89a1b\",\"receipt_uuid\":\"772204ac-e2f7-490b-b423-8cacb4b1c55a\",\"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-26T03:04:35.538Z","detail":"The receipt store reports 2026-10-26T03:04:35.538Z; 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:abad52b00724a694c990075cf954690ed8ccccaa93a506f4787d296702c89a1b","computed_hash":"sha256:abad52b00724a694c990075cf954690ed8ccccaa93a506f4787d296702c89a1b","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."}}}