// AI Platform Drift

D1 export now supports databases with virtual tables

Cloudflare developer changelog · published 2026-11-14 18:05 UTC
WORTH KNOWING VERIFY_ONLY API
WHAT CHANGEDCloudflare D1 added a dump_options.compatibility parameter with value sqlite3_cli_only to the export API and a --compatibility flag to wrangler d1 export. This enables exporting databases containing virtual tables (FTS5 full-text search, R*Tree spatial indexes), which previously failed. Exports using this option cannot be re-imported to D1.
WHY IT MATTERSD1 databases using SQLite virtual tables for full-text search or spatial indexing can now be backed up or migrated to external SQLite environments. The export is one-way: you cannot restore these dumps back into D1, so this is for archival or migration out of D1, not for backup-and-restore workflows within D1.
WHAT TO DOIf you have D1 databases with FTS5 or R*Tree tables that you need to export, add "compatibility": "sqlite3_cli_only" to dump_options in the export API call or use --compatibility sqlite3_cli_only with wrangler d1 export. Do not use this option if you need to re-import the dump to D1; use standard export instead.
Model-reported confidence 85% (not measured accuracy) Primary source ↗ written by anthropic/claude-sonnet-4.5
Show the reasoning — raw diff, triage verdict, confidence
RAW DIFF
+## D1 - Export D1 databases with virtual tables
+https://developers.cloudflare.com/changelog/post/2026-11-12-d1-export-virtual-tables/
+Thu, 12 Nov 2026 00:00:00 GMT
+
+You can now export a D1 database that contains virtual tables, such as full-text search tables using SQLite's FTS5 module ↗︎ or spatial index tables using the R*Tree module. Previously, export failed for any database containing virtual tables.
+To include virtual tables in the dump, set dump_options.compatibility to sqlite3_cli_only on the D1 export API. The same option is available as the --compatibility flag on wrangler d1 export.
+Import is not supportedThis dump targets the SQLite CLI only. You cannot import it back into D1. Use the standard export for databases without virtual tables.
+curl "https://api.cloudflare.com/client/v4/accounts/$ACCOUNT_ID/d1/database/$DATABASE_ID/export" \
+--request POST \
+--header "Authorization: Bearer $CLOUDFLARE_API_TOKEN" \
+--json '{
+"output_format": "polling",
+"dump_options": {
+"compatibility": "sqlite3_cli_only"
+}
+}'
+For more information, refer to Export a D1 database with virtual tables.
HOW IT WAS JUDGED
Triage signals below are model-reported assertions, preserved verbatim; they are not independent arithmetic verification.
triage verdictMATERIAL at 0.92, needed 0.5
triage reasoningNew D1 export API parameter and wrangler flag enable virtual table exports with documented re-import restriction.
signalsnew API capability added · new dump_options.compatibility parameter introduced · new --compatibility flag for wrangler d1 export · breaking limitation documented: exports with virtual tables cannot be re-imported to D1 · API contract change: sqlite3_cli_only option enables previously-failing export operations
suppression—
triage modelanthropic/claude-haiku-4.5 ($0.00000)
writer modelanthropic/claude-sonnet-4.5 ($0.00000)