Skills · File

Guest listing — api.aiskills402.com. 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

0.05 USDC on Base · payTo 0xbc0dcc70d8b5d85541d86ffc68d988fd59c22e68

Status: verified · payable

Settlement: direct to the seller's payTo — 0% HIVE402 take

Payment routes

Base · 0.05 USDC · payTo 0xbc0dcc70d8b5d85541d86ffc68d988fd59c22e68 · via guests · settles direct

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