76trust / 100

Sql Query Optimizer File

by SQL Query Optimizer for D1 in Developer tools

x402 APIPassing, checked 2 h ago

SQL Query Optimizer for D1, SQLite and Turso — Reviews SQL queries, schemas and migrations for SQLite, Cloudflare D1 and Turso, where the bill and the speed follow the rows a query READS, not the rows it returns. Finds full scans hidden behind LIMIT, aggregates over growing tables, index column gaps, NOT IN, OR, functions and LIKE patterns that switch an index off, OFFSET pagination, N+1 loops, the D1 limit of 100 bound parameters, tables that never shrink and new flag columns that turn the who…

GET
https://api.aiskills402.com/v1/skills/sql-query-optimizer/file
Price
$0.05
per call in USDC
Uptime
97.1%
last 30 days
Response time
552 ms
916 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

GET https://api.aiskills402.com/v1/skills/sql-query-optimizer/file

Each call costs $0.05 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

The listing has no example input.

GET https://api.aiskills402.com/v1/skills/sql-query-optimizer/file

Example response

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

{
  "file": {
    "content": "<the SKILL.md file>",
    "encoding": "utf-8",
    "name": "SKILL.md"
  },
  "name": "SQL Query Optimizer for D1, SQLite and Turso",
  "ok": true,
  "receipt": {
    "settled": true,
    "tx": "0x<settlement transaction>"
  },
  "redownload": {
    "token": "<64 hex chars>",
    "url": "<api>/v1/purchases/<token>"
  },
  "sha256": "<sha256 of SKILL.md>",
  "skill": "sql-query-optimizer",
  "version": "1.0.0"
}

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.05.

curl: see the payment challenge
# bash or zsh: see the payment challenge. Nothing is charged.
curl -sS -g -i 'https://api.aiskills402.com/v1/skills/sql-query-optimizer/file'

# 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://api.aiskills402.com/v1/skills/sql-query-optimizer/file' \
  | 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.05 per call.
const client = new x402Client().setSpendControls({ maxAmountPerPayment: "$0.05" });
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.05 per payment. GET https://toolvet.app/api/v1/check?url=https%3A%2F%2Fapi.aiskills402.com%2Fv1%2Fskills%2Fsql-query-optimizer%2Ffile
const res = await pay("https://api.aiskills402.com/v1/skills/sql-query-optimizer/file");
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.05 per call.
client = x402ClientSync().set_spend_controls({"max_amount_per_payment": "$0.05"})
register_exact_evm_client(client, EthAccountSigner(Account.from_key(os.environ["EVM_PRIVATE_KEY"])))

with x402_requests(client) as session:
    res = session.get("https://api.aiskills402.com/v1/skills/sql-query-optimizer/file")
    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 agoPassed402245 ms$0.05
7 h agoPassed402182 ms$0.05
11 h agoPassed402714 ms$0.05
16 h agoPassed402252 ms$0.05
21 h agoPassed402513 ms$0.05
Show 10 older checks
25 h agoPassed402434 ms$0.05
30 h agoPassed402180 ms$0.05
34 h agoPassed402660 ms$0.05
38 h agoPassed4021.0 s$0.05
42 h agoPassed402725 ms$0.05
46 h agoPassed402647 ms$0.05
2 days agoPassed402762 ms$0.05
2 days agoPassed402586 ms$0.05
2 days agoPassed402774 ms$0.05
3 days agoPassed402552 ms$0.05