{"uid":"cap_IhuRNfTbTMRUKvRlvxi7G","slug":"agentrxi-private-sqlite-database-e3b079f0","name":"AgentRXI Private SQLite Database","description":"Your own private SQLite database that persists between calls, keyed to the paying wallet: create tables, insert, update and query with up to 20 SQL statements per call (parameters supported). Up to 200 MB per wallet. Also callable as GET with the same fields as query parameters.","url":"https://agentrxi.com/v1/db?utm_source=zero.xyz","method":"GET","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method"],"properties":{"type":{"type":"string","const":"http"},"method":{"enum":["GET"],"type":"string"},"queryParams":{"type":"object","properties":{"sql":{"type":"string"},"params":{"type":"string","description":"separate items with |"},"statements":{"type":"string","description":"[{sql, params}]; separate items with |"}}}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.003","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.003/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.003","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.003","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_YuUrvU_eC-bfovoNUkF1a","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.003","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Provides a persistent, private SQLite database keyed to the paying wallet, supporting up to 20 SQL statements per call for creating tables, inserting, updating, and querying data (up to 200 MB storage).","exampleAgentPrompt":"Create a table called 'tasks' with columns id, title, status, and created_at, then insert a row with title 'Write report' and status 'pending' — store this in my private persistent database.","exampleUseCases":[{"title":"Agent memory across sessions","prompt":"I want you to remember my preferences across our conversations — store my name, preferred language, and timezone in my private SQLite database so you can retrieve them next time we talk."},{"title":"Tracking agent task queue","prompt":"Add a new task to my tasks table: 'Analyze Q3 sales data', status 'queued', priority 2 — and then show me all tasks that are still queued."},{"title":"Aggregating collected data over time","prompt":"I've been logging daily step counts — insert today's entry of 8,432 steps into my fitness_log table, then query the average steps per day for the last 7 days."}],"resultDescription":"Returns the results of executed SQL statements, including rows returned by SELECT queries (as arrays of objects), affected row counts for INSERT/UPDATE/DELETE operations, and success/error status for DDL statements like CREATE TABLE. Up to 20 statements can be executed per call, with results returned for each.","failureModes":["SQL syntax error causes statement to fail and returns an error message","Storage limit of 200 MB exceeded, rejecting new writes","Invalid or missing 'sql' parameter returns a validation error","Payment not processed (x402) results in 402 response and no execution","Attempting more than 20 SQL statements in a single call may be rejected","Malformed params separator (not using '|') causes parameter binding errors"],"whenToPreferThis":"Choose this endpoint when an AI agent needs persistent, structured storage that survives between calls and is privately scoped to the paying wallet. Ideal for agents that need to maintain state, accumulate data over time, or run relational queries without managing an external database. Prefer over in-memory approaches when durability is needed, and over full cloud databases when simplicity and pay-per-call economics are preferable.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:15.389Z","isFirstParty":false,"canonicalSlug":"agentrxi-private-sqlite-database-e3b079f0"}