tursodb [OPTIONS] [DATABASE] [SQL]

# In-memory database
tursodb

# Open an existing file
tursodb customers.db

# Run a query and exit
tursodb customers.db "SELECT count(*) FROM orders;"

# Pipe SQL from stdin
echo "SELECT 1 + 1;" | tursodb -q

tursodb -m list mydata.db "SELECT * FROM users;"

tursodb -o results.txt mydata.db "SELECT * FROM users;"

tursodb -q mydata.db

echo "SELECT 42;" | tursodb -q -e

SELECT 42;
42

tursodb -v memory

tursodb -t trace.log mydata.db

tursodb --readonly production.db "SELECT count(*) FROM users;"

tursodb --readonly production.db "INSERT INTO users VALUES (1, 'test');"
# Error: Resource is read-only

tursodb --mcp mydata.db

tursodb --sync-server 0.0.0.0:8080 mydata.db

# Enable views, triggers, and in-place VACUUM
tursodb --experimental-views --experimental-triggers --experimental-vacuum mydata.db