You can connect directly to a Turso database by using the following command:

turso db shell <database-name | replica-url> [sql] [flags]

Flags

FlagDescription
--instanceConnect to the specified database instance.
---location nrtConnect to the database at the specified location.
--proxyThe proxy to use when connecting to the database.

Examples

Execute SQL

You can execute SQL directly against a database using the shell:

turso db shell <database-name> "SELECT * FROM users"

Database dump

You can dump the contents of a Turso dataase using the following command:

turso db shell <database-name> .dump > dump.sql

The .dump can be used to rebuild a database and doesn’t contain any libSQL or SQLite internal tables.

Load from dump

You can load a dump file into a new database using the following command:

turso db shell <database-name> < dump.sql

Shell with libSQL server

If you’re using turso dev locally, you can use the shell by providing the URL to your database:

turso db shell http://127.0.0.1:8080