{"uid":"cap_Rpc_PtwUnjrVy2qyLygxZ","slug":"relaystation-sql-large-cdd0147b","name":"Relaystation SQL-Large","description":"$0.01 per 100 MB scanned. Run SQL over huge stored datasets — pay only for bytes scanned, ≈100 MB per penny. Warehouse-scale queries without the warehouse. 155 tools, one balance — relaystation.ai","url":"https://api.relaystation.ai/v1/data/sql-large","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"type":"object","properties":{"sql":{"type":"string","maxLength":20000,"minLength":1,"description":"SELECT-only; your file is the table named `input`."},"file":{"type":"object","description":"cputools input-source: { inline: <base64 ≤ 4 MiB> } or { inputKey: <scratch key from /v1/cputools/upload-url, ≤ 50 MB> }."},"format":{"enum":["csv","json"],"type":"string"}}},"type":{"type":"string","const":"http"},"method":{"enum":["POST","PUT","PATCH"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"registry","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_FJa-nHr24UlFDxXdD-7yh","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Run SELECT SQL queries over large uploaded datasets (CSV/JSON), paying only per byte scanned at $0.01 per 100 MB","exampleAgentPrompt":"Run this SQL on my uploaded sales CSV: SELECT region, SUM(revenue) AS total FROM input WHERE year = 2023 GROUP BY region ORDER BY total DESC — the file is a CSV I just uploaded and I want the grouped totals back.","exampleUseCases":[{"title":"Aggregate sales data from CSV","prompt":"I have a large sales CSV with millions of rows — can you run SELECT product_id, SUM(amount) as total_sales FROM input WHERE quarter = 'Q4' GROUP BY product_id ORDER BY total_sales DESC on it and give me the top 20 products by revenue?"},{"title":"Filter log records by condition","prompt":"I've got a JSON log file with server events — please query it with SELECT timestamp, user_id, action FROM input WHERE action = 'login_failed' AND timestamp > '2024-01-01' so I can see all failed login attempts this year."},{"title":"Compute dataset statistics for reporting","prompt":"Can you run SELECT COUNT(*) as total_rows, AVG(age) as avg_age, MIN(salary) as min_salary, MAX(salary) as max_salary FROM input on my employee CSV so I can get a quick summary for the HR report?"}],"resultDescription":"Returns the rows produced by the SQL SELECT query — structured data matching the projection and filters specified, formatted as JSON records. The response reflects only the columns and rows selected from the uploaded file (named `input` in the SQL).","failureModes":["Non-SELECT SQL (INSERT, UPDATE, DROP) rejected — only SELECT is allowed","File exceeds 50 MB inline limit — must use scratch upload key from /v1/cputools/upload-url","Base64 payload exceeds 4 MiB inline limit","Malformed SQL syntax returns a parse error","Unsupported file format (only csv and json accepted)","Referencing a table name other than `input` causes a query error","Insufficient balance to cover bytes scanned"],"whenToPreferThis":"Choose this endpoint when you need to run ad-hoc SQL analytics on large flat files (CSV or JSON up to 50 MB) without provisioning a database, and you want pay-per-scan pricing at $0.01 per 100 MB. Prefer it over in-memory solutions when file size exceeds local memory, and over full warehouse setups when you need one-shot queries without infrastructure overhead.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T12:52:02.911Z","isFirstParty":false}