OIP system: Cloudflare D1
Cloudflare D1
A generated article for one OIP shelf. It lists every operation in this API/CLI/MCP/device/model/core subsystem, links each leaf article, and gives the ledger path for proof.
This page is the operating article for one build subsystem. It is generated from live directory rows. If a task belongs to this subsystem, scan the operations below, open the matching capability article, run only the exact object named there, and verify by receipt.
Kind: api. Capabilities: 3. Machine system map: /api/dispatch?map=D1&format=markdown. Root: /a/oip.
Operations
D1_QUERY
Run a SELECT query on the D1 database. Use when: any read operation on D1 tables. Arguments: $1 = SQL query. Include ? for bound parameters and pass them after |.. Human article: /a/oip-capability-d1-query. Machine doc: ?key=D1_QUERY&format=markdown. Invocation history: /api/invocations?object_id=D1_QUERY.
D1_EXEC
Run a non-SELECT D1 query (INSERT/UPDATE/DELETE). Use when: writing data to D1. Arguments: $1 = SQL. Pipes inside SQL are preserved.. Human article: /a/oip-capability-d1-exec. Machine doc: ?key=D1_EXEC&format=markdown. Invocation history: /api/invocations?object_id=D1_EXEC.
D1_TO_2D_ARRAY
Run a SQL SELECT and return a 2D array (header row + values) suitable for sheets_replace_tab. $1=SQL Use when: you need to d1 to 2d array Arguments: $1. Human article: /a/oip-capability-d1-to-2d-array. Machine doc: ?key=D1_TO_2D_ARRAY&format=markdown. Invocation history: /api/invocations?object_id=D1_TO_2D_ARRAY.