# AISkills402: SQL Dialect to SQLite Skill File

> AISkills402: SQL Dialect to SQLite Skill File 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-27).

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

## Facts

- Endpoint: GET https://api.aiskills402.com/v1/skills/sql-dialect-to-sqlite/file?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-27
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/aiskills402-sql-dialect-to-sqlite-skill-file-f3c5df36
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_DzdbaHFAf0qKuhRdYknEO

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 aiskills402-sql-dialect-to-sqlite-skill-file-f3c5df36
```

Example prompt: 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.

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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…

## Output

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.

## 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": "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>"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/aiskills402-sql-dialect-to-sqlite-skill-file-f3c5df36/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)