{"uid":"cap_z_ROGi5zhuaMSiajHgLuo","slug":"toolsnap-csv-query-xl-b46d4c1f","name":"ToolSnap CSV Query XL","description":"47 server-side tools for AI agents through a single MCP connection. 36 free, no new accounts. Median 98.1% token savings on web content. Paid tools from $0.02.","url":"https://mcp.toolsnap.app/x402/tools/csv_query_xl?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"url":{"type":"string","description":"CSV URL."},"limit":{"type":"number","description":"Default 100, max 1000."},"filter":{"type":"string","description":"'col op value'."},"format":{"enum":["json","csv"],"type":"string","description":"Default json."},"select":{"type":"string","description":"Columns, comma-separated."},"headers":{"type":"object","description":"Headers to forward (Authorization, Cookie…)."},"sort_by":{"type":"string","description":"Sort column."},"sort_dir":{"enum":["asc","desc"],"type":"string","description":"Default asc."}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.02","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.02/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_i-D1xtY9WOB_w1fxLyFSd","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.02","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Query a remote CSV file by URL with filtering, column selection, sorting, and row limiting, returning results as JSON or CSV","exampleAgentPrompt":"Can you pull the CSV at https://example.com/sales_data.csv, filter rows where region equals 'West', select only the columns 'date', 'region', and 'revenue', sort by revenue descending, and return the top 50 rows as JSON?","exampleUseCases":[{"title":"Filter public dataset by condition","prompt":"Grab the CSV from https://data.gov/example/census.csv, filter rows where state equals 'California', pick only the 'city', 'population', and 'income' columns, sort by population descending, and give me the top 100 rows as JSON."},{"title":"Preview private authenticated CSV","prompt":"Fetch the CSV at https://internal.mycompany.com/reports/q3_leads.csv using my Bearer token 'abc123' in the Authorization header, return the first 50 rows with columns 'lead_name', 'status', and 'deal_size', sorted by deal_size descending, as JSON."},{"title":"Export filtered CSV slice for analysis","prompt":"Query the CSV at https://example.com/inventory.csv, filter where category equals 'Electronics', keep all columns, sort by price ascending, limit to 200 rows, and return the results in CSV format."}],"resultDescription":"A list of rows from the remote CSV matching the filter and column selection criteria, returned as JSON array of objects or as a CSV string, sorted and limited per the request parameters. Up to 1000 rows per call.","failureModes":["Invalid or unreachable CSV URL returns an error","Filter expression malformed or references non-existent column","Row limit exceeds maximum of 1000","Auth headers insufficient to access protected CSV","CSV file is malformed or not valid CSV","Column names in 'select' don't exist in the file","Sort column not found in CSV headers"],"whenToPreferThis":"Use this endpoint when you need to query, filter, and slice a remote CSV file without downloading it fully — especially when the CSV is large and you only need a subset of rows or columns. It avoids passing raw CSV content to the LLM (significant token savings) and supports authenticated access via forwarded headers. Prefer it over in-context CSV parsing when the file is large, when filtering/sorting is needed server-side, or when you want structured JSON output directly.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-18T00:39:29.864Z","isFirstParty":false,"canonicalSlug":"toolsnap-csv-query-xl-b46d4c1f"}