# AgentRXI SQL Query Engine

> AgentRXI SQL Query Engine is a paid API for AI agents from agentrxi.com, paid per call via x402, $0.003/call, status unknown (last checked 2026-10-15).

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.

## Facts

- Endpoint: GET https://agentrxi.com/v1/sql?utm_source=zero.xyz
- Price: $0.003/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/agentrxi-sql-query-engine-2c2e6dda
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_E68OB4XTXkq1DAHo5LIRa

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 agentrxi-sql-query-engine-2c2e6dda
```

Example prompt: 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?

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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.

## Output

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.

## Request schema (JSON Schema)

```json
{
 "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"
    }
   }
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/agentrxi-sql-query-engine-2c2e6dda/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from agentrxi.com](https://www.zero.xyz/host/agentrxi.com/llms.txt)