Cloudflare D1 icon

Cloudflare D1

Execute operations against Cloudflare D1 serverless databases. Supports structured operations (Insert, Select, Update, Delete), raw SQL queries, and can be used as a tool by AI Agents.

Actions25

Query → Execute Raw SQL

AI-generated

Summary

Execute a raw SQL command against a Cloudflare D1 database.

Inputs

  • databaseId (required) — The unique identifier of your Cloudflare D1 database. You can find this in your Cloudflare Dashboard under D1 databases.
  • rawSqlCommands (required) — Raw SQL commands to execute. Use with caution - no parameter binding is performed.

Output shape

An object containing success flag, results, and meta information

May return an error envelope on failure; otherwise returns the query result.

Examples

Example 1: Create a users table

databaseId: "my-db" rawSqlCommands: "CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);"

Example 2: Insert a row

databaseId: "my-db" rawSqlCommands: "INSERT INTO users (name) VALUES ('Alice');"

Example 3: Select data

databaseId: "my-db" rawSqlCommands: "SELECT * FROM users;"

Discussion