SQLite database studio

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

Privacy: runs in your browser

This tool processes your input in this browser. Inputs and results are excluded from analytics. 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. When a button sends your result to another tool, it waits in this tab until that tool opens it, for up to a minute, and is then deleted.

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.

More
Keyboard shortcuts

Sharing and starting over

A copied link includes what you entered and your settings, so anyone with it can see them. Leave private text out. Files and results are not included; random draws are made again.

Start over puts the tool back to its starting values and closes any open file or device. Drafts you saved stay on this device until you delete them.

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

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

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.

Find a tool

Type a task, a unit pair, a sum or a time zone. ↓ to choose, Enter to open.