{"uid":"cap_RrSb4tMLldV7wnJLN6M9e","slug":"aiskills402-d1-migration-writer-skill-md-090624e8","name":"AISkills402: D1 Migration Writer SKILL.md","description":"D1 Migration Writer: SQLite Migrations That Apply — Writes a SQL migration for Cloudflare D1 or SQLite from the current schema and the change wanted, so it applies on the first try and leaves the rows already in the database right. Knows what D1 refuses or breaks on, measured on a real D1 database - BEGIN and COMMIT in the file, foreign keys that cannot be switched off (a rebuild defers them, keeps the table name, and never closes with defer_foreign_keys = false, which on D1 silently skips the …","url":"https://api.aiskills402.com/v1/skills/d1-migration-writer/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":"D1 Migration Writer: SQLite Migrations That Apply","skill":"d1-migration-writer","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.07","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.07/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.07","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.07","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_tToM-qc4sZxBsIgszTiG-","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.07","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Purchases and downloads the 'D1 Migration Writer' SKILL.md file — a tested AI agent skill for writing SQLite migrations compatible with Cloudflare D1 — paying once in USDC over x402.","exampleAgentPrompt":"Buy me the D1 Migration Writer skill from AISkills402 — I need my agent to be able to write SQLite migrations that apply cleanly on Cloudflare D1, and I want to own the SKILL.md file permanently.","exampleUseCases":[{"title":"Equip agent with D1 migration skill","prompt":"Get me the D1 Migration Writer SKILL.md from AISkills402 so my coding agent knows how to write SQLite migrations that work correctly with Cloudflare D1 — pay for it with my USDC wallet."},{"title":"One-time purchase for persistent access","prompt":"Purchase the D1 migration writer skill once and save the redownload token — I want to be able to fetch the latest version any time without paying again."},{"title":"Verify skill integrity after download","prompt":"Download the D1 Migration Writer SKILL.md and check the SHA256 hash matches what AISkills402 returns so I know the file hasn't been tampered with."}],"resultDescription":"Returns a JSON object containing the SKILL.md file name, full UTF-8 text content, SHA256 hash for integrity verification, skill identifier ('d1-migration-writer'), version number, a redownload URL and token for future free re-fetches, and a payment receipt with the on-chain settlement transaction hash confirming the USDC payment on Base.","failureModes":["Payment not received or x402 flow incomplete — returns 402 Payment Required","Insufficient USDC balance in agent wallet — payment fails before skill is delivered","Network error reaching api.aiskills402.com — connection timeout or 5xx","Invalid or malformed payment header — 400 Bad Request","Skill file temporarily unavailable — 503 Service Unavailable"],"whenToPreferThis":"Choose this endpoint when an AI agent needs to acquire a tested, ready-to-use SKILL.md instruction set for writing Cloudflare D1-compatible SQLite migrations, and the agent has a USDC wallet on Base capable of x402 micropayments. Prefer this over writing migration logic from scratch when you want a curated, versioned skill with integrity verification and permanent redownload rights after a single $0.07 purchase.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-14T06:47:39.586Z","isFirstParty":false,"canonicalSlug":"aiskills402-d1-migration-writer-skill-md-090624e8"}