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

Wisdom at the edge

The plan Mongrel would build for your query.

Click any node below to see the plan detail 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.

-- 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;

-- 20 rows returned
-- ✓ 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 - paged results for reads, affected-row counts on writes.

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 rendered as a plan tree with SCAN/SEARCH nodes and the detail for each step. Spot the full table scan before it ships.

Index management

List, create, and drop indexes from the Indexes panel. The Index Advisor reads your query plans and surfaces EXPLAIN QUERY PLAN warnings.

Scheduled backups

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

Wrangler-style migrations

Versioned SQL migration files, applied through the D1 query API and tracked per database in a migrations ledger. Currently in beta.

Schema analysis

Tables, indexes, views, and triggers in one tree. Schema Analyzer sampling and drift snapshots catch when a database's shape changes.

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 suggests rewrites and candidate indexes - it proposes, never executes.

Connect Cloudflare D1 in 30 seconds.

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

Download Mongrel