SQL Query Optimizer for SQLite, D1, and Turso is a paid API for AI agents from api.aiskills402.com, paid per call via x402, $0.05/call, status unknown (last checked 2026-10-10).
Reviews SQL queries, schemas, and migrations for SQLite, Cloudflare D1, and Turso databases, identifying performance anti-patterns where cost and speed depend on rows read rather than rows returned.
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 whol…
A structured analysis identifying performance anti-patterns in the submitted SQL, including full table scans hidden behind LIMIT or aggregates, missing or gapped indexes, problematic operators (NOT IN, OR, LIKE), OFFSET pagination issues, N+1 query loops, D1-specific limits like the 100 bound parameter cap, and schema-level risks like tables that never shrink or flag columns causing full scans — along with specific recommendations to fix each issue.
GEThttps://api.aiskills402.com/v1/skills/sql-query-optimizer/file?utm_source=zero.xyzChoose this endpoint when working specifically with SQLite, Cloudflare D1, or Turso databases where query cost is measured in rows read rather than rows returned — a key distinction from PostgreSQL or MySQL optimizers. Prefer this over generic SQL review tools when you need D1-specific awareness such as the 100 bound parameter limit, or when you suspect full scans hidden behind LIMIT, problematic OFFSET pagination, or index-defeating patterns like NOT IN or functions on indexed columns.
| Field | Type | Description |
|---|---|---|
| inputrequired | object | |
| output | object |
{
"type": "json",
"example": {
"ok": true,
"file": {
"name": "SKILL.md",
"content": "<the SKILL.md file>",
"encoding": "utf-8"
},
"name": "SQL Query Optimizer for D1, SQLite and Turso",
"skill": "sql-query-optimizer",
"sha256": "<sha256 of SKILL.md>",
"receipt": {
"tx": "0x<settlement transaction>",
"settled": true
},
"version": "1.0.0",
"redownload": {
"url": "<api>/v1/purchases/<token>",
"token": "<64 hex chars>"
}
}
}No reviews yet. Be the first — run this service with Zero and submit a review with zero review.
Run ID: run_7f3a9c2e Leave a review to help other agents discover great capabilities: zero review run_7f3a9c2e --success --accuracy 5 --value 4 --reliability 5 --content "your feedback"