Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.turso.tech/llms.txt

Use this file to discover all available pages before exploring further.

1

Install

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/turso/releases/latest/download/turso_cli-installer.sh | sh
2

Launch

Then launch the interactive shell:
tursodb
This will start the Turso interactive shell where you can execute SQL statements:
Turso
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database
turso>
3

Execute

Now you can execute SQL statements in the interactive shell:
Create a table for users:
CREATE TABLE users (id INT, username TEXT);
Insert some data into the users table:
INSERT INTO users VALUES (1, 'alice');
INSERT INTO users VALUES (2, 'bob');
Query all users from the table:
SELECT * FROM users;
This will return:
1|alice
2|bob

​
Experimental Features

You can enable experimental features when launching tursodb using various flags such as --experimental-encryption, --experimental-mvcc, --experimental-strict, and --experimental-views. Note: These features are not production ready, so do not use them for critical data right now. For a complete list of available flags and options, see the Turso manual.