AGENT SKILL

d1-sql-playground

Use when editing d1-sql-playground. POST /query with { sql }; read-only SELECT against seeded D1 tables (products, experiments); binding DB.

01 前言 Front Matter

name: d1-sql-playground
description: Use when editing d1-sql-playground. POST /query with { sql }; read-only SELECT against seeded D1 tables (products, experiments); binding DB.

Routes: POST /query (body { sql }); GET / (app info + allowed tables).
Response (query): { columns, rows, rowCount, durationMs }.
Bindings: D1 database (DB).
Validation: validateSelectSql in src/lib/sql.ts — SELECT only, no semicolons/comments, allowed tables whitelist.
Utils: jsonError, jsonSuccess; migrations in migrations/0000_init.sql.

Use when editing whereami. GET /whereami returns request.cf (country, city, colo, etc.); no bindings.

Use when editing websocket-echo. GET /echo WebSocket upgrade; echoes messages.

Use when editing website-to-llms-txt. GET /llms.txt?url=; returns plain-text llms.txt format (title, description, links, contact); no bindings.

Use when editing website-to-api. GET /api?url=; returns structured title, headings, links, images.

Use when editing website-metadata-extractor. GET /metadata?url=; extracts title, description, canonical, og tags.

Use when editing website-devtools-inspector. GET /devtools?url=; headers, cookies, scripts, assets, metadata.