Support Direct Import of SQLite Database Files into D1

[marceloverdijk]

Description

Currently, importing an existing SQLite database into Cloudflare D1 requires exporting the database to a SQL dump first, as described in the D1 import/export documentation.

Since D1 is built on SQLite, it would be great to support importing SQLite database files (.sqlite, .sqlite3, .db) directly, without requiring this intermediate conversion step.

Proposed Solution

Allow importing an existing SQLite database file directly using Wrangler, for example:

npx wrangler d1 import my-database --file=database.sqlite

Ideally, this would handle the necessary conversion and compatibility checks automatically.

Benefits

• Simpler workflow: Eliminate the intermediate SQL dump generation step.
• Better developer experience: Make migrating existing SQLite databases to D1 more straightforward.
• Easier automation: Simplify CI/CD pipelines and database deployment scripts.
• Fewer potential issues: Avoid problems related to SQL dump generation and import compatibility.

Additional Context

For projects that generate or maintain SQLite databases locally, the current workflow adds unnecessary complexity. Supporting direct SQLite file imports would make D1 much easier to integrate into existing SQLite-based workflows.