Cloudflare D1 client

Enter a D1 database name or UUID, Cloudflare account ID and API Token. The token stays in the macOS Keychain. Requests use HTTPS; there is no host, port, TLS setting or SSH tunnel.

Create a token with Account > D1 > Edit permission and copy it when shown. It grants access to every D1 database in the account, not just the selected one.

Importing a d1://account-id/database-name URL fills in the account and the database; the token never travels in the URL, so paste it in afterwards.

Switch between the account’s D1 databases without reconnecting. The switcher also creates and drops databases. Existing tabs keep their starting database.

Queries use SQLite’s dialect. EXPLAIN QUERY PLAN is drawn as a diagram, and row edits wait in the grid until you save, with Preview SQL showing the statements first.

Write each statement so it stands on its own: a PRAGMA setting or a temporary table made by one statement is gone by the next, and every statement commits when it runs, with nothing to roll back. When Cloudflare rate-limits a request, the error carries the wait Cloudflare asked for before a retry.

The Structure tab creates and drops tables, adds and drops columns, and creates and drops indexes, including partial indexes with a WHERE condition; Preview SQL shows the DDL before you save. The Triggers tab creates, edits and drops triggers, and tables can be renamed from the sidebar.

A column reorder or a foreign key change means rebuilding the table. On D1, TablePro writes that rebuild script and hands it to you to run, because every statement is a separate request and no transaction can hold the rebuild together.

TablePro has no import for D1. Load a SQL file with wrangler d1 execute and its --file option, then browse the result here. Export writes a D1 table or a query result as CSV, JSON, SQL, XLSX, Markdown, HTML and XML.

The iPhone and iPad app has no Cloudflare D1 driver. Cloudflare D1 connections synced from a Mac appear in its list but do not open.