How to Run SQL Queries in SQLite Browser

Once you've loaded a database (or created an empty one), you can run any SQLite-compatible SQL using the built-in query editor.

Running a Query

Type your SQL in the query editor panel on the right side of the screen.
Click the Run button to execute.
Results appear in the Results tab at the bottom, along with the execution time.

Quick Table Inspection

Click any table name in the Tables tab to automatically run a SELECT query and view its contents in the Results tab.

Query History

Every query you execute is saved to the History tab (up to 20 entries). Click any past query to re-run it. History is stored in your browser's IndexedDB and persists across sessions — even after the database data is gone.

Example Queries

SELECT name, type FROM sqlite_master;

PRAGMA table_info('your_table');

CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT);

INSERT INTO users (name, email) VALUES ('Alice', '[email protected]');

SELECT sqlite_version();

Tips

You can run any SQL — SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, DROP, etc.
Use PRAGMA commands to inspect database internals
Changes are made in memory — export the database to save them
Errors show the full SQLite error message for easy debugging