ToolVet
78trust / 100

Sql Generate

by SiteCheck in Developer tools

x402 APIPassing, checked 2 h ago

SQL from a question and a schema (CREATE TABLE statements or a JSON description of tables and columns), for postgres (default), mysql, sqlite or bigquery. The tables and columns used are checked against the schema; a query that does not match it is retried once, then refused. Writes (INSERT, UPDATE, DELETE, DDL) are refused unless allowWrite is true. The query is not run.

POST
https://api.sitecheck-api.workers.dev/api/sql/generate
Price
$0.003
per call in USDC
Uptime
100%
last 30 days
Response time
49 ms
49 ms slowest 5%
Last check
Passed
2 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 · Watch with other listings

How to call it

POST https://api.sitecheck-api.workers.dev/api/sql/generate

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.

POST https://api.sitecheck-api.workers.dev/api/sql/generate
content-type: application/json

{
  "dialect": "postgres",
  "question": "How many orders were placed in 2025?",
  "schema": "CREATE TABLE orders (id integer primary key, placed_at timestamp, total numeric(10,2));"
}

Parameters

ParameterTypeRequiredDescription
allowWritebooleanNoAllow INSERT, UPDATE, DELETE or DDL (default false)
dialectstringNopostgres (default), mysql, sqlite or bigquery
questionstringYesQuestion in plain language (max 1,000 characters)
schemastringYesCREATE TABLE statements, or a JSON object of tables and column lists (max 20,000 characters)

Example response

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

{
  "checkedAt": "2026-10-15T18:21:17.416Z",
  "columns": [
    {
      "column": "id",
      "table": "orders"
    },
    {
      "column": "placed_at",
      "table": "orders"
    }
  ],
  "dialect": "postgres",
  "explanation": "This query counts the number of rows in the orders table where the year of the placed_at timestamp is 2025.",
  "note": "The query was not run. Tables and columns were checked against the schema you gave; review the SQL before running it.",
  "readOnly": true,
  "sql": "SELECT COUNT(id) FROM orders WHERE EXTRACT(YEAR FROM placed_at) = 2025",
  "tables": [
    "orders"
  ]
}

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 -X POST 'https://api.sitecheck-api.workers.dev/api/sql/generate' \
  -H 'content-type: application/json' \
  --data-raw '{"dialect":"postgres","question":"How many orders were placed in 2025?","schema":"CREATE TABLE orders (id integer primary key, placed_at timestamp, total numeric(10,2));"}'

# 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 - -X POST 'https://api.sitecheck-api.workers.dev/api/sql/generate' \
  -H 'content-type: application/json' \
  --data-raw '{"dialect":"postgres","question":"How many orders were placed in 2025?","schema":"CREATE TABLE orders (id integer primary key, placed_at timestamp, total numeric(10,2));"}' \
  | 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%2Fapi.sitecheck-api.workers.dev%2Fapi%2Fsql%2Fgenerate&method=POST
const res = await pay("https://api.sitecheck-api.workers.dev/api/sql/generate", {
  method: "POST",
  headers: { "content-type": "application/json" },
  body: JSON.stringify({
    "dialect": "postgres",
    "question": "How many orders were placed in 2025?",
    "schema": "CREATE TABLE orders (id integer primary key, placed_at timestamp, total numeric(10,2));"
  }),
});
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.post(
        "https://api.sitecheck-api.workers.dev/api/sql/generate",
        json={
            "dialect": "postgres",
            "question": "How many orders were placed in 2025?",
            "schema": "CREATE TABLE orders (id integer primary key, placed_at timestamp, total numeric(10,2));",
        },
    )
    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
2 h agoPassed40249 ms$0.003