Database guides

SQLite and Turso

Sheeta AI works with local SQLite database files through libSQL, the SQLite fork from Turso. The SQLite and Turso SQLite types in the connection form both open a local file. There is no server to install.

Sheeta AI 0.5.2 does not connect to databases hosted on Turso Cloud. Only local files are supported.

Create a local database

The fastest way is Create Local DB in an empty Database sidebar. It creates a connection named Local (then Local 2 and so on) with a new database file in the project.

To create one with your own name:

  1. Click Manage database connections, then Add.
  2. Select SQLite or Turso SQLite.
  3. Enter a Connection Name. The Database Location fills in as sqlite-db/<connection-name>.db inside the project.
  4. Click Test Connection, then Save. The file and its folder are created on first use.

Because the file is inside the project, it is shared with the project when you use Git, unless you add it to .gitignore.

Open an existing database file

In the same form, click the folder button next to Database Location and choose a .db, .sqlite or .sqlite3 file anywhere on your computer. The form shows Connecting to an existing database when the file exists.

To copy tables from another SQLite file into a different database, use Importing Data.

SQLite syntax notes

  • SQLite uses flexible types: TEXT, INTEGER, REAL and BLOB.
  • Use INTEGER PRIMARY KEY for an auto-incrementing id.
  • All tables live in the main schema.
  • The ilike filter operator is not available, because SQLite has no ILIKE.

When to use SQLite

  • Quick prototyping without a database server
  • Exploring CSV or Excel files with SQL after importing them
  • Learning SQL
  • Working offline