Cloudflare D1 · supported engine

D1 at the edge, edited like a file.

SQL execution over the Cloudflare REST API, row browsing and editing, EXPLAIN QUERY PLAN, scheduled backups, wrangler-style migrations, and schema analysis for your D1 databases.

Included with Mongrel Try free for 7 days

Cloudflare REST API · SQLite-family

Live · click to inspect

The plan Mongrel would build for your query.

Click any node below to see rows read, latency, and what Mongrel would suggest. Same view you get inside the workbench.

// SCAN · orders · full table

Reads all 80,231 rows in orders because nothing indexes status or created_at. This is the hot spot — 62% of total query time.

-- orders-db · production (D1)
SELECT
  o.id, o.total,
  u.email, i.quantity
FROM orders o
JOIN users u ON u.id = o.user_id
JOIN order_items i ON i.order_id = o.id
WHERE o.status = 'paid'
ORDER BY o.created_at DESC
LIMIT 20;

-- rows_read 80,231 · duration 312ms
-- ✓ Proposal: composite index on (status, created_at)

CREATE INDEX idx_orders_status_created
  ON orders (status, created_at);

-- ship it as a D1 migration:
-- wrangler d1 migrations create orders-db add_status_created_index
-- wrangler d1 migrations apply orders-db --remote

Cloudflare D1 surface

What Mongrel ships for Cloudflare D1.

SQL over the REST API

Run SQL against any D1 database through the Cloudflare REST API. Typed results with D1 meta — rows_read, rows_written, duration — on every call.

Browse & edit like a file

Tables, rows, and inline editing with the same grid Mongrel uses for local SQLite. Insert, update, and delete against the edge database directly.

EXPLAIN QUERY PLAN

SQLite-family plan inspection with SCAN/SEARCH nodes, rows-read estimates, and latency per step. Spot the full table scan before it ships.

Index management

Create and drop indexes from the UI. Mongrel flags missing indexes from your query plans and drafts the CREATE INDEX for you.

Scheduled backups

Scheduled logical exports of your D1 databases. Keep point-in-time snapshots outside the platform, on your own schedule.

Wrangler-style migrations

Numbered SQL migration files, applied and tracked per database. Pairs with wrangler d1 migrations workflows instead of replacing them.

Schema analysis

Tables, indexes, views, and triggers in one tree. Detect drift between databases and preview the DDL diff before applying it.

API token profiles

Cloudflare API tokens stored in the OS keychain, scoped per account and database. No credentials in project files or connection strings.

AI explain & rewrite

Paste a query and its plan. The assistant rewrites it, proposes indexes, and shows the predicted EXPLAIN QUERY PLAN — it proposes, never executes.

Connect Cloudflare D1 in 30 seconds.

7-day trial. macOS, Windows, Linux. No credit card.

Download Mongrel