Quickstart

Install

macOS / Linux
Windows

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

Run the following command in PowerShell:

irm https://github.com/tursodatabase/turso/releases/latest/download/turso_cli-installer.ps1 | iex

Alternatively, you can download the Windows executable and add it to your PATH.

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>

Execute

Now you can execute SQL statements in the interactive shell:

Create a table

Create a table for users:

CREATE TABLE users (id INT, username TEXT);

Insert data

Insert some data into the users table:

INSERT INTO users VALUES (1, 'alice');
INSERT INTO users VALUES (2, 'bob');

Query data

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.

Introduction JavaScript

Getting Started

Fundamentals

AI and Agents

CLI Reference

SQL Reference

Changelog

Experimental Features

​Experimental Features

Experimental Features