Database guides

Turso

Turso connections in Sheeta AI provide local SQLite databases powered by libSQL. These databases are stored locally in your app data folder, making them ideal for quick prototyping, local development, and offline work.

What is a Turso connection?

A Turso connection creates a local SQLite-compatible database file on your machine. Key characteristics:

  • Local storage - Data is stored in your app data folder
  • No setup required - No server installation or configuration needed
  • SQLite compatible - Uses familiar SQLite syntax
  • Fast and lightweight - Perfect for development and testing

Creating a Turso database

Step 1: Open connection settings

Click the edit icon next to the connection dropdown to open the connection settings.

Step 2: Add a new connection

Click Add connection and select Turso.

Enter a name for your database:

  • Connection Name - A descriptive name for this database (e.g., "my-local-db")

The database file will be created automatically in your app data folder.

Turso connection form in Sheeta AI

Step 3: Save the connection

Click Save to create your local database. You can start using it immediately.

SQLite syntax notes

Turso databases use SQLite syntax, which differs slightly from PostgreSQL and MySQL:

  • Data types - SQLite uses flexible typing (TEXT, INTEGER, REAL, BLOB)
  • Auto-increment - Use INTEGER PRIMARY KEY instead of SERIAL
  • Single schema - All tables exist in the "main" schema

When to use Turso

  • Quick prototyping without database setup
  • Local development and testing
  • Learning SQL with a lightweight database
  • Offline work without network dependencies