Export
Export your Shard data
You can export your entire Shard as a SQL file at any time. This creates a complete backup of all your tables, data, and schema that can be imported into any SQLite-compatible database.
How to Export
Section titled “How to Export”- Open Settings from the left sidebar
- Click “Export Shard”
- Choose a location to save the
.sql
file - Your export will download immediately
The exported SQL file contains all table definitions, indexes, and data from your Shard. You can use this file to:
- Back up your data for safekeeping
- Migrate to another database system
- Share your Shard structure with others
- Restore data after testing or development
What’s Included
Section titled “What’s Included”The export includes:
- All table schemas (column names, types, constraints)
- All row data from every table
- Indexes and other database objects
- SQLite-compatible SQL statements
Using Your Export
Section titled “Using Your Export”The exported .sql
file can be imported into:
- Another Shard instance
- SQLite command-line tools (
sqlite3 database.db < export.sql
) - Database management applications
- Any SQLite-compatible system