AI agents for Turso

Run a SQL query

Runs one read-only SQLite statement (SELECT or EXPLAIN; one statement, no semicolons inside) and returns its rows.

List tables

Lists the database's tables and views with the statement that created each one (which shows its columns, keys and constraints), from sqlite_master.

Describe a table

Lists a table's columns: each column's position, name, declared type, whether it is NOT NULL, its default and its place in the primary key (0 when not part of it), from pragma_table_info.

Insert, update or create

Runs one statement that adds or changes data: INSERT (including INSERT OR REPLACE and ON CONFLICT upserts), UPDATE, REPLACE, or CREATE (a table, index, view or trigger).

Apply changes as one transaction

Runs up to 10 statements in order inside one transaction (BEGIN, the statements, COMMIT).

Run any SQL statementDeletes data

Runs any one SQLite statement, including DELETE, DROP, ALTER and anything else the token is allowed to do: this is the action that can remove data, and it cannot be undone.