granthdb

Sandbox

A real SQLite database, running in this tab against your browser's origin-private file system. Queries execute locally in a Web Worker — nothing is uploaded, and the data survives a reload.

Query

Opening database…
or Ctrl
Whatever you return is shown alongside — an array of rows becomes a table, anything else becomes JSON.

Result

Nothing run yet

Pick an example or write your own query, then press Run query. Rows that share a shape come back as a table; anything else as JSON.

Tables in this database
db.friends
++id, name, age, city, *tags, [name+age]
db.notes
++id, friendId, created

*tags matches any element of the array; [name+age] is one index over both fields.