Skip to main content
← back to extensions

Turso

@zocc/tursov2026.05.24.1· 10d agoMODELS·DATASTORES
01README

Turso (libSQL) datastore for swamp: query model for ad-hoc SQL against Turso edge databases, and a datastore backend that stores swamp runtime data in a remote Turso database with row-based distributed locking.

Model

Run SQL queries against Turso databases, list tables, inspect schemas, execute DDL/DML statements, and get database summaries. bash swamp model create @zocc/turso mydb swamp model method run mydb list_tables --input url="libsql://my-db-my-org.turso.io" --input authToken="..." swamp model method run mydb query --input url="libsql://my-db-my-org.turso.io" --input authToken="..." --input sql="SELECT * FROM users LIMIT 10" swamp model method run mydb summarize --input url="libsql://my-db-my-org.turso.io" --input authToken="..."

Datastore

Use Turso as the storage backend for swamp runtime data.

  type: "@zocc/turso-datastore"
  config:
    url: "libsql://my-db-my-org.turso.io"
    authToken: "${TURSO_AUTH_TOKEN}"
    tablePrefix: "swamp_"

bash export SWAMP_DATASTORE='@zocc/turso-datastore:{"url":"libsql://my-db-my-org.turso.io","authToken":"..."}'

Required Tools

  • A Turso database (https://turso.tech) - Auth token from turso db tokens create <db-name>
02Models1
@zocc/tursov2026.05.24.1query.ts
fn list_tables(url: string, authToken: string)
List all tables with their column names and types in a Turso database
ArgumentTypeDescription
urlstringDatabase URL (libsql:// or https://). Example: libsql://my-db-my-org.turso.io
authTokenstringTurso auth token (create with: turso db tokens create <db-name>)
fn query(url: string, authToken: string, sql: string, limit: number)
Execute a SQL query against a Turso database and return structured results
ArgumentTypeDescription
urlstringDatabase URL (libsql:// or https://)
authTokenstringTurso auth token
sqlstringSQL query to execute
limitnumberMaximum number of rows to return for SELECT queries (0 = unlimited)
fn execute(url: string, authToken: string, sql: string)
Execute a DDL or DML statement against a Turso database (CREATE, INSERT, UPDATE, DELETE, etc.)
ArgumentTypeDescription
urlstringDatabase URL (libsql:// or https://)
authTokenstringTurso auth token
sqlstringSQL statement to execute (DDL or DML)
fn summarize(url: string, authToken: string)
Get a high-level summary of all tables in a Turso database with row counts
ArgumentTypeDescription
urlstringDatabase URL (libsql:// or https://)
authTokenstringTurso auth token

Resources

tables(1h)— List of tables and their column schemas in a Turso database
query_result(1h)— Results of a SQL query against a Turso database
execute_result(1h)— Result of a DDL/DML statement execution
summary(1h)— High-level summary of all tables in a Turso database
03Datastores1
Turso Datastoreconfigurable
@zocc/turso-datastoreturso_datastore/mod.ts

Stores swamp runtime data in a remote Turso (libSQL) database with row-based distributed locking. Uses the Turso HTTP protocol — no CLI or native bindings required.

Config Fields

FieldTypeDescription
urlstringDatabase URL (libsql:// or https://). Example: libsql://my-db-my-org.turso.io
authTokenstringTurso auth token. Create with: turso db tokens create <db-name>
tablePrefixstringPrefix for swamp internal tables
04Stats
A
100 / 100
Downloads
2
Archive size
14.2 KB
  • Has README or module doc2/2earned
  • README has a code example1/1earned
  • README is substantive1/1earned
  • Most symbols documented1/1earned
  • No slow types1/1earned
  • Dependencies pass trust audit2/2earned
  • Has description1/1earned
  • Platform support declared (or universal)2/2earned
  • License declared1/1earned
  • Verified public repository2/2earned
Repository
https://github.com/CCAgentOrg/swamp-zocc-extensions/tree/main/datastore/turso
05Platforms
06Labels
#turso#libsql#sqlite#database#sql#edge#datastore#remote