{"uid":"cap_DzdbaHFAf0qKuhRdYknEO","slug":"aiskills402-sql-dialect-to-sqlite-skill-file-f3c5df36","name":"AISkills402: SQL Dialect to SQLite Skill File","description":"Postgres or MySQL SQL to SQLite and D1 — Converts PostgreSQL or MySQL schema statements, migrations and queries into SQLite that Cloudflare D1 and Turso run, so the converted version behaves like the original and not only parses. Knows the conversions that run without an error and then go wrong - a key written as BIGSERIAL or INT AUTO_INCREMENT that SQLite stores as NULL, a custom enum type or an inline enum that stops checking anything, a default now() or gen_random_uuid() that fails on the fi…","url":"https://api.aiskills402.com/v1/skills/sql-dialect-to-sqlite/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":"Postgres or MySQL SQL to SQLite and D1","skill":"sql-dialect-to-sqlite","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_F4ZDsHgxBXMz7YAkSVoBl","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":"Purchases and downloads a SKILL.md file that teaches an AI agent to convert Postgres or MySQL SQL to SQLite/D1 syntax, paid once via x402 in USDC on Base","exampleAgentPrompt":"Buy and download the SQL-dialect-to-SQLite SKILL.md from AISkills402 so I can teach you to convert Postgres or MySQL SQL into SQLite and Cloudflare D1 compatible syntax — pay the one-time $0.01 USDC fee over x402.","exampleUseCases":[{"title":"Migrate Postgres schema to Cloudflare D1","prompt":"Get me the sql-dialect-to-sqlite skill file from AISkills402 — I need to migrate a Postgres schema over to Cloudflare D1 and want you to know all the dialect differences."},{"title":"Port MySQL queries for a SQLite-backed app","prompt":"Buy the SQL dialect to SQLite conversion skill from AISkills402 so you can help me rewrite our MySQL queries to work in SQLite for the new local-first version of our app."},{"title":"Equip agent with SQL translation capability","prompt":"Purchase the sql-dialect-to-sqlite SKILL.md from AISkills402 for $0.01 USDC and load it so you can handle SQL dialect conversions going forward whenever I paste in a Postgres or MySQL query."}],"resultDescription":"Returns a JSON object containing the full UTF-8 content of the SKILL.md file (named 'Postgres or MySQL SQL to SQLite and D1'), the skill identifier, version (1.0.0), a SHA256 hash of the file for integrity verification, a blockchain settlement receipt with the transaction hash, and a redownload URL and token for future free retrieval of the same or updated versions.","failureModes":["Payment not settled — x402 payment rejected or USDC balance insufficient, no file returned","Invalid or missing payment header — 402 response requiring correct x402 authorization","Network timeout — slow blockchain settlement causing delayed response","Redownload token lost — if token is not stored, free redownload capability is unavailable","Version mismatch — cached skill may differ from latest version available"],"whenToPreferThis":"Choose this endpoint when an AI agent needs a tested, ready-to-use SKILL.md instruction file specifically for converting Postgres or MySQL SQL syntax into SQLite/Cloudflare D1 compatible SQL, and the agent supports x402 micropayments in USDC on Base. Prefer this over hand-crafting SQL conversion prompts when you want a pre-validated, versioned, and redownloadable skill asset for long-term use.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-27T19:21:03.151Z","isFirstParty":false,"canonicalSlug":"aiskills402-sql-dialect-to-sqlite-skill-file-f3c5df36"}