{"uid":"cap_qr6DZyW3WMxcTyk8_ZK4W","slug":"sqlite-search-builder-b2c4a273","name":"SQLite Search Builder","description":"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…","url":"https://api.aiskills402.com/v1/skills/sqlite-search-builder/file?utm_source=zero.xyz","method":"GET","headers":{},"bodySchema":{"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"}}}}},"responseSchema":{"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>"}}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_F0-wLtPjH84uEOqlpsRGi","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"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.","exampleAgentPrompt":"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'?","exampleUseCases":[{"title":"Accent-insensitive product search on D1","prompt":"My e-commerce site runs on Cloudflare D1 and customers can't find 'Café Blend' when they type 'cafe blend' — can you fetch the SQLite Search Builder skill and show me how to set up FTS5 so accents and case don't matter?"},{"title":"Part-number search ignoring hyphens","prompt":"Our product catalog has part numbers like 'AB-1042' but users type 'ab1042' and get no results — grab the SQLite Search Builder skill file and tell me how to configure FTS5 on Turso to normalize punctuation so those match."},{"title":"Plurals and word-order fix for site search","prompt":"Our Turso-backed site search fails when someone types 'red tomato' instead of 'Tomato, red', or 'tomatoes' instead of 'tomato' — fetch the SQLite Search Builder skill and walk me through the normalization pipeline to fix word order and stemming."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T18:35:06.359Z","isFirstParty":false,"canonicalSlug":"sqlite-search-builder-b2c4a273"}