You can create a new database in a specific group using the following command:

turso db create [database-name]

The [database-name] argument is optional. If you don’t provide a name, the Turso team will use the name of your project.

If you have more than one group, you will need to pass the --group flag.

Flags

FlagDescription
--canaryUse database canary build.
--csv-table-nameName of the table in the csv file.
--enable-extensionsEnables experimental support for SQLite extensions.
--from-csvCreate the database from a csv file.
--from-dbSelect another database to copy data from.
--from-dumpCreate the database from a local SQLite dump.
--from-dump-urlCreate the database from a remote SQLite dump.
--from-fileCreate the database from a local SQLite3-compatible file.
--groupCreate the database in the specified group.
-h, --helpGet help for create.
--timestampSet a point in time in the past to copy data from the selected database.

Must be used with the ‘from-db’ flag. Must be in RFC3339 format like ‘2023-09-29T10:16:13-03:00’
-w, --waitWait for the database to be ready to receive requests.

Examples

The examples below outline the most common use cases for the db create command.

Create database in a specific group

You can create a new database in a specific group using the --group flag:

turso db create [database-name] --group <group-name>

Create database from SQLite file

You can create a new Turso database from an existing SQLite file using the --from-file flag:

turso db create [database-name] --from-file ./path/to/file.db

The file size is limited to 2GB.

Create database from SQLite dump

You can create a new database using the output of .dump using the --from-dump flag:

turso db create [database-name] --from-dump ./path/to/dump.sql

Create database from another existing database

You can create a new Turso database from an existing database using the --from-db flag:

turso db create [database-name] --from-db <existing-database-name>

Create database from a point in time

You can create a new Turso database from an existing database at a specific point in time using the --from-db and --timestamp flags:

turso db create [database-name] --from-db <existing-database-name> --timestamp 2024-01-01T10:10:10-10:00

Create database from a CSV file

You can create a new Turso database from a CSV file using the --from-csv flag:

turso db create [database-name] --from-csv ./path/to/file.csv --csv-table-name <desired-table-name>