Query a local SQLite database
Open a SQLite file, inspect its table definitions, then enter one SELECT or WITH query. The result includes column names and up to 1,000 rows. Download the result as JSON.
The original database remains unchanged. Queries run in an isolated browser worker and stop after 15 seconds.
Worked example
The example table animals contains Octopus with 8 arms and Crab with 2 claws. SELECT SUM(limbs) AS total FROM animals returns 10.
Cite this page
ToolOctopus. “SQLite database studio.” Updated . https://tooloctopus.com/sqlite-database-studio.
Add an access date if your instructions require one.
Citation formatting uses citeproc-js by Frank Bennett and Citation Style Language styles. License and source code.