AI agents for Cloudflare D1

Run a SQL query

Runs one read-only SQLite statement (SELECT or EXPLAIN; one statement, no semicolons inside) on the connected database and returns its rows.

List tables

Lists the database's tables and views with the statement that created each one (which shows its columns, keys and constraints), from sqlite_master, leaving out SQLite's and D1's own tables.

Describe a table

Lists a table's columns: each column's position, name, declared type, whether it is NOT NULL, its default and its place in the primary key (0 when not part of it), from pragma_table_info.

List databases

Lists the account's D1 databases, as result: each with its uuid (the database ID), name, created_at, version and jurisdiction; result_info has the page and the total count.

Insert, update or create

Runs one statement that adds or changes data: INSERT (including INSERT OR REPLACE and ON CONFLICT upserts), UPDATE, REPLACE, or CREATE (a table, index, view or trigger).

Run several statements as a batch

Runs up to 20 statements in order in one call, each with its own ?

Run any SQL statementDeletes data

Runs any one SQLite statement D1 allows, including DELETE, DROP and ALTER: this is the action that can remove data, and it cannot be undone.