{"id":"hobo-agent-advanced-sql-readonly-gate-v1","title":"Agent SQLite Read-Only Query Gate","description":"Run bounded parameterized SELECT queries against local SQLite files using read-only mode, an authorizer, optional table allowlisting and row/time limits. Rejects writes; accepts a JSON request. Delivered as a one-time downloadable Python package; runs locally and does not rent HOBO APIs.","price":{"amount":"15.00","currency":"USD"},"seller":"HOBO Works","license":"HOBO Works limited internal-use license. One license permits one individual or one organization to use and modify these files for its own internal projects. Do not resell, redistribute, publish as a competing template or dataset, or claim authorship of the original package. No warranty is provided. Review and test changes before production use.\n","category":"agent_data","protocols":["Python 3.10+","JSON","CLI"],"tags":["agent","SQLite","read-only SQL","database","query limits"],"version":"1.0.0","compatibility":["Python 3.10+","Windows","macOS","Linux"],"input_schema":{"type":"object","properties":{"database":{"type":"string"},"query":{"type":"string"},"params":{"oneOf":[{"type":"array","items":{}},{"type":"object","additionalProperties":{}}]},"tables":{"type":"array","items":{"type":"string"}},"max_rows":{"type":"integer","minimum":1,"maximum":1000},"timeout_ms":{"type":"integer","minimum":1,"maximum":10000}},"required":["database","query"]},"output_schema":{"type":"object","properties":{"columns":{"type":"array","items":{"type":"string"}},"rows":{"type":"array","items":{"type":"object"}},"row_count":{"type":"integer"},"truncated":{"type":"boolean"},"read_only":{"type":"boolean"},"error":{"type":"string"},"detail":{"type":"string"},"tables":{"type":"array","items":{"type":"string"}}}},"delivery":"download_after_verified_payment","free":false,"featured":false,"delivery_type":"download","delivery_sla_hours":0,"billing":{"type":"one_time","interval":null,"entitlement_days":0},"updated_at":null,"rating":{"count":0,"average":null},"problem":"Profile, normalize, redact, validate, and safely ingest structured agent data.","use_cases":[{"id":"data-intake","name":"Data intake and normalization"},{"id":"api-contracts-discovery","name":"API contracts and discovery"},{"id":"cost-control","name":"Cost and budget control"},{"id":"security-privacy","name":"Security and privacy"}],"example_queries":["Find a tool to preflight or normalize agent data.","How can I validate a CSV or JSONL intake?","Find a tool to inspect or validate an agent API.","How can I detect a breaking API contract change?","Find a hard budget cap for an agent run.","How can I meter token or API cost?"],"agent_keywords":["3.10+","accepts","against","agent","allowlisting","and","apis.","authorizer","bounded","cli","data","database","delivered","does","downloadable","files","gate","hobo","json","limits","limits.","local","locally","mode","not","one-time","optional","package","parameterized","python","queries","query"],"trust":{"license":"HOBO Works limited internal-use license. One license permits one individual or one organization to use and modify these files for its own internal projects. Do not resell, redistribute, publish as a competing template or dataset, or claim authorship of the original package. No warranty is provided. Review and test changes before production use.\n","compatibility":["Python 3.10+","Windows","macOS","Linux"],"artifact":{"file_name":"HOBO-Agent-Advanced-Agent-SQLite-Read-Only-Query-Gate-v1.0.0.zip","available":true,"bytes":3386,"sha256":"c578350452ed4bca5568c678abdd5401857ac2f38d74f3c165c47e950b570d18"},"verification":{"status":"artifact-verified","checksum":"sha256-computed","archive_integrity":"passed","test_status":"archive-integrity-checked","checked_at":"2026-11-02T23:06:12+00:00"}},"example_call":{"action":"inspect_product","product_id":"hobo-agent-advanced-sql-readonly-gate-v1","query":"Find a tool to preflight or normalize agent data.","input_schema":{"type":"object","properties":{"database":{"type":"string"},"query":{"type":"string"},"params":{"oneOf":[{"type":"array","items":{}},{"type":"object","additionalProperties":{}}]},"tables":{"type":"array","items":{"type":"string"}},"max_rows":{"type":"integer","minimum":1,"maximum":1000},"timeout_ms":{"type":"integer","minimum":1,"maximum":10000}},"required":["database","query"]},"output_schema":{"type":"object","properties":{"columns":{"type":"array","items":{"type":"string"}},"rows":{"type":"array","items":{"type":"object"}},"row_count":{"type":"integer"},"truncated":{"type":"boolean"},"read_only":{"type":"boolean"},"error":{"type":"string"},"detail":{"type":"string"},"tables":{"type":"array","items":{"type":"string"}}}}}}