ToolVet
80trust / 100

Sql

by Citiview Agent Market in Developer tools

x402 APIPassing, checked 3 h ago

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.

GET
https://agents.citiviewgroup.com/v1/sql
Price
$0.003
per call in USDC
Uptime
100%
last 30 days
Response time
155 ms
1.5 s slowest 5%
Last check
Passed
3 h ago, next any minute now

Run a free test callHow to call it

Reliability

All checks passedSome failedAll failedNot checked

Status and outage history · Atom feed

How to call it

GET https://agents.citiviewgroup.com/v1/sql

Each call costs $0.003 in USDC on Base, paid with the request over x402.

Run a free test callOne unpaid request, the way an agent sends it. You see the payment challenge it gets back. Nothing is charged.

Example request

From the listing.

GET https://agents.citiviewgroup.com/v1/sql?data=region%2Camount%0AEast%2C10%0AWest%2C25%0AEast%2C5&query=SELECT+region%2C+SUM%28amount%29+AS+total+FROM+data+GROUP+BY+region+ORDER+BY+total+DESC

Parameters

ParameterTypeRequiredDescription
datastringNoJSON array or CSV text (table name: data)
querystringYesSELECT ...
tablesstringNoJSON object {name: rows} for several tables

Example response

The provider's example. We can't check it without paying.

{
  "columns": [
    "region",
    "total"
  ],
  "row_count": 2,
  "rows": [
    {
      "region": "West",
      "total": 25
    },
    {
      "region": "East",
      "total": 15
    }
  ]
}

Call it from code

The curl command shows the payment challenge. The JavaScript and Python versions pay and call, and never pay more than $0.003.

curl: see the payment challenge
# bash or zsh: see the payment challenge. Nothing is charged.
curl -sS -g -i 'https://agents.citiviewgroup.com/v1/sql?data=region%2Camount%0AEast%2C10%0AWest%2C25%0AEast%2C5&query=SELECT+region%2C+SUM%28amount%29+AS+total+FROM+data+GROUP+BY+region+ORDER+BY+total+DESC'

# x402 v2 sends the challenge base64-encoded in the PAYMENT-REQUIRED header (v1 sends it in the body).
# To read the header:
curl -sS -g -o /dev/null -D - 'https://agents.citiviewgroup.com/v1/sql?data=region%2Camount%0AEast%2C10%0AWest%2C25%0AEast%2C5&query=SELECT+region%2C+SUM%28amount%29+AS+total+FROM+data+GROUP+BY+region+ORDER+BY+total+DESC' \
  | grep -i '^payment-required:' | cut -d' ' -f2 | tr -d '\r' | base64 --decode
JavaScript: pay and call
// npm i @x402/fetch @x402/evm viem
import { wrapFetchWithPayment, x402Client } from "@x402/fetch";
import { registerExactEvmScheme } from "@x402/evm/exact/client";
import { privateKeyToAccount } from "viem/accounts";

// Pays at most $0.003 per call.
const client = new x402Client().setSpendControls({ maxAmountPerPayment: "$0.003" });
registerExactEvmScheme(client, { signer: privateKeyToAccount(process.env.EVM_PRIVATE_KEY) });
const pay = wrapFetchWithPayment(fetch, client);

// Not sure it's safe to pay? ToolVet checks it first for $0.005. Pay for that from a separate
// client: this one is capped at $0.003 per payment. GET https://toolvet.app/api/v1/check?url=https%3A%2F%2Fagents.citiviewgroup.com%2Fv1%2Fsql
const res = await pay("https://agents.citiviewgroup.com/v1/sql?data=region%2Camount%0AEast%2C10%0AWest%2C25%0AEast%2C5&query=SELECT+region%2C+SUM%28amount%29+AS+total+FROM+data+GROUP+BY+region+ORDER+BY+total+DESC");
console.log(res.status, await res.text());
Python: pay and call
# pip install "x402[requests,evm]"
import os
from eth_account import Account
from x402 import x402ClientSync
from x402.http.clients import x402_requests
from x402.mechanisms.evm import EthAccountSigner
from x402.mechanisms.evm.exact.register import register_exact_evm_client

# Pays at most $0.003 per call.
client = x402ClientSync().set_spend_controls({"max_amount_per_payment": "$0.003"})
register_exact_evm_client(client, EthAccountSigner(Account.from_key(os.environ["EVM_PRIVATE_KEY"])))

with x402_requests(client) as session:
    res = session.get("https://agents.citiviewgroup.com/v1/sql?data=region%2Camount%0AEast%2C10%0AWest%2C25%0AEast%2C5&query=SELECT+region%2C+SUM%28amount%29+AS+total+FROM+data+GROUP+BY+region+ORDER+BY+total+DESC")
    print(res.status_code, res.text)

Security scan

No findings

We scan names, descriptions and tool definitions for hidden instructions and other prompt-injection patterns.

Recent checks

WhenResultHTTPTimePrice
3 h agoPassed402147 ms$0.003
7 h agoPassed4021.4 s$0.003
12 h agoPassed402155 ms$0.003
16 h agoPassed40254 ms$0.003
20 h agoPassed4021.2 s$0.003
Show 5 older checks
24 h agoPassed402429 ms$0.003
29 h agoPassed4021.2 s$0.003
33 h agoPassed4021.5 s$0.003
36 h agoPassed40281 ms$0.003
46 h agoPassed40244 ms$0.003