// AI Platform Drift
D1 export now supports databases with virtual tables
Cloudflare developer changelog · published 2026-11-14 18:05 UTC
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 verdict | MATERIAL at 0.92, needed 0.5 |
|---|---|
| triage reasoning | New D1 export API parameter and wrangler flag enable virtual table exports with documented re-import restriction. |
| signals | new 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 model | anthropic/claude-haiku-4.5 ($0.00000) |
| writer model | anthropic/claude-sonnet-4.5 ($0.00000) |