Cloudflare D1Install

Summary

Execute multiple SQL queries in a single transaction

Inputs

• databaseId (required) — The unique identifier of your Cloudflare D1 database
• sqlQueries (required) — Array of SQL query objects each with a "sql" string and optional "params" array

Output shape

array of objects each containing queryIndex, success (boolean), results (array), meta (object) and optional error

results may be empty for read‑only queries; error field appears on failure

Examples

Example 1: Insert a new user and then select all users

{"databaseId": "12345", "sqlQueries":[{"sql":"INSERT INTO users (name) VALUES (?)","params":["Alice"]},{"sql":"SELECT * FROM users"}]}

Example 2: Multiple SELECT statements to fetch_counts

{"databaseId":"db_abc","sqlQueries":[{"sql":"SELECT COUNT(*) AS cnt FROM logs WHERE ts > ?","params":["2024-01-01"]},{"sql":"SELECT SUM(value) FROM metrics","params":[]}]}