# Vextorium CSV-SQL Query

> Vextorium CSV-SQL Query is a paid API for AI agents from api.vextorium.com, paid per call via x402, $0.004/call, status unknown (last checked 2026-10-28).

Accepts CSV content and a SQL SELECT query, executes the query over the CSV data, and returns the filtered/aggregated rows as structured JSON.

## Facts

- Endpoint: POST https://api.vextorium.com/v1/csv-sql?utm_source=zero.xyz
- Price: $0.004/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-28
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/vextorium-csv-sql-query-650c82c9
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_xytufUQkDuSRmSbGXQaTy

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability vextorium-csv-sql-query-650c82c9 -d '<json body>'
```

Example prompt: I have a CSV with columns city and sales — can you run 'SELECT city, SUM(sales) AS total FROM datos GROUP BY city ORDER BY total DESC' on it and give me up to 100 rows?

## When to prefer this

Use this endpoint when you have raw CSV data in memory and need to run ad-hoc SQL queries (filtering, aggregation, projection) without setting up a database. Ideal for one-off analytical queries on tabular datasets, especially inside agent workflows where structured JSON output is needed and the data changes each call.

## Known failure modes

- Invalid SQL syntax returns an error response
- CSV content that cannot be parsed (wrong delimiter) causes a parse failure
- Query referencing columns not in the CSV fails with a column-not-found error
- Very large CSV content may time out or be truncated
- Exceeding the row limit silently caps results at the specified maximum

## How this service works

244 pay-per-call data APIs for AI agents: official statistics and economy (ECB, Fed, Eurostat, World Bank, SEC, BOE, INE), crypto prices and sentiment, Spanish public data, compliance (sanctions, VAT, IBAN, LEI), science, weather, web and developer tools and local AI text tools. Pay in USDC via x402.

## Output

A JSON object containing the query result rows as an array of objects, the list of returned column names, the table name ('datos'), the total number of rows in the CSV, and the number of rows returned by the query.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "limit": {
   "type": "integer",
   "description": "Max rows (default 500)"
  },
  "query": {
   "type": "string",
   "description": "SELECT over table datos"
  },
  "content": {
   "type": "string"
  },
  "delimiter": {
   "type": "string"
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "rows": [
   {
    "city": "Madrid",
    "total": 220
   },
   {
    "city": "Barcelona",
    "total": 80
   }
  ],
  "table": "datos",
  "columns": [
   "city",
   "total"
  ],
  "table_rows": 3,
  "returned_rows": 2,
  "table_columns": [
   "city",
   "sales"
  ]
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/vextorium-csv-sql-query-650c82c9/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from api.vextorium.com](https://www.zero.xyz/host/api.vextorium.com/llms.txt)