tooloctopus.

SQLite database studio

Choose a SQLite file or use the example, then query its rows.

On your device · No account
Privacy details

SQLite database studio processes your input in this browser. Inputs and results are excluded from analytics. Recent tools save tool names, visit counts and last-visit times. Saved tools store only their names. Draft saving is optional and stays on this device; delete saved text with the draft controls. Loading text from a URL is optional and contacts that server; its URL and your IP address are visible to the server. An optional “Use in” action keeps a handoff in this tab. The next tool removes it on arrival and ignores it if more than a minute has passed.

Copy link includes the inputs you choose to share in the address. Anyone with that link can reopen them. Files and generated results are excluded. Password and key tools share settings only.

Conversion options

Result

Read-only SQLite database files up to 10 MB. No password-protected databases, extensions, attachments or writes. Each query starts from the original file. Results stop at 1,000 rows; large integers are strings and blobs are hexadecimal objects. A query timeout clears the result.
Reset reloads the tool with its starting values and releases open files and device controls. Saved drafts stay on this device until you delete them.
Links include your inputs and settings. Anyone with the link can see them, so leave out private text. Files and generated results are left out; random draws run again.
Keyboard shortcuts
Updated 
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.
Next: SQL formatter
A 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.
Next: JSON formatter
Before you use the result
Read-only SQLite database files up to 10 MB. No password-protected databases, extensions, attachments or writes. Each query starts from the original file. Results stop at 1,000 rows; large integers are strings and blobs are hexadecimal objects. A query timeout clears the result.
Cite this page
ToolOctopus. “SQLite database studio.” Updated 2026-09-29. 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. Licence and source code.
Find a tool
Search by task. Use ↓ and ↑ to choose, Enter to open.