d1-database

SKILL.md

D1 is Cloudflare's native serverless SQL database built on SQLite. Run queries at the edge with automatic replication and low latency.

| Relational data | Structured tables with relationships | | Complex queries | JOINs, aggregations, full SQL support | | User data | Accounts, profiles, settings | | Content management | Posts, comments, metadata | | E-commerce | Products, orders, inventory | | Analytics | Event tracking with SQL queries |

| Execute query | db.prepare(sql).bind(...).run() | { success: boolean, meta: {...} } | | Get all rows | db.prepare(sql).bind(...).all() | { results: T[], success: boolean } | | Get first row | db.prepare(sql).bind(...).first() | T \| null | | Get single value | db.prepare(sql).bind(...).first('column') | any \| null |

Ver original