{"uid":"cap_E68OB4XTXkq1DAHo5LIRa","slug":"agentrxi-sql-query-engine-2c2e6dda","name":"AgentRXI SQL Query Engine","description":"Run SQL on your data: load JSON rows or CSV (or several named tables) into SQLite and run any SELECT, including GROUP BY, JOIN, window functions and CTEs. Up to 100,000 rows. Also callable as GET with the same fields as query parameters.","url":"https://agentrxi.com/v1/sql?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","required":["query"],"properties":{"data":{"type":"string","description":"JSON array or CSV text (table name: data)"},"query":{"type":"string","description":"SELECT ..."},"tables":{"type":"string","description":"JSON object {name: rows} for several tables"}}}},"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_t4PermnFm0kcI1-OHADdH","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":"Load JSON rows or CSV data into an in-memory SQLite instance and execute any SELECT query, including GROUP BY, JOIN, window functions, and CTEs, against up to 100,000 rows.","exampleAgentPrompt":"I have a JSON array of sales records and I want to know the total revenue per product category — can you run a GROUP BY query on it for me?","exampleUseCases":[{"title":"Aggregate sales data from JSON","prompt":"Here's a JSON array of 500 order records with fields product, quantity, and price — run a SQL query to give me total revenue and order count grouped by product."},{"title":"Join two CSV-style tables","prompt":"I have two datasets: one with user IDs and names, and another with user IDs and purchase amounts as JSON arrays — join them and return the top 10 users by total spend."},{"title":"Rank rows with window functions","prompt":"Take this JSON array of employee records with department and salary fields, and use a SQL window function to rank employees by salary within each department."}],"resultDescription":"Returns the rows produced by the SELECT query as a JSON object or array, reflecting aggregations, joins, window calculations, or filtered results as specified by the query against the in-memory SQLite database.","failureModes":["Invalid SQL syntax causes query parse error","Data exceeds 100,000 row limit and is rejected","Malformed JSON or CSV input causes load failure","Referencing a table name not provided in 'tables' causes an unknown table error","Non-SELECT statements (INSERT, UPDATE, DROP) are rejected","Column name mismatch between query and provided data returns empty result or error"],"whenToPreferThis":"Choose this endpoint when you have structured data in JSON or CSV format and need to run ad-hoc SQL analytics — aggregations, joins, filtering, ranking, or CTEs — without setting up a database. Ideal for one-shot data transformation and analysis tasks where the dataset fits within 100,000 rows and a full database server is unnecessary.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:38:56.605Z","isFirstParty":false,"canonicalSlug":"agentrxi-sql-query-engine-2c2e6dda"}