# SQLite Search Builder

> SQLite Search Builder is a paid API for AI agents from api.aiskills402.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-11).

Returns a SKILL.md file with a complete SQLite FTS5 search implementation that handles fuzzy matching, accent folding, stemming, and partial word search for site or product search.

## Facts

- Endpoint: GET https://api.aiskills402.com/v1/skills/sqlite-search-builder/file?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-11
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/sqlite-search-builder-b2c4a273
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_qr6DZyW3WMxcTyk8_ZK4W

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability sqlite-search-builder-b2c4a273
```

Example prompt: Can you get me the SQLite Search Builder skill file so I can implement accent-insensitive, stemming-aware FTS5 full-text search on my Cloudflare D1 database — I need it to match 'cafe' to 'Café', plurals to singulars, and partial words like 'tom' to 'tomatoes'?

## When to prefer this

Choose this endpoint when you need a ready-to-implement, opinionated solution for SQLite FTS5 search on D1, Turso, or SQLite that handles the full normalization pipeline (accents, stemming, word order, punctuation, partial words) in one retrievable skill file. Prefer this over building from scratch when targeting SQLite-family databases specifically, as it is tuned for FTS5 constraints and D1/Turso deployment patterns rather than generic search engines like Elasticsearch or Algolia.

## Known failure modes

- Payment not settled — x402 payment required before file is returned
- Invalid HTTP method — only GET or HEAD are accepted
- Network timeout on D1/Turso side during settlement verification
- Malformed Authorization header causes 401 response
- Rate limiting if too many rapid requests from same origin

## How this service works

SQLite Search Builder: Builds or fixes a site or product search so it finds what the user meant, with SQLite full-text search (FTS5) on D1, Turso or SQLite. Word order, singular or plural, endings, case, punctuation and accents stop mattering ("cafe" finds "Café", "tomatoes" finds "tomato", "red tomato" finds "Tomato, red", "ab1042" finds "AB-1042"), and the start of a word is enough ("tom" finds "tomatoes"). Gives one normalize pipeline for accent-insensitive search, a query-side ending remove…

## Output

Returns a SKILL.md markdown file containing a complete implementation guide and code for SQLite FTS5 search with accent folding, stemming, case normalization, punctuation stripping, and partial-word matching for D1, Turso, or SQLite. Also includes a SHA256 hash for verification, a redownload token/URL, and a settlement receipt confirming payment.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method"
   ],
   "properties": {
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "enum": [
      "GET",
      "HEAD"
     ],
     "type": "string"
    },
    "headers": {
     "type": "object",
     "additionalProperties": {
      "type": "string"
     }
    }
   },
   "additionalProperties": false
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "type": "string"
    },
    "example": {
     "type": "object"
    }
   }
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "ok": true,
  "file": {
   "name": "SKILL.md",
   "content": "<the SKILL.md file>",
   "encoding": "utf-8"
  },
  "name": "SQLite Search Builder",
  "skill": "sqlite-search-builder",
  "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>"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/sqlite-search-builder-b2c4a273/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from api.aiskills402.com](https://www.zero.xyz/host/api.aiskills402.com/llms.txt)